InnoDB Architecture and Performance Optimization
InnoDB is the most commonly used storage engine for MySQL and Percona Server and is the focus for the majority of storage engine development by the MySQL and Percona Server teams. In this tutorial, we will look at the InnoDB architecture, including new developments in MySQL 5.6 as well as Percona Server. We will explain how it should be used to get the best performance from your application. We will provide specific advice on server configuration, schema design, application architecture, and hardware choices. This tutorial is updated from its previous version, to cover new MySQL 5.6 and Percona Server InnoDB features in more details.
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 Percona Database Performance Blog 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.