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
For information on exhibition and sponsorship opportunities at the conference, contact Yvonne Romaine at firstname.lastname@example.org
For media partnerships, contact mediapartners@ oreilly.com
For media-related inquiries, contact Maureen Jennings at email@example.com
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).
View a complete list of O'Reilly MySQL Conference Contacts