Performance Tuning for MySQL

This is a course for anyone what wants to get the best from their MySQL Database server. The course explains how to tune MySQL, its various storage engines and your application itself, for speed and efficiency.

You will learn how to:

* Choose the best storage engine to suit your dataset and traffic
* Configure MySQL for best connection concurrency vs memory footprint
* Design your schema, normalize it, and know when to de-normalize!
* Tune your SQL queries with inside knowledge of the MySQL Optimizer.
* Design your application to handle scaling out with MySQL Replication.

Format:

Instructor led course with hands-on lab exercises.
Each student will be provided with an individual computer/workstation.

Duration:

4 days

Table of contents (subject to changes):

1.

Introduction
2.

Tuning Overview
3.

Collecting Information
4.

Schema Tuning
5.

Query Tuning
6.

Server Configuration
7.

MyISAM
8.

InnoDB
9.

Common Bottlenecks
10.

Replication
11.

Conclusion

Forudsætninger

Basic DBA knowledge is required. It is recommended that students attend the "Administering MySQL" training course prior to registering for the Performance Tuning course.

Kurset henvender sig til

This course is for the skilled DBA who wants to optimize his usage of the MySQL server in all areas.