…’t switch it on and off without restarting server until MySQL 5.0. What can you do in MySQL 5.0 and below ? Use… get all queries logged as slow queries (with times) and as you can change long-query-time online you can effectively enable and disable debug logging live…
Post: Enabling/Disabling query log without server restart in MySQL 5.0
September 13, 2007 By 13 Comments
Post: Slow Query Log analyzes tools
September 6, 2006 By 83 Comments
…Slow Query Log – Especially after the changes to log all queries slow query log may be growing too rapidly to follow, so we implemented slow query log filter (based on parse_mysql_slow_log…query_time without restarting server so it is easy to get sample of all queries…
Post: Reasons for MySQL Replication Lag
July 29, 2011 By 6 Comments
…MySQL configuration ? OS Configuration or Hardware configuration or could have anyone changed it without…1, enabling log_slave_updates, setting innodb_flush_log… cause performance problems. MySQL Restart MySQL Restarts may include …query-digest (Percona Server marks Slave Thread in slow query log…
Post: Updated msl (microslow) patch, installation walk-through!
April 20, 2008 By 17 Comments
…log_slow_filter. log-slow-queries[=name] Log slow queries to this log file. Defaults logging to hostname-slow.log file. Must be enabled to activate other slow log…
Comment: Database problems in MySQL/PHP Applications
November 6, 2006 By 12 Comments
…query-time=5 log-slow-queries=/apps/log/slow-query interactive_timeout=300 wait_timeout=300 thread_cache = 40 max_connections=500 query…
