June 20, 2013

Post: Impact of logging on MySQL’s performance

Introduction When people think about Percona’s microslow patch immediately a question arises how much logging impacts on … 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…

Post: New patches, new builds

…| Percona | GPL | Ported from Debian | | microslow_innodb.patch | Extended statistics in … with microseconds granularity. mysql> SELECT * FROM INFORMATION_SCHEMA.PROCESSLIST; +—-+——+———–+——+———+——+———–+———————————————-+———+ | ID | …

Comment: Optimizing slow web pages with mk-query-digest

… you want here is microslow_innodb.patch. I would however recommend to use a more recent version of MySQL and in fact….rpm file will fail at two hunks against mysql-5.0.77. On vanilla mysql-5.0.92 it applies cleanly. Mind…

Comment: Optimizing slow web pages with mk-query-digest

… you want here is microslow_innodb.patch. I would however recommend to use a more recent version of MySQL and in fact….rpm file will fail at two hunks against mysql-5.0.77. On vanilla mysql-5.0.92 it applies cleanly. Mind…

Post: Percona RPMS for RedHat 5 / CentOS 5 x86_64

… 5 / CentOS 5 x86_64 platform. http://www.mysqlperformanceblog.com/mysql/RPM/RHEL5/5.0.62/ There was question what patcheset…-microslow-patch-installation-walk-through/ User / Table / Index statistics (Google’s patch). More here http://www.mysqlperformanceblog.com/2008/04/24/mysql

Comment: Microslow patch for 5.0.37

The 5.0.41 patch seems to be a copy of the 5.0.37 patch!? I see no difference and it sais diff -ur mysql-5.0.37/include/my_time.h mysql-5.0.37-microslow/include/my_time.h

Comment: Percona builds with Percona patchsets

… patches because of the easier database optimization (microslow, anyone?). I am too lazy to build mysql with the Percona patchset, for the…

Post: Percona build7 with latest patches

We made new binaries for MySQL 5.0.67 build 7 which include patches we recently … INNODB STATUS | 1.0 | Baron Schwartz | GPL | Bug #29126 fix | | microslow_innodb.patch | Extended statistics in slow.log | 1.1 | Percona…

Post: Finding what Created_tmp_disk_tables with log_slow_filter

… | Luckily this client was running the Percona patched version of MySQL. The microslow patch adds a very useful feature, the ability to…

Comment: Updated msl (microslow) patch, installation walk-through!

… is available for all the recent mysql releaseshttp://www.mysqlperformanceblog.com/2008/04/20/updated-msl-microslow-patch-installation-walk-through…Flow…