Nov 07, 2018
 Percona Live Open Source Database Conference Europe 2018
  Vicentiu Ciorbaru

MariaDB 10.3 Optimizer and beyond

Database optimizers are constantly improving. During this session, we will cover the new optimizations implemented by the optimizer team for MariaDB 10.3 release and the planned projects for the next 10.4 release.

Highlights are:
* Condition Pushdown through GROUP BY and PARTITION BY
* Split-grouping for derived tables (a guaranteed speedup where the optimization applies)
* Improved Engine-Independent Table Statistics support
* New optimizer default settings



About the Author

Vicentiu Ciorbaru

Vicentiu works at the MariaDB Foundation as a Software Engineer. He focuses on Optimizer development, but has also worked on other parts of the MariaDB Server. Notable projects include: Window Functions in MariaDB Custom Aggregate Functions in MariaDB Roles in MariaDB