]]> ]]>

Webinar: Learn How MySQL 5.6 Makes Query Optimization Easier

You are here


Mar 15, 2013

Percona Live Webinar

Jaime Crespo, Senior MySQL Instructor

To access a recording of this webinar, visit: http://www.percona.com/webinars/learn-how-mysql-56-makes-query-optimizat...

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.

Presented by:

Jaime Crespo, MySQL Instructor, Percona
March 15th, 2013


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
Sales
Europe
+44-208-133-0309 (UK)
0-800-051-8984 (UK)
0-800-181-0665 (GER)
Training (855) 55TRAIN or
(925) 271-5054

 

Share This
]]>