Linux Ask!

Linux Ask! is a Q & A web site specific for Linux related questions. Questions are collected, answered and audited by experienced Linux users.

Feb 242010
 

Flush all MySQL log files

Answer:

MySQL default has several log files such as the error log, query log, and slow query log.

Sometimes, To perform log rotation, it is necessary to tell MySQL stop writing to these old log files, rename it and start over again.

To do so, you can execute the FLUSH LOG command in the MySQL client.

mysql> FLUSH LOG;

As a result, it will causes the MySQL to rename the current error log file with a suffix of -old and create a new empty log file.

Usually you should no need to do it manually, you should use tool such as logrotate .

Reference: http://dev.mysql.com/doc/refman/5.0/en/flush.html

 Leave a Reply

(required)

(required)

You may use these HTML tags and attributes: <a href="" title=""> <abbr title=""> <acronym title=""> <b> <blockquote cite=""> <cite> <code> <del datetime=""> <em> <i> <q cite=""> <strike> <strong>