… has not yet come across this piece of code. msl (microslow) patch was developed a few years ago to allow more precise….0.51a) % patch -p1 < ../patch-mysql-5.0.51a-msl.diff patching file include/my_time.h patching file scripts/mysqldumpslow.sh patching file sql-common/my_time.c patching file sql/filesort.cc patching file sql/log.cc patching file…
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 …. Because MySQL went through a lot of internal changes, the patch had to be written from scratch. It introduces some minor… tables mysql.general_log and mysql.slow_log respectively. The patch will not work as intended with those tables, because there…
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… query SELECT COUNT(1) FROM t2; Important note: Although the patch was tested and run successfully under stress with both synthetic…
Post: Microslow patch for 5.0.37
June 6, 2007 By 2 Comments
Just short message that patch enables microsecond resolution in slow-log (see more http://www…..mysqlperformanceblog.com/files/patches/patch.slow-micro.5.0.37.diff The patch for 5.0.41 : www.mysqlperformanceblog.com/files/patches/patch.slow-micro…
Comment: Slow Query Log analyzes tools
January 12, 2007 By 84 Comments
… – 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…
Post: Binaries of MySQL 5.0.33 Community release for AMD64 / EM64T
January 12, 2007 By 37 Comments
… contains mysqld-microslow binary, the server built with our microslow patch, which enables microsecound in slow-log. More info about the patch http://www… 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
… now you can fully turn on / off query statistics for microslow patch and user statistics in runtime. Next variables were added: | slow… | 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: Percona builds with Percona patchsets
July 16, 2008 By 35 Comments
…-party patches which we think are very useful. We actually use these internally and for our customers. Current releases include: microslow patch (enables… info about some of our patches here: http://www.mysqlperformanceblog.com/2008/04/20/updated-msl-microslow-patch-installation-walk-through/ Some features…
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. … to know how much from performance degradation caused by the microslow patch itself. Let’s do the same tests but logging to…
Post: New patches, new builds
September 5, 2008 By 24 Comments
…_safe_syslog.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 | 1.0 | Percona | GPL | | | split_buf_pool_mutex_fixed_optimistic_safe.patch | InnoDB patch to…
