… (microslow) patch was developed a few years ago to allow more precise logging of query execution times into the slow log. Originally MySQL database offered… of those you want to have in your slow log. For example to have microsecond query timing and InnoDB statistics you would need…
Post: Microslow patch for 5.1.20
July 18, 2007 By 3 Comments
… to redirect query log (it’s actually called general log now) and slow log to CSV tables mysql.general_log and mysql.slow_log respectively. The patch will not work… value is in microseconds (0 means to log all queries). The new feature is that patch can allow you to log queries executed by…
Post: Slow Query Log analyzes tools
September 6, 2006 By 84 Comments
… investigated Patching Slow Query Logging – First thing we did is created a Patch which allows you to specify slow query time in microseconds rather …across 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_…
Post: The new cool MySQL patch has landed! Check your queries performance!
October 31, 2007 By 16 Comments
… choose to log all queries to see those which take less than 1s. Now long_query_time is in microseconds and you… LOGGING OF THE REPLICATED STATEMENTS Normally MySQL will not write into slow log any queries executed by the slave’s SQL thread. This patch allows you to change that behavior with the new parameter –log-slow…
Post: How Percona does a MySQL Performance Audit
November 24, 2008 By 17 Comments
… server that has the Percona patches for microsecond logging and additional information in the slow query log output. The stock MySQL server’s limitation of one… use a patched binary, we can use MySQL Proxy, packet sniffing, or other techniques to get more information than the slow log gives us…
Post: New patches, new builds
September 5, 2008 By 24 Comments
…patch | Patch allows redirect output of error.log to syslog-ng | 1.0 | Percona | GPL | Ported from Debian | | microslow_innodb.patch | Extended statistics in slow.log…execution with microseconds granularity. mysql> SELECT * FROM INFORMATION_SCHEMA.PROCESSLIST; …
Post: Backport of micro-time patch to mysql 4.1
October 1, 2006 By 9 Comments
… decided to make backport of patch to slow-log queries. The patch allows to specify time of slow queries in microseconds and is very helpful in a fight with problematic queries. 4.1 Patch is available here (The original patch…
Post: Guess what?! Microsecond slow query timing finally available in MySQL!
August 29, 2007 By 5 Comments
Vadim asked me yesterday to update Microslow patch for 5.1.21, because the previous one I wrote … new MySQL release. Imagine the expression on my face after I unpacked the sources and found out that MySQL incorporated the patch to… far I noticed one addition to my code which is logging the microtime statistics into TABLE type…
Post: Percona builds with Percona patchsets
July 16, 2008 By 35 Comments
… include: microslow patch (enables microsecond resolution in slow logs) execution plan (show info about query execution in slow log) InnoDB …mysql-5.1.26-percona.tar.bz2 md5:0574b38755786a97bc476058051cbe82 You can find the individual patches here: http://www.mysqlperformanceblog.com/mysql-patches…
Post: Announcing Percona Server for MySQL version 5.5.29-30.0
February 26, 2013 By Leave a Comment
…. New Features: Ported the Thread Pool patch from MariaDB. This feature enables the … line option innodb_changed_pages_limit. MySQL option handling would then shadow the …Time in slow query log was displayed incorrectly when slow_query_log_timestamp_precision variable was set to microseconds. Bug …
