EXPLAIN Demystified

Average rating: ****.
(4.27, 11 ratings)

If you don’t understand EXPLAIN output, this session is for you. Past attendees have commented that it really made the lightbulbs over their heads light up. EXPLAIN output is confusing, but if you understand how it’s created, it’ll make sense to you.

You’ll leave this session with the knowledge necessary to understand the most complex query plans, including those with filesorts, subqueries, and UNIONs. You’ll see the internals of MySQL from a new angle. That knowledge will prepare you to reason about query execution plans the same way the MySQL server does. As a result, you’ll be able to write queries that get the best performance from MySQL’s query optimizer and executioner.

Photo of Baron Schwartz

Baron Schwartz


Baron is the lead author of High Performance MySQL 2nd edition, and creator of Maatkit. He blogs at Xaprb. Baron is the Director of Consulting at Percona, a firm that helps customers build high-performance applications with open-source software stacks such as LAMP.

  • 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 yromaine@oreilly.com

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@ oreilly.com

Press and Media

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

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.