Innodb and XtraDB Architecture and Performance Optimization

Peter Zaitsev (Percona LLC)
Tutorial
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 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.

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

Media Partners Opportunities

For media partnerships, contact mediapartners@ oreilly.com

Press & Media

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

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