New Query Engine Features in MariaDB

MariaDB is a branch of MySQL with additional features and improvements. This talk is about MariaDB’s unique query engine features:

• Table Elimination
• Batched Key Access
• A set of Subquery Optimizations

Table elimination feature was developed by MariaDB team from scratch; development of Batched Key Access and Subquery Optimizations was started at Sun/MySQL but the features were not finished. MariaDB team used the unfinished code as a basis and built improved versions of the optimizations.

The talk will present accessible explanations of all three features, together with use examples and benchmarks.