Query Optimizer: further down the rabbit hole

  • Sergei Petrunia, Senior Software Engineer at MariaDB
  • Galina Shalygina, Junior Kernel Engineer at MariaDB
Session Abstract

There are a number of improvements to the query optimizer in MariaDB Server 10.4. These features not only improve query performance, but provide valuable diagnostic information. Sergei Petrunia and Galina Shalygina from MariaDB begin with a technical introduction of the query optimizer, discuss the latest query optimizations, including condition pushdown into IN expressions and primary key filtering, then show how the optimizer trace can be used to troubleshoot the optimizer.

View Presentation Slides