John Watson

Hello! My name is Watson and I'm a freelance developer and consultant. I create profitable web sites for clients of all sizes. Contact me and I'll help you build yours.

Fix for MySQL binlogs not deleting themselves

If you are using the expire_logs_days setting for automatic binary log removal in MySQL and your binary logs are not automatically deleting themselves (SHOW MASTER LOGS), it’s probably because the index is out of sync with the actual log folder. Manually remove the logs (/var/log/mysql) and then do RESET MASTER to get things back in sync again.