…’t switch it on and off without restarting server until MySQL 5.0. What can you do in MySQL 5.0 and below ? Use… for general query log – for example connects or queries with syntax errors will not be logged. Enable logging to /dev/null You can enable queries to say “all_queries” log and…
Post: Enabling/Disabling query log without server restart in MySQL 5.0
September 13, 2007 By 13 Comments
Comment: Slow Query Log analyzes tools
June 10, 2008 By 83 Comments
…used this patch to benchmark our production server: First, I enabled the general query log in my production server, and collected some data. I…to turn off the general query log without restarting mysql – i moved the log file aside, touched a replacement, but didn’t give the mysql user write permision…
Comment: Be careful rotating MySQL logs
December 10, 2007 By 5 Comments
… in MySQL 5.0 you can’t enable/disable general query log without restarts so if you may need it sometimes and you can’t afford server restarts you just need to have it enabled…
Post: Slow Query Log analyzes tools
September 6, 2006 By 83 Comments
…MySQL version. Now why do not we use general log instead ? Unfortunately general logs queries before queries are executed (and even parsed) so it can’t contain query…without restarting server so it is easy to get sample of all queries for some period of time and then get back to logging…
Post: Reasons for MySQL Replication Lag
July 29, 2011 By 6 Comments
…without your knowledge ? If yes this could cause problems with replication lag (and performance in general…MySQL Restart MySQL Restarts…query-digest (Percona Server marks Slave Thread in slow query log…
