… week at Percona Live, I delivered a six-hour tutorial about Percona XtraDB Cluster (PXC) for MySQL. I actually had more … to continue replication. This setting traditionally defaulted to 0.5, meaning the queue had to fall below 50% of …T 0 29 0 0 0 0 1.0 0 109 0 0 09:22:26 myclu P 3 3 node3 …
Post: Percona builds with Percona patchsets
July 16, 2008 By 35 Comments
…. Here are links to the source releases: mysql-5.0.62-percona.tar.bz2 md5:0d8a37e09eca93cde6170866293a82ff mysql-5.1.26-percona.tar.bz2 md5:0574b38755786a97bc476058051cbe82 You can find the individual patches here: http://www.mysqlperformanceblog.com/mysql-patches/ Besides standard 5.1, we…
Post: Is MySQL 5.6 slower than MySQL 5.5?
February 18, 2013 By 23 Comments
…Percona we surely will be doing fine tuning for our Percona Server for MySQL version 5.6 release. Another thing to remember about MySQL 5…MySQL 5.5 is 26% faster compared to MySQL 5.6 and if you disable Performance Schema the difference is still 11% with 13% difference between MySQL 5…
Post: Announcing Percona Server 5.5.25a-27.1
July 21, 2012 By Leave a Comment
… and from the Percona Software Repositories). Based on MySQL 5.5.25a, including all the bug fixes in it, Percona Server 5.5.25a-27.1 is now the current stable release in the 5.5… introduced with ssl connections count in statistics tables in Percona Server 5.5.24-26.0. Bug fixed #1008278 (Vladislav Lesin). PAM authentication plugin…
Post: Identifying the load with the help of pt-query-digest and Percona Server
December 29, 2011 By 3 Comments
…Percona Server. Another great thing about Percona Server is the ability to enable logging atomically, not just for new connections as in MySQL…options # 8 0x4C16888631FD8EDB 0.1160 1.4% 5 0.0232 1.00 0.00 SELECT film… part of the output: # Query 1: 0.26 QPS, 0.00x concurrency, ID 0x92F3B1B361FB0E5B at…
Post: Testing the Group Commit Fix
July 13, 2011 By 13 Comments
… results of my testing of the new Group Commit in Percona Server 5.1. As background information, the problem appears when you have… cache online. There are two versions tested: Percona Server 5.1.57 – released and Percona Server 5.1.57 with the Group Commit Fix applied. The….12 2288.33 16 3098.33 3409.97 32 3180.26 3662.40 64 3074.08 3860.01 128 2765.78…
Post: New patches, new builds
September 5, 2008 By 24 Comments
… 5.0.62, 5.0.67 and 5.1.26 versions. One of biggest changes we separated releases of 5.0 into two branches. First, just “-percona… it and run mysql with option –skip-innodb. We think InnoDB plugin is stable enough to use it 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 added…
Post: ALTER TABLE: Creating Index by Sort and Buffer Pool Size
June 27, 2012 By 4 Comments
… in terms of data and index size: mysql> show table status like “sbtest” \G *************************** 1. row *************************** Name: sbtest Engine: InnoDB Version: 10… a lot faster. P.S The tests were done with Percona Server 5.5.24-26.0
Post: Building Indexes by Sorting In Innodb (AKA Fast Index Creation)
June 19, 2012 By 2 Comments
Innodb can indexes built by sort since Innodb Plugin for MySQL 5.1 which is a lot faster than building them through insertion… | alter table sbtest add key(c) 1MB 34 sec 8MB 26 sec 100MB 21 sec 128MB 17 sec REBUILD 37 sec… table rebuild could have done fast too. Results are from Percona Server 5.5.24
Post: Faster MySQL failover with SELECT mirroring
February 1, 2009 By 9 Comments
… can fail over in both directions. Aside from MySQL Cluster, which is more special-purpose, this is …to handle the write workload. Since we’re running Percona‘s patched server, we can actually measure what’…site.user_achievements 1.36 1.20 0.35 site.clicks 1.26 3.05 5.13 site.actions_finished 1.14 0….
