… In my previous blog post I compared MySQL 5.5.30 to MySQL 5.6.10, both with default settings using… only speculating (and I can investigate further), but I believe the adaptive hash index is improving performance of… Flight #2 Flight #2 is similar to Flight #1. MyISAM is faster than InnoDB when the …
Post: The small improvements of MySQL 5.6: Duplicate Index Detection
May 31, 2013 By Leave a Comment
… improvements – changes and bug corrections – in MySQL 5.6 that can make our lives easier and… # Summary of indexes # ######################################################################## # Size Duplicate Indexes 5 # Total Duplicate Indexes 1 # Total Indexes 3 Additionally…
Post: Replication in MySQL 5.6: GTIDs benefits and limitations - Part 2
May 30, 2013 By 6 Comments
… where GTIDs shine and where improvements are expected. This is the second post of a series of articles focused on MySQL 5.6 GTIDs. You can find part one here. Our goal will be to go from setup #1 to setup…,master_auto_position=1; s0> start slave; # For s1, s3 and s4 mysql> stop slave; mysql> change master to master_port=10002; mysql> start slave…
Post: Disconnecting a replication slave is easier with MySQL 5.5+ (RESET SLAVE vs. RESET SLAVE ALL)
April 17, 2013 By 2 Comments
… supported from MySQL 5.5). If you want to know more details, please read on! MySQL 5.0/5.1 First let’s consider MySQL 5.0 and 5.1. RESET SLAVE… MySQL 5.5 Starting with MySQL 5.5, the situation has slightly changed. First the master-xxx variables are no longer supported, which is a great improvement…
Post: Percona Server for MySQL 5.5.30-30.2 now available
April 10, 2013 By 10 Comments
…MySQL 5.5.30-30.2 on April 10, 2013 (Downloads are available here and from the Percona Software Repositories). Based on MySQL 5.5… improves…and its InnoDBParser Perl package from source and Debian installation. Bug fixed #1032139 (Alexey Bychko). UDF/configure.ac was incompatible with automake 1…
Post: MySQL 5.6 Compatible Percona Toolkit 2.2 Released
March 25, 2013 By 2 Comments
… MySQL 5.6. Several months in the making and many new features, changes, and improvements make this a great new series. It replaces the 2.1… written once long ago and not updated since. Now that we have four base versions of MySQL (5.0, 5.1, 5.5, and 5.6), plus at least four major forks (Percona Server, MariaDB, Percona XtraDB Cluster, and MariaDB Galera Cluster…
Post: Percona Live MySQL Conference 2013 wrap-up
April 29, 2013 By Leave a Comment
… of the Oracle development discipline MySQL 5.0 and 5.1 were rushed and not properly tested but 5.5 and 5.6 were significantly improved and 5.7 promises to be more of the same The future for the MySQL…
Post: 10 years of MySQL User Conferences
April 11, 2013 By 6 Comments
… year. MySQL releases are split between the MySQL Community, and MySQL Enterprise is released with different versions on different schedules. MySQL 5.0.37 GA and 5.1.17… and announced Percona XtraDB as improved and extended Innodb Plugin version, MySQL 5.1 is FA with 5.1.34 and MySQL 5.4.0 is in a nonGA version. The MySQL…
Post: Percona Server 5.5.30-30.2 rerelease fixes non-restart issue
April 24, 2013 By Leave a Comment
…built on RHEL 5 and CentOS 5. Bug fixed #… cases. This significantly improves InnoDB scalability on…and its InnoDBParser Perl package from source and Debian installation. Bug fixed #1032139 (Alexey Bychko). UDF/configure.ac was incompatible with automake 1… for Percona Server for MySQL 5.5.30-30.2 …
Post: Announcing Percona XtraBackup 2.1.1 GA
May 15, 2013 By Leave a Comment
…while providing unique features for MySQL backup. The new 2.1.1 GA version offers improved performance, enterprise-grade security, and lower resource usage. …s DBD::MySQL package for server communication instead of spawning the MySQL command line client. Support for InnoDB 5.0 and InnoDB 5.1 builtin …
