InnoDB Architecture and Performance Optimization

11 November 2:00pm - 5:00pm @ Orchard 2
Experience level: 
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.


CEO, Percona
Peter co-founded Percona in 2006, assuming the role of CEO. Percona helps companies of all sizes maximize their success with MySQL. Percona was named to the Inc. 5000 in 2013. 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 and speaks frequently at conferences. Peter lives in North Carolina with his wife and two children. In his spare time, Peter enjoys travel and spending time outdoors.