EmergencyEMERGENCY? Get 24/7 Help Now!

MySQL 5.5 and MySQL 5.6 default variable values differences

 | February 21, 2013 |  Posted In: Insight for DBAs, MySQL

As the part of analyzing surprising MySQL 5.5 vs MySQL 5.6 performance results I’ve been looking at changes to default variable values. To do that I’ve loaded the values from MySQL 5.5.30 and MySQL 5.6.10 to the different tables and ran the query:

Lets go over to see what are the most important changes […]

Read More

Analyzing Slow Query Table in MySQL 5.6

 | February 18, 2013 |  Posted In: Events and Announcements, Insight for DBAs, MySQL, Percona Toolkit

Next week I’m teaching an online Percona Training class, called Analyzing SQL Queries with Percona Toolkit.  This is a guided tour of best practices for pt-query-digest, the best tool for evaluating where your database response time is being spent. This month we saw the GA release of MySQL 5.6, and I wanted to check if any […]

Read More

Is MySQL 5.6 slower than MySQL 5.5?

 | February 18, 2013 |  Posted In: MySQL

There have been a number reports/benchmarks showing MySQL 5.6 to be slower than MySQL 5.5 on variety of workloads. There are many possible reasons and I believe we will learn about many of them in the next few weeks and months as MySQL 5.6 is starting to get production battle-tested and there is inflow of […]

Read More

Replication checksums in MySQL 5.6

 | February 15, 2013 |  Posted In: MySQL

MySQL 5.6 has an impressive list of improvements. Among them, replication checksums caught my attention as it seems that many people misunderstand the real added value of this new feature. I heard people think that with replication checksums, data integrity between the master and its replicas is now enforced. As we’ll see, it’s not that […]

Read More

Percona MySQL University in Montevideo and Buenos Aires

 | January 24, 2013 |  Posted In: Events and Announcements, MySQL

Following our Percona MySQL University event in Raleigh,NC Percona MySQL University comes to South America! We’ll have a Full day FREE MySQL Technical Educational events in Montevideo on February 5th, 2013 and Buenos Aires on February 7th. I’m very excited to bring these events to MySQL Community in Uruguay and Argentina. This is my first […]

Read More

Percona Toolkit 2.1.8 released today with beta support for MySQL 5.6

 | January 9, 2013 |  Posted In: MySQL, Percona Software, Percona Toolkit

Percona Toolkit 2.1.8 was released today and the new version comes with some pretty cool news: Beta support for MySQL 5.6 (which as you might know is also in beta). In addition to various bug fixes, Percona Toolkit 2.1.8 also offers beta support for Percona XtraDB Cluster (PXC). Version 2.1.8 continues the trend of solid […]

Read More