MariaDB InnoDB/XtraDB Performance Tuning

Product: MySQL/MariaDB
Audience: DBA

Note: the materials from this advanced course module have been integrated with the Server Performance Analysis and Tuning course module. This was possible because most deployments now use InnoDB/XtraDB as the default engine, so it has become the baseline for server configuration. Essentially, the bar has been raised.
As noted below, the basic architecture and configuration is covered in our Locking, Transaction & Storage Engines course module, with the remainder in the Server Performance Analysis and Tuning module.

An advanced course module delving deeper into the vast realm of the InnoDB storage engine (and its XtraDB incarnation as used in MariaDB), some of its diagnostic tools, and lots of performance tuning.

This course is aimed at experienced MySQL/MariaDB DBAs who already use InnoDB/XtraDB in production. The basic architecture and configuration of InnoDB is covered in our Locking, Transactions and Storage Engines module. That module also provides an excellent crossover for DBAs experienced in other database systems, as well as our Server Performance Analysis and Tuning module.

Particularly with advanced InnoDB tuning, the server’s actual utilisation by an application, as well as the physical architecture (such as CPUs/cores and storage) come into play. Many options are available, and we look at which ones are the most important and what their practical effects are. There is no single solution for everyone, so we provide you with a toolbox of knowledge that you can apply to your particular environment!

We use MariaDB 10.0 with XtraDB as our baseline for this module, so the information presented is similar to Percona Server 5.6, and a superset of stock (Oracle) MySQL 5.6