MySQL/MariaDB Server Performance Analysis and Tuning
AUD 375 + GST [BYO laptop]
Thursday, June 19, 2014 (All day)
Saxons Training Facilities, Level 8, 500 Collins St, Melbourne VIC 3000
This module teaches you how to tune a MySQL server based on the needs of the application and the restrictions of the environment. As this is not a one-off job, we start from a sensible baseline configuration, then gather and analyse runtime information to further tune a server over time.
We look at the general and InnoDB specific server options and how they interact, log files (including the MariaDB enhancements for slow query logging), and reviewing and interpreting the statistical data available in the server. Of course there are graphical and command line tools for this, but we teach you how it all works so you can chose appropriate tools and use them to optimal advantage.
We also review which settings can be simply changed at runtime, and which require special procedures.
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
This course will be be taught by Peter Lock in Melbourne.