MySQL Error Logs and Slow Query Logs Purging
Posted by: Ravi Teja Pattam
Date: March 20, 2015 04:24AM

Hi All,

We have Master/ Multi Slave replication in place.

Our Slow Query Logs and Error Logs are way to high on all the servers. Please let me know the safest way to purge logs without shutting down instance.

mv slow_query.log slow_query.old
flush logs;

What exactly will flush logs do here. if we run this on master are there any chances of replication break as all log files will be closed and reopened .


Options: ReplyQuote

Written By
MySQL Error Logs and Slow Query Logs Purging
March 20, 2015 04:24AM

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.