Why Are The New Optimizer Features Important and How Can I Benefit From Them?

Sergey Petrunya (Monty Program Ab), Igor Babaev (Monty Program)
Products and Services
Location: Ballroom G
Average rating: ****.
(4.50, 2 ratings)

MariaDB has a lot of improvements to the core optimiser that powers both MySQL & MariaDB. These optimiser features all have flags which you can enable (they are disabled by default). Learn more about table elimination, subquery optimisations, plus all the new features in MariaDB 5.3 including index condition pushdowns, multi-range read table access, block nested loop algorithm for outer joins, block nested hash loop joins (classic hash join), batched key access (BKA), microsecond support and a lot more. Igor and Sergey both work on all these optimiser features on a daily basis, and will be able to go deep in-depth to explain them and why they are beneficial to end-users in general.

This session is sponsored by Monty Program

Sergey Petrunya

Monty Program Ab

Sergey Petrunya is a query optimizer developer at Monty Program Ab, the company behind the MariaDB project.

His previous position is a member of the optimizer team at Sun/MySQL, where he has implemented features ike index_merge access, partition pruning, semi-join subquery optimizations, and numerous smaller improvements.

Igor Babaev

Monty Program

Igor is one of the core developers of the MySQL Server code. He joined MySQL AB in 2002 to head a group of developers focusing on optimizer problems. After the acquisition of MySQL AB he acted as a Principal Engineer at Sun. In July 2009 Igor moved to Monty Program AB where he works now with his old colleagues from the MySQL Optimizer Team and other MySQL core developers. His activity mainly concentrates on enhancing the optimizer/executor components of the MariaDB Server. Yet, as a MariaDB captain, Igor also reviews and accepts community contributions.

  • EnterpriseDB
  • Amazon Web Services
  • Clustrix
  • Continuent
  • Facebook
  • HTI Consultoria e Tecnologia
  • Monty Program
  • Percona
  • Rackspace Hosting
  • Schooner Information Technology
  • SkySQL
  • Xeround

Sponsorship Opportunities

For information on exhibition and sponsorship opportunities at the conference, contact Yvonne Romaine at yromaine@oreilly.com

Media Partners Opportunities

For media partnerships, contact mediapartners@ oreilly.com

Press & Media

For media-related inquiries, contact Maureen Jennings at maureen@oreilly.com

O'Reilly MySQL Conference Bulletin

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

Contact Us

View a complete list of O'Reilly MySQL Conference Contacts