]]> ]]>

Learn How MySQL 5.6 Makes Query Optimization Easier

You are here

MySQL 5.6 offers many long-awaited features. Among the biggest advances in functionality are the enhancements in query planning and optimization. How do we take advantage of this new functionality?

In this webinar, we will examine the difference between MySQL 5.6 and MySQL 5.5 query performance in detail by:

• Comparing the low level row operations, EXPLAIN output, and execution time of the same queries
• Checking what changes are transparent to applications and which require some statement rewriting
• Determining if subselects must still be transformed into JOINS for better performance
• Discussing ICP and MRR, and how they can help us to get better query times
• Determining if a merge_index strategy can now be used efficiently

At the end of the webinar, you will be able to measure the practical impact of different querying strategies by comparing MySQL 5.6 and MySQL 5.5 results and understanding how some of the new profiling tools included in MySQL 5.6 make the query optimization process easier.

WHEN: Friday, March 15, 2013

PRESENTER: Jaime Crespo, Consultant

Slides: Download Here

Contact Us 24 Hours A Day
Support Contact us 24×7
Emergency? Contact us for help now!
Sales North America (888) 316-9775 or
(208) 473-2904
+44-208-133-0309 (UK)
0-800-051-8984 (UK Toll Free)
0-800-181-0665 (GER Toll Free)
More Numbers
Training (855) 55TRAIN or
(925) 271-5054


Share This