Call us today (AU) 07 3103 0809 (NZ +61-7-3103 0809)

We are an Australian based company with specific expertise in MySQL and MariaDB. Our services include consulting, scalable architecture, proactive remote DBA, system administration, vendor neutral managed services with optional emergency support, mentoring, training, and security and code reviews.

MySQL Server Performance Analysis and Tuning - Canberra

AUD 595 + GST
Wednesday, September 5, 2012 (All day)
Saxons @ Atlas Training Centre, Canberra ACT 2600

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 danblack in Canberra.