… slow /path/to/slow.log By default, this outputs the top 10 most expensive queries, in total execution time. By the way, the slow query logs… use a server that has the Percona patches for microsecond logging and additional information in the slow query log output. The stock MySQL server…
Post: Get Me Some Query Logs!
November 22, 2012 By 14 Comments
…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 …script a useful complement to my upcoming talks at the Percona Live MySQL Conference in London, UK on December 3-…
Post: Analyzing Slow Query Table in MySQL 5.6
February 18, 2013 By 1 Comment
…] Next week I’m teaching an online Percona Training class, called Analyzing SQL Queries with Percona Toolkit. This is a guided tour… to the log table, query times and lock times are truncated to to integers: sql/log.cc, Log_to_csv_event_handler::log_slow(): 610… `# slow-log` FROM `mysql`.`slow_log`; GO echo “#” I host the script above in my bk-tools github project. It’s called export-slow-log-table…
Post: Replaying database load with Percona Playback
October 25, 2012 By 9 Comments
… enough data and copying the slow query log to the DEV server we can replay the load: percona-playback –mysql-host=127.0.0.1 –mysql-user=root –mysql-schema=my_db –query-log-file=slow.log Executed 429467… Percona Playback so we’re going to ignore that. Second try, add 2GB of InnoDB Log Files (innodb_log_file_size=1G, innodb_log…
Post: MySQL Binaries Percona build10
December 11, 2008 By 12 Comments
… in runtime. Next variables were added: | slow_query_log | ON | | slow_query_log_file | /var/lib/mysql/slow_query.log | for compatibility with MySQL 5.1… in slow.log | 1.1 | Percona | GPL | | | mysqld_safe_syslog.patch | Patch allows redirect output of error.log to syslog-ng | 1.0 | Percona | GPL…
Post: Slow Query Log analyzes tools
September 6, 2006 By 84 Comments
… 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… same slow query log first to fix worse queries and then come to find more optimization candidates. So “tail -f mysql-slow.log | mysql_slow_log… slow query log format as well. Update 2009-03-04: most of us at Percona now use mk-query-digest from Maatkit for slow…
Post: Announcing Percona Server for MySQL 5.5.30-30.1
March 7, 2013 By Leave a Comment
…. Bug fixed #1117067 (Laurynas Biveinis). Percona Server would do unnecessary slow log stats accounting even with the slow log disabled. Bug fixed #1123915 (Alexey Kopytov). Optimization cleanup to avoid calls related to extended slow query log…
Post: 5.0.77 / 5.0.82 -build16 Percona binaries
June 11, 2009 By 4 Comments
… patches were added: profiling_slow.patch This patch adds information from SHOW PROFILE to query information in slow.log output. profiling_server. This…-test profiling fails on 5.0.77 Bug #375494: log_slow_rate_limit logs all queries on a connection after a >1s query…-b16/ http://www.percona.com/mysql/5.0.82-b16/ The Percona patches live on Launchpad : https://launchpad.net/percona-patches and you…
Post: Introducing percona-patches for 5.1
February 9, 2010 By 21 Comments
… and improvements to diagnostics (such as the improvements to the slow log output, and INDEX_STATISTICS). Despite having many requests to port…-write locks Diagnostic patches. – We provide much more statistics in slow.log, i.e. execution plan, InnoDB timing, profiling info – Userstat patch…, you can get them from Launchpad https://code.launchpad.net/~percona-dev/percona-patches/5.1.43. Binaries are also on…
Post: Percona builds with Percona patchsets
July 16, 2008 By 35 Comments
… slow logs) execution plan (show info about query execution in slow log) InnoDB statistic (show extended InnoDB usage during query execution in slow log) … releases: mysql-5.0.62-percona.tar.bz2 md5:0d8a37e09eca93cde6170866293a82ff mysql-5.1.26-percona.tar.bz2 md5:0574b38755786a97bc476058051cbe82 You…
