Here at the MySQL Performance Blog, we’ve been discussing the several new features that MySQL 5.6 brought: GTID-based replication, InnoDB… posts on the small but handy improvements – changes and bug corrections – in MySQL 5.6 that can make our lives easier and have… MySQL 5.5, you will succeed without errors or warnings: mysql> ALTER TABLE test ADD INDEX (col2); Query OK, 0 rows affected (0.22 sec) Records: 0…
Post: Replication in MySQL 5.6: GTIDs benefits and limitations - Part 2
May 30, 2013 By 6 Comments
… post of a series of articles focused on MySQL 5.6 GTIDs. You can find part one here. …# For s0 s0> change master to master_host=’127.0.0.1′,master_user=’rsandbox’,master_password=’rsandbox’,master_…is no –start-gtid-position option or equivalent. See bug #68566. Does it mean that we cannot easily …
Post: MySQL 5.6 Compatible Percona Toolkit 2.2 Released
March 25, 2013 By 2 Comments
… started beta support for MySQL 5.6 in 2.1.8 when 5.6 was still beta. Now that MySQL 5.6 is GA, so… 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…. For example, three tools were removed, and there were several bug fixes. See https://launchpad.net/percona-toolkit/+milestone/2.2…
Post: Percona XtraBackup 2.1.0 for MySQL beta now available
April 22, 2013 By Leave a Comment
… and bug fixes in Percona XtraBackup for MySQL 2.0.6, plus the following: New Features: Percona XtraBackup has implemented basic support for MySQL 5.6, Percona Server 5.6…
Post: Follow these basics when migrating to Percona XtraDB Cluster for MySQL
May 1, 2013 By 10 Comments
… XtraDB Cluster (PXC) for MySQL is a hot thing right now and some users …achieve better consistency, if you have an async master <= 5.0 though, you can workaround this by turning off …becomes non-deterministic. Although the previous bug has been fixed on latest release (5.5.30-23.7.4), table without…
Post: Percona XtraBackup 2.0.7 for MySQL available for download
May 6, 2013 By 1 Comment
… in the 2.0 series. New Features: This version of Percona XtraBackup has implemented full support for new MySQL 5.6 features (GTID… longer satisfied mysql dependency which is required by the XtraBackup rpms. Bug fixed #1095972. Percona XtraBackup would fail when preparing the MySQL 5.6… than 4G on the source server. Bug fixed #1164979. Due to different implementation in MySQL 5.6 error messages were not printed to…
Post: Percona XtraBackup 2.1.0 'release candidate' for MySQL available for download
May 7, 2013 By Leave a Comment
… 2.0 series at the time of writing). New Features: This version of Percona XtraBackup has implemented full support for new MySQL 5… support for the InnoDB Buffer Pool Preloading introduced in MySQL 5.6. Starting with MySQL 5.6 buffer pool dumps can be produced and… which speeds up the backup process. Bug fixed #1130145. Due to different implementation in MySQL 5.6 error messages were not printed to…
Post: Percona XtraDB Cluster 5.5.30-23.7.4 for MySQL now available
April 17, 2013 By 2 Comments
… release of Percona XtraDB Cluster 5.5.30-23.7.4 for MySQL on April 17, 2013. …options variable. Accepted values are in the range [0, 255] (inclusive). Quorum is computed using weighted …specified more than once in the MySQL configuration file (my.cnf). Bugs fixed #1160047 and #1086978 (Raghavendra D…
Post: Percona XtraBackup 2.1.0 for MySQL alpha now available
April 2, 2013 By Leave a Comment
… the features and bug fixes in Percona XtraBackup for MySQL 2.0.6, plus the following: New Features Percona XtraBackup for MySQL now has…’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 has been removed from Percona XtraBackup for MySQL. After…
Post: MySQL and Percona Server in LinkBench benchmark
May 8, 2013 By 18 Comments
… MySQL 5.5.30 top mutex is &doublewrite->mutex: trx0sys.c:196. And most likely this symptom is related to BUG#67808. For MySQL 5.6.11 top mutexes is &buf_pool->mutex,&new_index->lock. I profiled 5.6.11…_type=0 performance_schema=0 #56only loose-innodb_flush_neighbors=0 loose-metadata_locks_hash_instances=256 innodb_buffer_pool_instances=16 # MySQL 5.5 and 5…
