… are not going to have good performance results. Prior to 5.6 foreground threads were responsible for moving pages to the… 5.1 competitive with 5.6 (http://mysqlha.blogspot.com/2013/02/mysql-56-is-much-faster-on-io-bound.html) but that patch can’t be used in 5.6. In 5.6 a background thread, buf_flush…
Comment: MySQL and Percona Server in LinkBench benchmark
May 8, 2013 By 18 Comments
… are not going to have good performance results. Prior to 5.6 foreground threads were responsible for moving pages to the… 5.1 competitive with 5.6 (http://mysqlha.blogspot.com/2013/02/mysql-56-is-much-faster-on-io-bound.html) but that patch can’t be used in 5.6. In 5.6 a background thread, buf_flush…
Comment: Percona Server 5.5.30 with TokuDB for MySQL
April 29, 2013 By 26 Comments
Building from either Percona’s patch above, or TokuDB for MySQL or TokuDB for MariaDB, I … by target “tokudb” in directory /data/tmp/mariadb-5.5.30-tokudb-7.0.1/storage/tokudb TOKUPORTABILITY_LIB linked by target “tokudb” in directory /data/tmp/mariadb-5.5.30-tokudb-7.0.1/storage/tokudb Any ideas anyone?
Comment: Benchmarking Percona Server TokuDB vs InnoDB
May 9, 2013 By 32 Comments
… the test on 5.6 and load data infile concurrently results for two threads is 20 times slower then 1 file after… as expected. Mark did you cover this case in your patches ? Add my vote on compression as we are facing more…
Post: Introducing percona-patches for 5.1
February 9, 2010 By 21 Comments
… INDEX_STATISTICS). Despite having many requests to port these patches to 5.1, we simply haven’t had the bandwidth as our main… work to move the patches to 5.1. To refresh, the most interesting patches are: Performance patches for InnoDB ®. Although many patches are present in… the patches are available only in source code, you can get them from Launchpad https://code.launchpad.net/~percona-dev/percona-patches/5.1…
Post: MySQL 5.0, 5.1 and Innodb Plugin CPU Efficiency
December 3, 2008 By 15 Comments
… is some gain for MySQL from read-write lock split patch (found in Percona Builds) though it is not very significant… effect of this patch we only use this patch not full patch set in testing. MySQL 5.1 is 4% slower than MySQL 5.0 with… hard to say anything about CPU efficiency. The RW-Lock patch is best in this case. It shows increased performance while…
Post: Percona Server 5.1.58-12.9
August 17, 2011 By 2 Comments
…. Blueprint:utf8-general50-ci-5.1 (Alexey Kopytov). SHM Buffer Pool has been removed The ”SHM” buffer pool patch has been removed due… platform-specific distribution: The compilation of the Response Time Distribution patch has been fixed on Solaris (supported platform) and Windows (experimental…
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’s also available for the latest 5.1. Because MySQL went through a lot of internal changes, the patch…. For the patch to work you must of course enable slow logging with –slow-query-log parameter. MySQL 5.1 has this nice…
Post: Multiple purge threads in Percona Server 5.1.56 and MySQL 5.6.2
May 3, 2011 By 13 Comments
… Server 5.1 supports multiple purge threads too, although using more than one is considered experimental at the moment. Unfortunately this patch hasn’t been ported to Percona Server 5.5 yet. Let’s test these two… 5.6 tuning. MySQL 5.6.2 Results With Purge Sleeps Removed I’ve made a tiny change along these lines (the patch…
Post: Announcing Percona Server 5.1.65-14.0
September 4, 2012 By Leave a Comment
Percona is glad to announce the release of Percona Server 5.1.65-14.0 on September 4th, 2012 (Downloads are available… Software Repositories). Based on MySQL 5.1.65, including all the bug fixes in it, Percona Server 5.1.65-14.0 is now… INFORMATION_SCHEMA table INNODB_PATCHES (actually XTRADB_ENHANCEMENTS) as it was out of date and isn’t in 5.5 or later either…
