[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