Introduction to Performance Tuning

1. Using EXPLAIN to analyze queries

2. General table optimizations

3. Monitoring status varaibles that affect performance

4. Setting and interpreting MySQL server variables

5. Overview of PERFORMANCE_SCHEMA