EmergencyEMERGENCY? Get 24/7 Help Now!

The small improvements of MySQL 5.6: Duplicate Index Detection

 | May 31, 2013 |  Posted In: Insight for DBAs, MySQL, Percona Toolkit

Here at the MySQL Performance Blog, we’ve been discussing the several new features that MySQL 5.6 brought: GTID-based replication, InnoDB Fulltext, Memcached integration, a more complete performance schema, online DDL and several other InnoDB and query optimizer improvements. However, I plan to focus on a series of posts on the small but handy improvements – […]

Read More

MySQL 5.6.10 Optimizer Limitations: Index Condition Pushdown

 | March 14, 2013 |  Posted In: Events and Announcements, Insight for Developers, MySQL

While preparing the webinar I will deliver this Friday, I ran into a quite interesting (although not very impacting) optimizer issue: a “SELECT *” taking half the time to execute than the same “SELECT one_indexed_column” query in MySQL 5.6.10. This turned into a really nice exercise for checking the performance and inner workings of one […]

Read More