New optimizer features in MariaDB releases before 10.12

Abstract

This talk will cover new MariaDB query optimizer features other than the Cost Model Rewrite in MariaDB 10.12.

We’ll describe the new features in MariaDB 10.8-10.11 that were added since the 2021 MariaDB Server Fest. They are smaller features but they’re already in the stable releases so you can already benefit from them.

Date and time

  • Thursday 17 November, 18:15 – 19:00 CET (UTC+1)

Presenter

Sergei Petrunia
Query optimizer developer, MariaDB Corporation

Sergei Petrunia is a query optimizer developer at MariaDB. He has contributed to Optimizer Trace implementation in MariaDB, ANALYZE for statements feature, and other optimizer features. When not doing feature development, he is handling query optimization-related support escalations, which he uses as a way learn about how query optimizer behaves in production.
Prior to MariaDB, he has been a query optimizer developer at MySQL.