… MySQL version 5.5.31-30.3[/caption] Percona is glad to announce the release of Percona Server for MySQL 5.5.31-30.3 on May 24, 2013 (Downloads are available here and from the Percona Software Repositories). Based on MySQL 5.5.31, including all the bug fixes in it, Percona Server 5.5.31-30.3 is now the current stable release in the 5.5…
Post: Percona Server 5.6.11-60.3 first Release Candidate now available
June 3, 2013 By 3 Comments
…=”alignright” width=”247″] Percona Server for MySQL version 5.6.11-60.3[/caption] Percona is glad to announce the first Release… in the 5.6.11-60.3 milestone at Launchpad. This release contains all the bug fixes from latest Percona Server 5.5 release (currently Percona Server 5.5.31-30.3). New Features: Percona Server has implemented Log…
Post: The small improvements of MySQL 5.6: Duplicate Index Detection
May 31, 2013 By Leave a Comment
… try to do something like this in MySQL 5.5, you will succeed without errors or warnings: mysql… of indexes # ######################################################################## # Size Duplicate Indexes 5 # Total Duplicate Indexes 1 # Total Indexes 3 Additionally, pt-duplicate-key-checker …
Post: MySQL and the SSB - Part 2 - MyISAM vs InnoDB low concurrency
May 22, 2013 By Leave a Comment
… Benchmark. In my previous blog post I compared MySQL 5.5.30 to MySQL 5.6.10, both with default settings using only… opposite is true when the database is hot. SSB Flight #3 Here in some cases MyISAM is substantially faster than InnoDB… better, at least for this workload. Notes MySQL version used: 5.6.11, custom compiled to remove performance_schema For the…
Post: Choosing a MySQL HA Solution - Post-Webinar Q&A
June 7, 2013 By Leave a Comment
… readiness. There have been some unfortunate performance regressions compared to 5.5, such as bug #69258, and bug #69318, and I think… being able to retract them. MHA should work fine with 5.6 if you’re not using GTID-based replication. If… decided to give it a shot. I set up a 3 node cluster in AWS, got the volume mounted, and went…
Post: Replication in MySQL 5.6: GTIDs benefits and limitations - Part 2
May 30, 2013 By 6 Comments
… second post of a series of articles focused on MySQL 5.6 GTIDs. You can find part one here. Our goal…, data may be lost or replication may be broken. Scenario #3: The master has crashed before sending all writes If the…
Comment: INSERT INTO ... SELECT Performance with Innodb tables.
May 22, 2013 By 22 Comments
… still the same in 5.5. Here is the related output from show engine innodb status: —TRANSACTION BB0E42A, ACTIVE 3 sec fetching rows…
Post: Multicast replication in Percona XtraDB Cluster (PXC) and Galera
June 5, 2013 By
…’ve seen a lot of people setting up clusters with 3-6+ nodes on 1 Gbps networks. 1 Gbps seems like… really much different from standard mysql replication. 1 master with 5 async slaves is going to send a separate replication stream…_cluster_address = gcomm://192.168.70.2,192.168.70.3,192.168.70.4 wsrep_cluster_address = gcomm://239.192…
Comment: Percona Server 5.1.69-14.7 now available: A drop in replacement for MySQL
June 11, 2013 By 3 Comments
… dir. But check http://www.percona.com/doc/percona-server/5.1/compatibility.html if you’re planning to switch back… features: http://www.percona.com/doc/percona-server/5.1/feature_comparison.html 3) we’re not planning to release the windows…
Post: ZFS on Linux and MySQL
May 24, 2013 By 17 Comments
… servers for backup purpose, boxes with 64 300GB SAS drives, 3 raid controllers and 192GB of RAM. These servers will run… correctly. We got decent tpcc performance, nearly 37k NoTPM using 5.6.11 and xfs. Then, since ZFS on Linux is…
