March, 2014
   Stephane Combaudon, Vadim Tkachenko

InnoDB is the default transactional storage engine for MySQL and the most important and broadly useful engine overall. It was designed for processing many short-lived transactions that usually complete rather than being rolled back.

This Percona eBook focuses on one basic area: InnoDB logs. In Chapter 1, Stephane Combaudon shares is experience in MySQL performance audits, listing the top 10 MySQL settings to tune after installation - many of which include InnoDB settings. In Chapter 2 he explains why choosing a good InnoDB log file size is key to InnoDB write performance. Vadim Tkachenko, in Chapter 3, details the expected recovery time from 8G innodb_log_file.



About the Authors

Stephane Combaudon

Stéphane joined Percona in July 2012, after working as a MySQL DBA for leading French companies. In real life, he lives in Paris with his wife and their twin daughters. When not in front of a computer or not spending time with his family, he likes playing chess and hiking.
 

Vadim Tkachenko

Vadim Tkachenko co-founded Percona in 2006 and serves as its Chief Technology Officer. He leads Percona CTO Labs, which focuses on technology research and performance evaluations of Percona and third-party products, designing hardware, filesystems, storage engines, and databases that surpass the standard performance and functionality scenario benchmarks. Under his supervision, Percona has developed and shipped Percona Server for MySQL, Percona XtraBackup, Percona XtraDB Cluster, Percona Server for MongoDB. Vadim’s expertise in LAMP performance and multi-threaded programming help optimize MySQL and InnoDB internals to take full advantage of modern hardware. Oracle Corporation and its predecessors have incorporated Vadim’s source code patches into the mainstream MySQL and InnoDB products. Prior to joining Percona, Vadim served as Performance Engineer at MySQL AB as well as founded a web development company in his native Ukraine. He also spent two years in the High-Performance Group within the official MySQL support team. In addition, Vadim has also co-authored the book High-Performance MySQL: Optimization, Backups, and Replication, 3rd Edition. Vadim received a BS in Economics and an MS in Computer Science from the National Technical University of Ukraine, and lives in North Carolina with his wife and two children.