Re: binlog file deleted accidentally
The binlogs are there for point in time recovery and for the slaves to catch up to the master. If your slave has already completed processing one of the logs, and you don't want to keep the log for point in time recovery, then you could remove it. But given that is the reason you ended up in trouble to start with, I'd be careful with that. What is your expire_logs_days set to currently? If you cannot even hold a days worth of logs then you may need to increase your drive space or store the logs in a different location with more space.
I'm not sure what you mean by the pages are caching on the server. What increases the binlog size is inserting and modifying data in the database, from whatever sources you have using the database.
--
Scott Nemes
MySQL DBA
http://www.linkedin.com/in/scottnemes
http://www.twitter.com/ScottNemes
Subject
Written By
Posted
Re: binlog file deleted accidentally
August 16, 2012 02:14PM
Sorry, you can't reply to this topic. It has been closed.
Content reproduced on this site is the property of the respective copyright holders.
It is not reviewed in advance by Oracle and does not necessarily represent the opinion
of Oracle or any other party.