MySQL 8.0 Performance Tuning

Overview

This course provides experienced MySQL DBAs with knowledge of how and why server settings affect performance, and when and how to tune them. It teaches students how to monitor their MySQL server and identify areas that impact performance, such as slow queries and replication lag, and how to diagnose and fix these issues.

Audience

• Administrator
• Architect
• Database Administrator
• Developer
• Systems Administrator

Suggested Prerequisites

• Familiarity with the Performance Schema
• Experience of MySQL Enterprise Monitor
• MySQL for Database Administrators Ed 4
• DBA experience
• Knowledge of Linux
• Familiarity with the mysql command-line client and tools

Topics

• Performance Tuning Concepts and Tools
• Performance Schema
• General Server Tuning, Tuning Tables, Files, and Logs
• Tuning InnoDB
• Optimizing Your Schema
• Monitoring Queries
• Query Optimization
• Optimizing Locking Operations
• Tuning Replication