Network
Join Attendee Network
 

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

Timour Katchaounov (Monty Program Ab)
10:50am Thursday, 04/14/2011
Architecture and Technology
 Location: Ballroom H
Presentation: Subqueries to the People_ MariaDB Making the Impossible Possible and the Slow Fast Presentation [PDF]
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