InnoDB Architecture and Performance Optimization - Part 2

Average rating: ****.
(4.33, 6 ratings)

This presentation will teach you the InnoDB internals you need to know for performance optimization and operational tasks. You’ll learn topics such as how InnoDB allocates space on the filesystem and in memory, how InnoDB recovery works, and how MVCC and locking work. We’ll also cover the insert buffer and doublewrite buffer, and how InnoDB purges old data. We will not get into code-level details, but will go deep enough that you can conceptually understand the InnoDB architecture and predict its behavior.

Photo of Peter Zaitsev

Peter Zaitsev

Percona LLC

Peter co-founded Percona in 2006, assuming the role of CEO. Percona is the only company that delivers enterprise-class solutions for both MySQLⓇ and MongoDBⓇ across traditional and cloud-based platforms. Percona has been on the Inc. 5000 list of fastest growing companies since 2013. Back in 2000s Peter was an early employee at MySQL AB, eventually leading the company’s High Performance Group. A serial entrepreneur, Peter co-founded his first startup while attending Moscow State University where he majored in Computer Science.

As CEO of Percona, Peter enjoys mixing business leadership with hands on technical expertise. Peter is co-author of High Performance MySQL published by O’Reilly, one of the most popular books on MySQL performance. Peter blogs regularly on Percona Performance Blog and speaks frequently at conferences all over the world. Peter lives in North Carolina with his wife and two children. In his spare time, Peter enjoys travel and spending time outdoors.

Comments on this page are now closed.


Picture of Mark J. Levitt
Mark J. Levitt
04/26/2010 5:03pm PDT

@Joy, they’re up. See above (or this) link.

Joy Wang
04/20/2010 6:07pm PDT

Where is the slides?

  • 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

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@

Press and Media

For media-related inquiries, contact Maureen Jennings at

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.