May 25, 2012

Post: Announcement of Percona XtraDB Cluster 5.5.20 GA release

…Write Set REPlication patches. It uses the Galera library, version 2.x, a generic Synchronous Multi-Master replication plugin for transactional …Galera replication overhead Percona Server 5.5.15 + Galera 21.1-beta2 State of the art: Galera – synchronous replication for InnoDB Happy clustering! …

Post: Introducing percona-patches for 5.1

Our patches for 5.0 have attracted significant interest.  You can read about … 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 XtraDB… – Userstat patch Different patches to help with day to day usage of MySQL ® Two new features which not available for 5.0: In…

Post: Microslow patch for 5.1.20

… 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… adds new. For the patch to work you must of course enable slow logging with –slow-query-log parameter. MySQL 5.1 has this…

Post: Userstats patches with information schema support

Recently, we added information schema support to Google’s userstats patch. There are three information schema tables added: user_statistics, table… information_schema.user_statistics along with show user_statistics. Links: Patch for 5.0.62 Patch for 5.1.26

Post: New patches, new builds

We made new patches, improved previous and want to announce new builds for 5.0.62, 5.0.67 and 5.1.26 versions. One of… | 442440 | 9495 | 18990 | … For 5.0-percona-highperf release we added: split_buf_pool_mutex_fixed_optimistic_safe.patch | InnoDB patch to fix buffer… with MySQL 5.1 RC, at least stable to name whole MySQL-5.1-percona release as RC. Along with previously mentioned patches, to 5.1 we…

Post: MySQL 5.0, 5.1 and Innodb Plugin CPU Efficiency

… some gain for MySQL from read-write lock split patch (found in Percona Builds) though it is not very significant for this workload. To isolate 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…

Post: Percona Server 5.1.58-12.9

… been to improve compatibility for those upgrading from MySQL 5.0 or 5.1 prior to version 5.1.24. A fix for a MySQL bug (#27877) introduced an incompatible change in collations in MySQL 5.1…. Blueprint:utf8-general50-ci-5.1 (Alexey Kopytov). SHM Buffer Pool has been removed The ”SHM” buffer pool patch has been removed due…

Post: Helgrinding MySQL with InnoDB for Synchronisation Errors, Fun and Profit

…. For a proper implementation for our purposes, Patrick has added preliminary Helgrind support to DBQP. For 5.1: mtr-helgrind-51.patch For 5.5: mtr-helgrind-55.patch Now let’s see what kind of goodies does Helgrind find on MySQL server. Let’s take a recent 5.1 bzr version (pre-5.1.61) and a single test, innodb_plugin.innodb_bug53674. The test is chosen for no particular…

Post: Multiple purge threads in Percona Server 5.1.56 and MySQL 5.6.2

… Server 5.1 supports multiple purge threads too, although using more than one is considered experimental at the moment. Unfortunately this patch hasn…_per_table max_connections=2000 table_cache=2000 Percona Server 5.1 Results For better presentation let’s also slice this data the… least for the tested setting–multiple purge thread implementation at the moment seems to be the one in Percona Server 5.1. MySQL 5

Post: Percona Server 5.1.47-rel11.0

Dear Community, Percona Server version 5.1.47-rel11.0 is available for download now. The changes in this release include: New features… global Innodb_deadlocks counter to SHOW STATUS, based on a patch by Eric Bergen (issue #569288, issue #590624). Added more tests… this release there is a uniform naming scheme for Percona binaries for 5.0 and 5.1 based packages. RPM are named as: Percona-Server…