Subqueries to the People: MariaDB Making the Impossible Possible and the Slow Fast

Timour Katchaounov (Monty Program Ab)
Architecture and Technology
Location: Ballroom H
Average rating: ****.
(4.50, 2 ratings)

MySQL supports subqueries since version 4.1 released 8 years ago. Due
to their simplistic implementation and resulting poor performance,
subqueries have been considered as practically unusable by many users.

MariaDB 5.3 changes this by implementing a consistently performing set
of subquery processing techniques. These techniques make it possible
to use subqueries in practice, and deliver performance improvements
impossible to achieve by hand-optimized queries.

The talk provides a thorough overview of all types of subqueries
covered by MariaDB 5.3 from the perspective of the DBA. Each type of
subquery is explained with an example and sample performance
measurement. We also give performance guidelines for manual control
of the optimizer for backwards compatibility, or to solve tricky
performance problems.

Timour Katchaounov

Monty Program Ab

  • 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