Buy Percona ServicesBuy Now!

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

 | April 24, 2019 |  Posted In: Events, MySQL

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.

Øystein GrøvlenWho’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. 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.

One Comment

Leave a Reply