June 19, 2013

Post: Percona Server for MySQL 5.5.31-30.3 now available

… has ported the Atomic write support for Fusion-io devices patch from MariaDB. This feature adds atomic write support for directFS…-2012-5627 vulnerability, where an unprivileged MySQL account owner could perform brute-force password guessing attack on other accounts efficiently. This…

Comment: MySQL and Percona Server in LinkBench benchmark

… lot of people are going to waste time and lose performance because of this. I am one of those people. When…_and_free_block you are not going to have good performance results. Prior to 5.6 foreground threads were responsible for…-56-is-much-faster-on-io-bound.html) but that patch can’t be used in 5.6. In 5.6…

Comment: MySQL and Percona Server in LinkBench benchmark

… lot of people are going to waste time and lose performance because of this. I am one of those people. When…_and_free_block you are not going to have good performance results. Prior to 5.6 foreground threads were responsible for…-56-is-much-faster-on-io-bound.html) but that patch can’t be used in 5.6. In 5.6…

Post: Percona Playback 0.6 for MySQL now available

… the overall performance of your MySQL database server. Percona Playback for MySQL can also help evaluate new server versions, patches and hardware…

Post: Introducing percona-patches for 5.1

… 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…, i.e. execution plan, InnoDB timing, profiling info – Userstat patch Different patches to help with day to day usage of MySQL Â…

Post: The performance effects of new patches

performance with the new patches. Then, how the patches contribute to the improvements in this case. split_buf_pool_mutex_fixed_optimistic_safe.patch… is no enough free buffers. It helps if you have performance drops when data does not fit in memory. Attention!(Windows…, If you are using fast RAID storage, and/or observe performance decrease caused by shortage of free buffers you may try…

Post: New patches, new builds

… installation patches. Second is “-percona-highperf” release, which contains experimental patches that can improve performance significantly. On this stage “percona-highperf” contains patches from Yasufumi Kinoshita (more info on Maximum performance of…

Post: Performance improvements in Percona 5.0.83 and XtraDB

… ® and also port all performance fixes to 5.0 tree. So basically we made: new split-buffer-mutex patch, which separate global… servers – XtraDB will be released with fast recovery patch – XtraDB has additional performance fixes i.e. extra UNDO and ROLLBACK segments (full….percona.com/docs/wiki/percona-xtradb:patch:start) And now 5.0-tree will contain all performance fixes and show the same…

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

… make a substantial difference for the database and application performance. Over time msl patch grew with new features to let people learn….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: The new cool MySQL patch has landed! Check your queries performance!

… be a performance killer for a busy application. Recently I have started the development of an updated version of the patch. The… 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…