Percona Live Presents: The MySQL Query Optimizer Explained Through Optimizer Trace

April 24, 2019 24 Apr 2019 by Øystein Grøvlen

During my presentation at Percona Live 2019 I will show how using Optimizer Trace can give insight into the inner workings of the MySQL Query Optimizer. Through the presentation, the audience will both be introduced to optimizer trace, learn more about the decisions the query optimizer makes, and learn about the query execution strategies the query optimizer has at its disposal. I’ll be covering 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.

Who’d benefit most from the presentation?

DBAs, developers, support engineers and other people who are concerned about MySQL query performance will benefit from this presentation. Knowing the optimizer trace will enable them to understand why the query optimizer selected a particular query plan. This will be very helpful in order to understand how tune their queries for better performance.

Whose presentations are you most looking forward to?

I’m definitely looking forward to A Proactive Approach to Monitoring Slow Queries by Shashank Sahni of ThousandEyes Inc. It is always interesting to learn how users of MySQL monitor their systems to detect and improve slow queries. ∎

Øystein Grøvlen

Ø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, and after spending last year in Hangzhou, China, he now lives in Sunnyvale, California.

See all posts by Øystein Grøvlen »

Percona Live Presents: The MySQL Query Optimizer Explained Through Optimizer Trace

Who’d benefit most from the presentation?

Whose presentations are you most looking forward to?

Øystein Grøvlen

Discussion

Did you like this post? Why not read more?

Percona Live Presents: Vitess – Running Sharded MySQL on Kubernetes

London Open Source Database Community Meetup

Percona Live Europe Presents: ClickHouse at Messagebird: Analysing Billions of Events in Real-Time\*