…’t graph the performance on the first 100M rows). The minimum performance troughs occur just as the partition switches. So performance gets worse…://bazaar.launchpad.net/~mdcallag/mysql-patch/mytools/annotate/head%3A/bench/ibench/iibench.py) is that it measures query performance too, so if…
Comment: MariaDB 5.3 is released as GA!
March 7, 2012 By 17 Comments
… only want to patch security issues whereas MySQL also fixes non-security bugs like server crash, wrong result or just performance regressions. From my point of view the distros insisting on sticking to the original version they released and cherry pick patches…
Post: New patches, new builds
September 5, 2008 By 24 Comments
…patches. Second is “-percona-highperf” release, which contains experimental patches that can improve performance significantly. On this stage “percona-highperf” contains patches…PATCHES command, which is based on Jeremy Cole’s patch mysql> show patches; …
Post: Introducing percona-patches for 5.1
February 9, 2010 By 21 Comments
… on their blog. The main improvements come in both performance gains and improvements to diagnostics (such as the improvements to… to move the patches to 5.1. To refresh, the most interesting patches are: Performance patches for InnoDB ®. Although many patches are present in…, InnoDB timing, profiling info – Userstat patch Different patches to help with day to day usage of MySQL ® Two new features which not…
Post: MySQL extensions for hosting
April 24, 2008 By 11 Comments
… was asked to isolate some functionalities from Mark Callaghan’s MySQL patch bundle. They were extensions adding per-user and per-table… bit ugly solution. That is where this patch can be very useful. With simple MySQL SHOW command it gives you the basic… statements which all currently fall under Other_commands a few MySQL performance counters broken down by users (full joins, table scans, disk…
Post: How Percona does a MySQL Performance Audit
November 24, 2008 By 17 Comments
… these, there’s a full explanation in our book, High Performance MySQL 2nd Edition (it’s not in the first edition). From… at this point, it looks like MySQL is probably a good place to look for performance problems. Everything I’ve done up… a high-performance system is virtually every query.) If it’s not possible to use a patched binary, we can use MySQL Proxy…
Post: Helgrinding MySQL with InnoDB for Synchronisation Errors, Fun and Profit
November 24, 2011 By 2 Comments
… the whole MySQL testsuite is not very practical due to 100x slowdown imposed by Helgrind). For this purpose, I have patched mysql-test-run.pl to accept a new option: –helgrind. The patch is a copy-paste-modify… serialized in memory after the reset. A speculative processor might perform the read first, which could leave a waiting thread hanging…
Post: Multiple purge threads in Percona Server 5.1.56 and MySQL 5.6.2
May 3, 2011 By 13 Comments
… than one is considered experimental at the moment. Unfortunately this patch hasn’t been ported to Percona Server 5.5 yet… tuning. MySQL 5.6.2 Results With Purge Sleeps Removed I’ve made a tiny change along these lines (the patch can… I am sure that next MySQL 5.6 versions will contain a fixed and much better performing implementation, which I am looking…
Page: Consulting for MySQL
July 31, 2006 By
… with: MySQL Performance Optimization and Scaling – All aspects of MySQL Performance Optimization and Scaling Consulting – Hardware and OS configuration, MySQL Server …. Custom features and patches for MySQL We can help with developing custom features and extensions for MySQL, help fixing…
Post: MySQL 5.5.8 and Percona Server: being adaptive
December 20, 2010 By 25 Comments
… have the best peak performance, but also stable and predictable performance. I refer you to Peter’s post, Performance Optimization and Six Sigma. In Percona Server (and actually even before that, in percona-patches builds for 5… fix the buffer pool scalability issue. Let’s see how MySQL performance changes for the last workload if we set innodb_buffer…
