[mythtv-users] /var/lib/mysql filled /var partition - how to clean up?
Mark Knecht
markknecht at gmail.com
Sun Oct 8 02:26:18 UTC 2006
Hi,
As the title indicates my Myth server's /var partition was filled
up today when a number of 'dragonfly-bin.xxxxxxx files in
/var/lib/mysql got too big. This caused mythfrontend to not run at
all.
dragonfly mysql # ls -la
total 1947764
drwxr-x--- 5 mysql mysql 4096 Oct 7 19:09 .
drwxr-xr-x 17 root root 4096 Jul 16 18:48 ..
-rw-r--r-- 1 mysql mysql 0 Jul 16 18:48 .keep
-rw-rw---- 1 mysql mysql 10067 Jul 16 18:54 dragonfly-bin.000001
-rw-rw---- 1 mysql mysql 370536 Jul 16 18:54 dragonfly-bin.000002
-rw-rw---- 1 mysql mysql 79 Jul 16 18:54 dragonfly-bin.000003
-rw-rw---- 1 mysql mysql 79 Jul 16 18:59 dragonfly-bin.000004
<SNIP>
-rw-rw---- 1 mysql mysql 44942717 Jul 21 18:34 dragonfly-bin.000022
-rw-rw---- 1 mysql mysql 48704460 Jul 24 14:47 dragonfly-bin.000023
-rw-rw---- 1 mysql mysql 131551639 Jul 30 19:54 dragonfly-bin.000024
-rw-rw---- 1 mysql mysql 441087294 Aug 15 09:57 dragonfly-bin.000025
-rw-rw---- 1 mysql mysql 122754846 Aug 19 11:41 dragonfly-bin.000026
<SNIP>
-rw-rw---- 1 mysql mysql 296241 Oct 7 19:21 dragonfly-bin.000041
-rw-rw---- 1 mysql mysql 920 Oct 7 19:09 dragonfly-bin.index
-rw-rw---- 1 mysql mysql 5242880 Oct 7 19:09 ib_logfile0
-rw-rw---- 1 mysql mysql 5242880 Jul 16 18:54 ib_logfile1
-rw-rw---- 1 mysql mysql 10485760 Oct 7 19:09 ibdata1
drwx------ 2 mysql root 4096 Jul 16 18:54 mysql
drwx------ 2 mysql mysql 4096 Jul 18 15:07 mythconverg
drwx------ 2 mysql root 4096 Jul 16 18:54 test
dragonfly mysql #
To get around the problem quickly I moved a couple of files to a
different partition. mythfrontend immediately started working.
I'm not sure what these files are for. How can I safely clean this up?
Thanks in advance,
Mark
More information about the mythtv-users
mailing list