Re: MySQL Error Logs and Slow Query Logs Purging
Posted by: Rick James
Date: March 27, 2015 12:27AM

Sorry, I have not tackled this problem in a few years. It depends on what version (newer version make it easier) and what OS (Unix works quite differently than Windows when it comes to open files being deleted.)

If you are willing to restart mysqld: stop it; mv (rename) the files; and restart it.

If you are not willing to bounce mysqld, I am not sure it is possible; at least not on both systems. The question is whether FLUSH LOGS will force mysqld to close and reopen the logs. If it does not, the the old log will continued to be written to.

Options: ReplyQuote


Subject
Written By
Posted
Re: MySQL Error Logs and Slow Query Logs Purging
March 27, 2015 12:27AM


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.