…| ON | | slow_query_log_file | /var/lib/mysql/slow_query.log | for compatibility with MySQL 5.1 and | userstat_running | OFF | …| | | innodb_locks_held.patch | Add locks held, remove locked records in SHOW INNODB STATUS | 1.0 | Baron Schwartz | GPL | Bug #29126 fix | | microslow_innodb.patch | …
Post: New patches, new builds
September 5, 2008 By 24 Comments
… Debian | | microslow_innodb.patch | Extended statistics in slow.log | 1.0 | Percona | GPL | | | split_buf_pool_mutex_fixed_optimistic_safe.patch | InnoDB patch to … InnoDB separately, install it and run mysql with option –skip-innodb. We think InnoDB plugin is stable enough to use it with MySQL …
Post: Percona build7 with latest patches
November 14, 2008 By 26 Comments
…for MySQL 5.0.67 build 7 which include patches we recently announced. The -percona release includes: | innodb_check_defrag.patch | …| | innodb_locks_held.patch | Add locks held, remove locked records in SHOW INNODB STATUS | 1.0 | Baron Schwartz | GPL | Bug #29126 fix | | microslow_innodb.patch |…
Post: Updated msl (microslow) patch, installation walk-through!
April 20, 2008 By 17 Comments
… all the recent MySQL releases. To remind anyone who has not yet come across this piece of code. msl (microslow) patch was developed… patch for MySQL 5.0.56 msl patch for MySQL 5.0.45 with InnoDB extensions msl patch for MySQL 5.0.51a with InnoDB extensions msl patch for MySQL…
Comment: Optimizing slow web pages with mk-query-digest
April 12, 2011 By 14 Comments
… patches that you can apply. The patch you want here is microslow_innodb.patch. I would however recommend to use a more recent version of MySQL and in fact without modifications, the patch that…
Comment: Optimizing slow web pages with mk-query-digest
April 7, 2011 By 14 Comments
… patches that you can apply. The patch you want here is microslow_innodb.patch. I would however recommend to use a more recent version of MySQL and in fact without modifications, the patch that…
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… sorting was done through temporary files. INNODB USAGE The final part are the InnoDB usage statistics. MySQL currently allows you to see many…
Post: Percona builds with Percona patchsets
July 16, 2008 By 35 Comments
…microslow patch (enables microsecond resolution in slow logs) execution plan (show info about query execution in slow log) InnoDB statistic (show extended InnoDB…
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. … query; MySQL was run with default settings except following: [mysqld] user=root max_connections=3000 innodb_log_file_size=128M innodb_flush_log… to know how much from performance degradation caused by the microslow patch itself. Let’s do the same tests but logging to…
Post: Percona RPMS for RedHat 5 / CentOS 5 x86_64
July 31, 2008 By 4 Comments
…slow-log and InnoDB statistics. You can read more here http://www.mysqlperformanceblog.com/2008/04/20/updated-msl-microslow-patch-installation-walk-through/ User / Table / Index statistics (Google’s patch). More here http://www.mysqlperformanceblog.com/2008/04/24/mysql-…
