MySQL/MariaDB Query Performance Analysis and Tuning

AUD 375 + GST [BYO laptop]
Wednesday, June 18, 2014 (All day)
Saxons Training Facilities, Level 8, 500 Collins St, Melbourne VIC 3000

This day teaches you how to decode EXPLAIN, SHOW STATUS, and the slow query log (among other things), to find slow queries, work out why they're slow, and either change the query, tweak the schema, or in some cases tweak local settings in a connection to make it faster.

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. Note that MariaDB 10.0 offers additional features such as EXPLAIN on UPDATE and DELETE.

This course will be be taught by Peter Lock in Melbourne.