InnoDB Architecture and Performance Optimization

This tutorial covers the architecture and performance optimization of InnoDB, the most commonly used storage engine for MySQL and Percona Server.

InnoDB is the most commonly used storage engine for MySQL and Percona Server and is the focus for majority of storage engine development by MySQL and Percona Server teams.

In this tutorial, we will look at InnoDB architecture, including new developments in MySQL 5.7 as well as Percona Server. We will explain how it should be used to get the 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.7 and Percona Server InnoDB features in more details.