View previous topic :: View next topic |
Author |
Message |
DeathFire n00b
Joined: 01 Jul 2004 Posts: 51 Location: Canada
|
Posted: Wed Oct 18, 2006 3:54 pm Post subject: Odd files in /var/lib/mysql |
|
|
I was looking at my disk usage and was wondering where it was all being used up. I tracked it down to a bunch of files in /var/lib/mysql
I know that the databases are stored in here, but some of them I am not recognizing and I am having problems finding out what they might be.
Code: | www mysql # ls -lsSh
total 22G
1.1G -rw-rw---- 1 mysql mysql 1.1G Sep 16 11:55 www-bin.000015
1.1G -rw-rw---- 1 mysql mysql 1.1G Sep 29 12:51 www-bin.000022
1.1G -rw-rw---- 1 mysql mysql 1.1G Sep 22 13:00 www-bin.000018
1.1G -rw-rw---- 1 mysql mysql 1.1G Oct 12 11:28 www-bin.000028
1.1G -rw-rw---- 1 mysql mysql 1.1G Oct 5 13:32 www-bin.000025
1.1G -rw-rw---- 1 mysql mysql 1.1G Oct 7 13:34 www-bin.000026
1.1G -rw-rw---- 1 mysql mysql 1.1G Sep 26 13:08 www-bin.000020
1.1G -rw-rw---- 1 mysql mysql 1.1G Oct 16 10:20 www-bin.000030
1.1G -rw-rw---- 1 mysql mysql 1.1G Sep 18 11:58 www-bin.000016
1.1G -rw-rw---- 1 mysql mysql 1.1G Sep 13 20:15 www-bin.000014
1.1G -rw-rw---- 1 mysql mysql 1.1G Oct 14 11:34 www-bin.000029
1.1G -rw-rw---- 1 mysql mysql 1.1G Oct 3 13:24 www-bin.000024
1.1G -rw-rw---- 1 mysql mysql 1.1G Sep 24 12:57 www-bin.000019
1.1G -rw-rw---- 1 mysql mysql 1.1G Sep 28 13:11 www-bin.000021
1.1G -rw-rw---- 1 mysql mysql 1.1G Oct 1 13:26 www-bin.000023
1.1G -rw-rw---- 1 mysql mysql 1.1G Sep 20 12:25 www-bin.000017
1.1G -rw-rw---- 1 mysql mysql 1.1G Oct 17 23:17 www-bin.000031
1.1G -rw-rw---- 1 mysql mysql 1.1G Sep 6 19:47 www-bin.000013
1.1G -rw-rw---- 1 mysql mysql 1.1G Aug 29 16:12 www-bin.000012
1.1G -rw-rw---- 1 mysql mysql 1.1G Aug 3 14:18 www-bin.000011
1.1G -rw-rw---- 1 mysql mysql 1.1G Oct 10 11:46 www-bin.000027
941M -rw-rw---- 1 mysql mysql 940M Jul 26 06:36 www-bin.000007
31M -rw-rw---- 1 mysql mysql 31M Oct 18 09:44 www-bin.000032
11M -rw-rw---- 1 mysql mysql 10M Oct 11 14:39 ibdata1
5.1M -rw-rw---- 1 mysql mysql 5.0M Oct 17 23:17 ib_logfile0
5.1M -rw-rw---- 1 mysql mysql 5.0M Mar 2 2006 ib_logfile1
216K -rw-rw---- 1 mysql mysql 210K Mar 2 2006 www-bin.000002
72K -rw-rw---- 1 mysql mysql 65K Jul 27 08:34 www-bin.000008
16K drwx------ 2 mysql mysql 16K Sep 14 11:07 moodle
12K drwx------ 2 mysql mysql 12K Sep 29 11:59 oldmoodle
12K -rw-rw---- 1 mysql mysql 9.9K Mar 2 2006 www-bin.000001
8.0K drwx------ 2 mysql mysql 8.0K May 26 09:19 counselling
8.0K drwx------ 2 mysql mysql 8.0K Oct 2 15:08 gateway
8.0K drwx------ 2 mysql mysql 8.0K Sep 29 10:32 zpgallery
8.0K -rw-rw---- 1 mysql mysql 6.3K Jul 27 10:26 www-bin.000010
4.0K drwx------ 2 mysql mysql 4.0K Mar 30 2006 alumni
4.0K drwx------ 2 mysql mysql 4.0K Jul 17 12:28 animation
4.0K drwx------ 2 mysql mysql 4.0K Jul 25 14:28 awq
4.0K drwx------ 2 mysql mysql 4.0K Jul 17 12:33 basketball
4.0K drwx------ 2 mysql mysql 4.0K Jul 25 13:46 cactidb
4.0K drwx------ 2 mysql mysql 4.0K Jul 25 14:30 clp
4.0K drwx------ 2 mysql mysql 4.0K Jul 17 12:35 extracur
4.0K drwx------ 2 mysql mysql 4.0K Aug 16 15:08 helpdesk
4.0K drwx------ 2 mysql mysql 4.0K Jul 17 12:35 housepoints
4.0K drwx------ 2 mysql root 4.0K Mar 2 2006 mysql
4.0K drwx------ 2 mysql mysql 4.0K Aug 16 14:35 oneorzero
4.0K drwx------ 2 mysql mysql 4.0K Jul 27 10:24 phpmyadmin
4.0K drwx------ 2 mysql mysql 4.0K Jul 17 12:35 prenessac
4.0K drwx------ 2 mysql mysql 4.0K Jul 17 12:36 track
4.0K drwx------ 2 mysql mysql 4.0K Jul 25 14:22 unitplan
4.0K drwx------ 2 mysql mysql 4.0K Jul 17 12:37 users
4.0K drwx------ 2 mysql mysql 4.0K Jun 7 10:28 zpphpwebnews
4.0K drwx------ 2 mysql mysql 4.0K Oct 2 15:03 zpresource
4.0K -rw-rw---- 1 mysql mysql 544 Oct 17 23:17 www-bin.index
4.0K -rw-rw---- 1 mysql mysql 189 Mar 3 2006 www-bin.000005
4.0K -rw-rw---- 1 mysql mysql 79 Mar 2 2006 www-bin.000003
4.0K -rw-rw---- 1 mysql mysql 79 Mar 3 2006 www-bin.000004
4.0K -rw-rw---- 1 mysql mysql 79 Mar 6 2006 www-bin.000006
4.0K -rw-rw---- 1 mysql mysql 79 Jul 27 02:42 www-bin.000009
|
The ones I am wondering about are all of the www-bin.0000XX files. What are these? Why do I have so many that are 1.1GB? I can't seem to find anything on here, the MySQL site or Google regarding this. |
|
Back to top |
|
|
Andre n00b
Joined: 27 Apr 2002 Posts: 16 Location: Netherlands
|
|
Back to top |
|
|
|