MySQL Performance Tuning

5 Days

• Administrator 
• Architect 

• Database Administrator 
• Developer 
• Systems Administrator 

Suggested Prerequisite 

• Familiarity with the Performance Schema 
• Experience of MySQL Enterprise Monitor 

Required Prerequisite 

• MySQL for Database Administrators Ed 4 
• DBA experience 

• Knowledge of Linux 
• Familiarity with the mysql command-line client and tools 

• Identify and fix replication lag, 

• Understand performance tuning concepts, 
• List factors that affect performance, 
• Use a range of performance tuning tools, 
• Configure and use the Performance Schema, 
• Tune the MySQL server instance, 

• Design a schema for optimal performance, 
• Understand how MySQL optimizes queries, 
• Identify and fix slow queries, 
• Diagnose and resolve common performance issues 

• Introduction, 
• Performance Tuning Concepts, 
• Performance Tuning 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,