John Watson

Hello! My name is Watson and I’m a freelance web developer. I create web sites using the latest tech for clients of all sizes. Contact me and I’ll help you build your dream project.

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.