…log rotation. Putting it all together Here is a logrotate configuration file for a slow log that illustrates these best practices: /var/mysql/slow_query.log…
Comment: Rotating MySQL slow logs safely
April 19, 2013 By 7 Comments
… stanza 2a. Slow logging is paused (set global long_query_time=2000;) 2b. There is a small wait for buffered logs to be flushed (select sleep(2);) 2c. File handles are reopened (FLUSH LOGS 
2d. Slow logging resumed (set global long_query_time=@lqt…
Post: Get Me Some Query Logs!
November 22, 2012 By 14 Comments
… slow_query_log=1 Discovering slow_query_log_file=mysql-slow.log Discovering long_query_time=60.000000 Setting long_query_time=0 Setting slow_query_log_file=mysql-slow.log-full-20121122112413 Setting slow_query_log=1 Flushing slow query log Sleeping 5 seconds… done. Restoring slow_query_log_file=mysql-slow.log Restoring long_query_time=60.000000 Restoring slow_query_log=1 Flushing logs…
Post: Enabling/Disabling query log without server restart in MySQL 5.0
September 13, 2007 By 13 Comments
… 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… 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… you will need to enable queries you can symlink it to something else and run “flush logs” so logs are reopened and written to…
Post: Ultimate MySQL variable and status reference list
January 8, 2011 By 4 Comments
…per_tableblogpercona.commanual innodb_flush_log_at_trx_commitblogpercona.commanual innodb_flush_methodblogpercona.commanual …commanual Slow_launch_threadsblogpercona.commanual slow_launch_timeblogpercona.commanual Slow_queriesblogpercona.commanual slow_query_logblogpercona.commanual slow_query_log_…
Comment: New Forum Categories: Help Wanted, For Hire
March 5, 2013 By 1 Comment
…home/mysqld/mdmp/tmp slow_query_log=mdmp_slow_queries.log # binary logging and replication binlog_cache_size=1M binlog_format=MIXED log-slave-updates log-bin=mdmp_…innodbspace3.dbf:1073741824:autoextend innodb_log_files_in_group=2 innodb_flush_log_at_trx_commit=1 innodb_flush_method=O_DIRECT innodb_…
Comment: MySQL Server Memory Usage
September 1, 2006 By 21 Comments
…/mysql/mysql.pid datadir=/db/disk2/mysql/data log-bin=/var/log/mysql/log log-slow-queries=/var/log/mysql/slow-queries.log max_connections=650 open_files_limit=6144…=15 # CHANGED from 50 innodb_log_files_in_group=3 innodb_flush_log_at_trx_commit=0 #innodb_log_file_size=400M # Approx 20…
Post: Announcing Percona Server for MySQL version 5.5.29-30.0
February 26, 2013 By Leave a Comment
… was doing dirty buffer pool flush list reads to make its adaptive flushing decisions. Fixed by acquiring the flush list mutex around the… being logged even if they weren’t enabled for the slow query log. Bug fixed #730173 (Laurynas Biveinis). Fixed the incorrect help text for slow_query_log…
Post: Replaying database load with Percona Playback
October 25, 2012 By 9 Comments
…valuable information: SET GLOBAL slow_query_log=1; SET GLOBAL long_query_time=0; With long_query_time we are logging all queries that are being … flush logs every second instead of every commit (innodb_flush_log_at_trx_commit=2): Executed 429467 queries Spent 00:00:51.605932 executing queries …
Post: Announcing Percona Server for MySQL version 5.1.67-14.4
March 8, 2013 By Leave a Comment
… handling the XtraDB changed page tracking log files. Bugs Fixed: Time in slow query log was displayed incorrectly when slow_query_log_microseconds_timestamp variable was set… flushing. Bug fixed #1117067 (Laurynas Biveinis). InnoDB and the query plan information were being logged even if they weren’t enabled for the slow query log…
