Here at the MySQL Performance Blog, we’ve been discussing the several new features that MySQL 5.6 brought: GTID-based replication, InnoDB… try to do something like this in MySQL 5.5, you will succeed without errors or warnings: mysql> ALTER TABLE test ADD INDEX (col2… not complain. If we execute the same sentences in MySQL 5.6, the second ALTER will also succeed -and the index will be…
Post: Replication in MySQL 5.6: GTIDs benefits and limitations - Part 2
May 30, 2013 By 6 Comments
… improvements are expected. This is the second post of a series of articles focused on MySQL 5.6 GTIDs. You can find part… slave; # For s1, s3 and s4 mysql> stop slave; mysql> change master to master_port=10002; mysql> start slave; Those of you who… try! # For s0,s1, s3, s4 mysql> stop slave; mysql> change master to master_port=10002; mysql> start slave; # And then check the…
Post: Percona Server for MySQL 5.5.31-30.3 now available
May 24, 2013 By Leave a Comment
… Server for 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…
Post: Replication in MySQL 5.6: GTIDs benefits and limitations - Part 1
May 21, 2013 By 8 Comments
… Identifiers are one of the new features regarding replication in MySQL 5.6. They open up a lot of opportunities to make… replication configuration with one master and two slaves, all running MySQL 5.6 with GTIDs disabled. First try: configure only one of… some other slaves using GTID-based positioning. This answers the second question: we can have different replication modes on different servers…
Post: Percona Server 5.1.69-14.7 now available: A drop in replacement for MySQL
June 10, 2013 By 3 Comments
…=”attachment_13396″ align=”alignright” width=”247″] Percona Server for MySQL version 5.1.69-14.7[/caption] Percona is glad to announce… drop in replacement for MySQL, downloads are available here and from the Percona Software Repositories. Based on MySQL 5.1.69, this release… #1132412, bug fixed #1153651. Release notes for Percona Server for MySQL 5.1.69-17.4 are available in our online documentation…
Post: MySQL and the SSB - Part 2 - MyISAM vs InnoDB low concurrency
May 22, 2013 By Leave a Comment
… In my previous blog post I compared MySQL 5.5.30 to MySQL 5.6.10, both with default settings …is described as the cold test, and the second as the hot test. The database software …mysql socket=/var/lib/mysql/mysql.sock user=justin innodb_buffer_pool_size=64G innodb_log_file_size=4G innodb_file_per…
Post: Summertime Percona MySQL training update
June 6, 2013 By 1 Comment
… also running our new Moving to MySQL 5.6 class. This class covers new features in MySQL 5.6, migration planning, and application verification… MySQL training schedule. In June we have: Moving to MySQL 5.6 – Austin, TX Begins Monday, June 10, 2013 , 9am – 5pm Moving to MySQL 5… August we have: Moving to MySQL 5.6 – Miami, FL Begins Monday, August 5, 2013 , 9am – 5pm Moving to MySQL 5.6 – Minneapolis, MN Begins…
Post: Percona Server 5.6.11-60.3 first Release Candidate now available
June 3, 2013 By 3 Comments
… 5.6.11-60.3 on June 3rd, 2013 (Downloads are available here and from the Percona Software Repositories). Based on MySQL 5.6.11, including all the bug fixes in it, Percona Server 5.6.11-60.3 is… #1177780, bug fixed #1154954. Release notes for Percona Server for MySQL 5.6.11-60.3 are available in our online documentation…
Post: Choosing a MySQL HA Solution - Post-Webinar Q&A
June 7, 2013 By Leave a Comment
…: What is my recommendation for MySQL 5.6? Is MHA ready for MySQL 5.6? A: My personal recommendation for MySQL 5.6, based on what…: Incorrect information in file: ‘./mysql/servers.frm’ ERROR: 1033 Incorrect information in file: ‘./mysql/servers.frm’ Running mysql_install_db under strace, I…
Post: Webinar: SQL Query Patterns, Optimized
May 20, 2013 By Leave a Comment
… type of query objective, and show how you can use MySQL 5.6 built-in methods to analyze them for optimal query…. The query patterns will include: Exclusion Join Random Selection Greatest-Per-Group Dynamic Pivot Relational Division Please register for this webinar…
