mythconverg itself is only 34Mbytes, but /var/lib/mysql is full of files
named (myth1 is the hostname):
myth1-bin.000001
myth1-bin.000002
myth1-bin.000003
...
basicly one for each day operations occur on the database.
Can they be safely deleted/compressed or reduced in size somehow? I
have run optimise table and the database itself is fine. I suspect that
some of the larger files are to do with hardware related lockups
requiring a database repair after recovery.
You've enabled binary logs, mostly being used for replication.
You may start mysql client and
PURGE MASTER LOGS TO 'myth1-bin.XXXXXX'
as root. Where XXXXXX is the max number.
HTH,
Sasha
--
[email protected] mailing list
