This talk will go through the set of optimizations available to MariaDB's query optimizer in 10.3.
We will also compare MariaDB's optimizer and special querying capabilities with that of other MySQL branches as well as other databases, to provide a broad overview of each solution's strengths and weaknesses, when it comes to regular OLTP as well as Analytical queries.
Vicen?iu Ciorbaru is a Software Engineer at the MariaDB Foundation. His first involvement with MariaDB was to implement SQL Standard Roles. Since then he has been involved in multiple areas, focusing on optimizer related issues. He has taken part in implementing Window Functions for MariaDB, as well as replication related issues. Being part of the MariaDB Foundation, he also helps with making sure MariaDB is adopted by Linux distributions, and that packaged MariaDB works without problems.
Sergei Petrunia is a query optimizer developer at MariaDB Corporation Ab. He has contributed to implementation of Window Functions in MariaDB 10.2, has implemented ANALYZE command for Statements (MariaDB 10.1), SHOW EXPLAIN (MariaDB 10.0), improvements to semi-join subquery optimizations (MariaDB 5.3/5.5) and so forth. Another area he is working in is MyRocks storage engine and its integration into MariaDB.