Performance Tuning for MariaDB and MySQL

Printer-friendly versionPrinter-friendly version

This instructor-led class is for anyone who wants to be able to obtain the highest performance from their MariaDB or MySQL® databases. Learn how to optimize queries, find bottlenecks, utilize caches, and more. Get the latest tips and tricks for squeezing every last drop of performance out of your MariaDB/MySQL server!

You will learn how to:

  • Choose the best storage engine to suit your dataset and traffic
  • Configure MariaDB/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.

Who is this course for?

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

Prerequisites:

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

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

Book Now!