MySQL Forums
Forum List  »  MySQL Administrator

Re: binlog file deleted accidentally
Posted by: Scott Nemes
Date: August 16, 2012 02:14PM

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

Options: ReplyQuote


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.