MySQL 8.0 Optimizer Guide
24 April - 1:30 PM - 4:30 PM @ Ballroom E
3 hours tutorial
Many users who follow MySQL development are aware that recent versions introduce a number of improvements to query execution (via the addition of new execution strategies, and an improved cost model). But what is not talked about enough, is that the diagnostic features are also significantly better. For example, since EXPLAIN FORMAT=JSON shows cost information, it is possible to have an x-ray view of how decisions are being made internally. This in-turn actually makes teaching query optimization easier as well! This tutorial takes a fresh look at how to optimize queries using features that may not be available in earlier versions (hence the title MySQL 8.0). The content comes from www.unofficialmysqlguide.com, and examples will use EXPLAIN FORMAT=JSON, Optimizer Trace and Visual Explain on a small sample database.
MySQL Product Manager, Oracle
Morgan works on the product management team at Oracle, and is responsible for the MySQL Server.