Purging MySQL binary logs

The 60GB root partition of my MythTV server has been gradually filling up and finally reached capacity over the weekend. The culprit turned out to be the MySQL binary logs which have never been purged since I set server up in early 2007. Weighing in at 26GB it was time for them to go.

All that was needed is a flush and reset to purge the logs.

mysql> flush logs;
mysql> reset master;

posted by James Gemmell on Wed, 04 Nov 2009 at 21:33 | permalink | tags: ,