The MySQL Query Optimizer Explained Through Optimizer Trace

Wednesday 2:55 PM - 3:55 PM

@ Texas 1

MySQL/MariaDB

50 minutes conference

Advanced

Tracks:
MySQL

All major considerations and decisions made by the MySQL Query Optimizer may be recorded in an Optimizer Trace. While EXPLAIN will show the query execution plan the Query Optimizer has decided to use, MySQL's Optimizer Trace will tell WHY the optimizer selected this plan.

This presentation will introduce you to the inner workings of the MySQL Query Optimizer by showing you examples with Optimizer Trace. We will cover the main phases of the MySQL optimizer and its optimization strategies, including query transformations, data access strategies, the range optimizer, the join optimizer, and subquery optimization. We will also show how optimizer trace gives you insight into the cost model and how the optimizer does cost estimations.

By attending this presentation you will learn how you can use information from Optimizer Trace to write better performing queries. The presentation will also cover tools that can be used to help process the vast amount of information in an optimizer trace.


Speakers

Øystein Grøvlen

Øystein Grøvlen (Alibaba Cloud)

Senior Staff Engineer

Biography:

Øystein Grøvlen is a Senior Staff Engineer in Alibaba Cloud, where he works in the Database Products Group.

Before joining Alibaba, Øystein worked for 10 years in the MySQL optimizer team at Sun/Oracle. At Sun Microsystems, he was also a contributor on the Apache Derby project and Sun's Architectural Lead on Java DB. Prior to that, he worked for 10 years on development of Clustra, a highly available DBMS.

Øystein has been talking about the MySQL Optimizer at several conferences over the years. Dr. Grøvlen has a PhD in Computer Science from the Norwegian University of Science and Technology. Øystein is a native Norwegian, but currently lives in Hangzhou, China.


Connect with Percona

Stay Connected on:

Percona Live 2019 starts in:

Percona Live Conferences

The Percona Live Open Source Database Conferences are the premier event for the diverse and active open source database community, as well as businesses that develop and use open source database software.
 

Contact Us

For general information about the event/expo/conference, including registration, please contact us at:

  • info(@) percona.com
  • +1-888-401-3401
  • +1-919-948-2863
  • 8081 Arco Corporate Drive - Suite 330 - Raleigh, NC 27617, USA