What's New in MySQL 5.6: Optimizer

The MySQL Optimizer is used to determine the most efficient means for executing queries within MySQL. MySQL 5.6 has included many new optimizer features. This session will give you an introduction to these great features that will provide significant performance improvements on applications with large data set, as well as an easier way to analyze and speed up queries. We will cover the following topics:

• Multi range read
• Index condition pushdown
• Batched key access
• Structured explain
• Explain for update/delete/insert
• Optimizer tracing

Last but not the least, this session will also cover subquery optimizations in MySQL 5.6.

CHI:

DOVE: