InnoDB Architecture and Performance Optimization

Tutorials
11 November 2:00pm - 5:00pm @ Orchard 2
Experience level: 
Intermediate
Duration: 
3 hours tutorial
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.


Speakers

CEO, Percona
Biography: 
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.

Slides