New Query Engine Features in MariaDB

Architecture and Technology
Location: Ballroom C Level: Intermediate

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.

Sergey Petrunya

Monty Program Ab

Sergey Petrunya is a query optimizer developer at Monty Program Ab, where he has spent the last year working on MariaDB.

Prior to that, he has been working on MySQL query optimizer at MySQL Ab and Sun/MySQL, where he has implemented features like partition pruning, index_merge optimization, semi-join subquery optimizations and numerous smaller optimizer improvements.

  • Oracle
  • Monty Program
  • Calpont
  • Facebook
  • Gear6
  • Infobright, Inc
  • JasperSoft
  • Joyent
  • Kickfire
  • NorthScale, Inc.
  • Percona
  • Schooner Information Technology
  • Solid Quality Mentors (SolidQ)
  • Intel
  • Pentaho
  • Linux Pro Magazine

Sponsorship Opportunities

For information on exhibition and sponsorship opportunities at the conference, contact Yvonne Romaine at

Download the O'Reilly MySQL Conference & Expo Sponsor/ Exhibitor Prospectus

Media Partner Opportunities

Download the Media & Promotional Partner Brochure (PDF) for information on trade opportunities with O'Reilly conferences or contact mediapartners@

Press and Media

For media-related inquiries, contact Maureen Jennings at

O'Reilly MySQL Conference Newsletter

To stay abreast of conference news and to receive email notification when registration opens, please sign up for the O'Reilly MySQL Conference newsletter (login required).

Contact Us

View a complete list of O'Reilly MySQL Conference contacts.