The delegate will learn and acquire skills as follows:
- Developing a monitoring and tuning plan
- Using monitoring and diagnostic tools
- Using the Information Schema and Show commands to collect data for tuning
- Understanding normalization and de-normalization and their effect on performance
- Performance tuning tools
- Using load generation, stress testing and benchmarking tools
- Using server configuration and status variables
- Understanding the output from the Explain command
- Identifying and improving problem queries
- Making efficient use of indexes
- Monitoring and sizing memory caches
- Monitoring locks
- Tuning the InnoDB storage engine
- Tuning other standard storage engines
- Comparing and tuning dump and load performance
- Evaluating the use of partitioning for performance
Evaluating the use of partitioning for performance Course Objectives Course Objectives
