… all the recent MySQL releases. To remind anyone who has not yet come across this piece of code. msl (microslow) patch was developed a few years ago to allow more precise logging of query execution times into the slow log. Originally MySQL… patch: (garfield:~/work/mysql-5.0.51a) % patch -p1 < ../patch-mysql-5.0.51a-msl.diff patching file include/my_time.h patching file scripts/mysqldumpslow.sh patching…
Post: Microslow patch for 5.1.20
July 18, 2007 By 3 Comments
Microslow patch has been there for some time, but only for earlier MySQL editions such as 4.1 and 5.0. Now it… for the latest 5.1. Because MySQL went through a lot of internal changes, the patch had to be written from scratch…) and slow log to CSV tables mysql.general_log and mysql.slow_log respectively. The patch will not work as intended with those…
Post: Binaries of MySQL 5.0.33 Community release for AMD64 / EM64T
January 12, 2007 By 37 Comments
… stantard MySQL RPMs – MySQL-microslow-5.0.33-0.glibc23.x86_64.rpm This package contains mysqld-microslow binary, the server built with our microslow patch… contains both mysqld and mysqld-microslow binaries. Source tar.gz with microslow patch (Link removed) The patch by itself 18K patch.slow-micro.5.0…
Post: MySQL Binaries Percona build10
December 11, 2008 By 12 Comments
… for microslow patch and user statistics in runtime. Next variables were added: | slow_query_log | ON | | slow_query_log_file | /var/lib/mysql… | Bug #29126 fix | | microslow_innodb.patch | Extended statistics in slow.log | 1.1 | Percona | GPL | | | mysqld_safe_syslog.patch | Patch allows redirect output of…
Post: The new cool MySQL patch has landed! Check your queries performance!
October 31, 2007 By 16 Comments
Microslow patch is used by many DBAs and developers to accurately time … RESOLUTION QUERY TIMING This is the original functionality offered by Microslow patch. The new edition is free of a tiny bug which… it in production or on any important system! The patch is available for MySQL Community 5.0.45 on Linux. May not…
Post: New patches, new builds
September 5, 2008 By 24 Comments
…PATCHES command, which is based on Jeremy Cole’s patch mysql> show patches; …microslow_innodb.patch | Extended statistics in slow.log | 1.0 | Percona | GPL | | | split_buf_pool_mutex_fixed_optimistic_safe.patch | InnoDB 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…
Comment: Slow Query Log analyzes tools
January 12, 2007 By 84 Comments
… stantard MySQL RPMs – MySQL-microslow-5.0.33-0.glibc23.x86_64.rpm This package contains mysqld-microslow binary, the server built with our microslow patch, which enables microsecound in slow-log. More info about the patch http://www.mysqlperformanceblog.com/…nalyzes-tools/ http://bugs.mysql.com…
Post: Percona builds with Percona patchsets
July 16, 2008 By 35 Comments
… about some of our patches here: http://www.mysqlperformanceblog.com/2008/04/20/updated-msl-microslow-patch-installation-walk-through/ Some … mysql-5.1.26-percona.tar.bz2 md5:0574b38755786a97bc476058051cbe82 You can find the individual patches here: http://www.mysqlperformanceblog.com/mysql-patches/ …
Post: Impact of logging on MySQL’s performance
February 10, 2009 By 8 Comments
Introduction When people think about Percona’s microslow patch immediately a question arises how much logging impacts on performance. … take more than a second to execute; logging every query; MySQL was run with default settings except following: [mysqld] user=root… to know how much from performance degradation caused by the microslow patch itself. Let’s do the same tests but logging to…
