InnoDB Architecture and Performance Optimization for MySQL 5.7
InnoDB is the most widely 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. The latest features and innovations in MySQL and Percona Server 5.7 impact how your InnoDB interacts with applications, and can improve application performance. This talk will explain how to use InnoDB with MySQL and Percona Server 5.7 to achieve the best application performance, with specific advice on server configuration, schema design, application architecture and hardware choices. (This tutorial is updated from earlier versions, to cover the new MySQL and Percona Server 5.7 InnoDB features in detail.)
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.