Diamond Notes

Just another WordPress weblog

Rotating Slow and General Query Logs

May 14th, 2008 | Category: MySQL

I had a need to enable general query logging on a slave yesterday.  This makes for a very big file.  So, I needed to rotate this file at least daily.  Enter Google :)  And thanks to Jim Wood and Matt Reid, I have what I need.  Now I have it cron’ed to rotate out every night.  So thanks guys!! And here is a link to the post Matt wrote about it:

http://themattreid.com/wordpress/?p=34

2 Comments so far

  1. Matt Reid May 14th, 2008 2:29 pm

    Glad that worked out well for you. :)

  2. MySQL Log Rotation « MySQL-HA May 14th, 2008 5:08 pm

    […] Log Rotation Posted in tools by mtaylor on the May 14, 2008 Ok. So I just looked at two blog posts about MySQL log rotation. While not technically incorrect, I’d like to disagree […]

Leave a reply