Innodb and XtraDB Architecture and Performance Optimization

Peter Zaitsev (Percona Inc)
Location: Ballroom G
Average rating: ****.
(4.00, 7 ratings)

This presentation cover the most important aspects of Innodb and XtraDB architecture as well as teach you to use them to archive best application performance and avoid bottlenecks. We will also look at Innodb settings corresponding to different architectural aspects.
The following are the architecture parts to be covered:
General Architecture
• Storage and File Layout
• Threads
• Memory
• Disk IO
• Logging
• Indexes
• Multi Versioning
• Row Locking
• Latching
• Page flushing and Replacement
• Insert Buffering
• Adaptive Hash Index
BLOB Storage
• Recovery
• Compression Features
• Foreign Keys

We will also look into Performance Improvements done in XtraDB and MySQL Server 5.5 Innodb storage engine as part of this presentation.

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.

  • 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

Media Partners Opportunities

For media partnerships, contact mediapartners@

Press & Media

For media-related inquiries, contact Maureen Jennings at

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