Optimizer Trace walkthrough – Sergei Petrunia – MariaDB Server Fest 2020

Optimizer Trace was introduced in MariaDB 10.4, the previous release. During the past year, it has received numerous updates and improvements.

The talk is a walkthrough of all kinds of information that one can find in the Optimizer Trace, and shows how to use it to diagnose common and not so common optimizer issues.

I will also compare MariaDB’s Optimizer Trace with MySQL’s optimizer trace, and discuss further development directions for it.