InnoDB Architecture and Performance Optimization - Part 2

Peter Zaitsev (Percona Inc)
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 Inc

Peter managed the High Performance Group within MySQL until 2006, when he founded Percona. Peter has a Master’s Degree in Computer Science and is an expert in database kernels, computer hardware, and application scaling.

Comments on this page are now closed.

Comments

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 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.