MariaDB InnoDB/XtraDB Performance Tuning

Product: 
MySQL/MariaDB
Audience: 
DBA

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