Back To Schedule
Wednesday, April 17 • 4:00pm - 4:45pm
Powerful EXPLAIN in MySQL 5.6 (P19)

Sign up or log in to save this to your schedule, view media, leave feedback and see who's attending!

The EXPLAIN command of MySQL has for long been a very useful tool for understanding how MySQL will execute a query. MySQL Release 5.6 offers several new additions that both give more detailed information about query plans, and makes the plans easier to understand.  

One of the new features that will be presented in this session, is a new variant of EXPLAIN that provides a structured presentation of the query plan in JSON format. We will give several examples of how the new structured output will make it easier to understand MySQL's query plans.

While MySQL so far has only supported EXPLAIN for SELECT statements, MySQL 5.6 will also support EXPLAIN for INSERT/UPDATE/DELETE statements. This presentation will also give insight into how one can take advantage of this new feature.

Finally, we will give an introduction to MySQL Optimizer Tracing. This is an advanced tool that will not only present WHAT query plan has been selected by the query optimizer, but also give information about WHY this particular query plan was selected. 

avatar for Øystein Grøvlen

Øystein Grøvlen

Oracle NO
Øystein Grøvlen is a Senior Principal Software Engineer in the MySQL group at Oracle, where he works on the MySQL Query Optimizer. Dr. Grøvlen has a PhD in Computer Science from the Norwegian University of Science and Technology. Before joining the MySQL team 5 years ago, he was... Read More →

Wednesday April 17, 2013 4:00pm - 4:45pm CEST
5. Lofoten SAS Hotellet