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,
