The MySQL Performance Tuning course teaches you how to tune MySQL for optimal performance. You will learn best practices for configuring, monitoring, and troubleshooting your server, databases and queries using a range of tools.
- Understand performance tuning concepts.
- Benchmark your MySQL server.
- Tune MySQL server settings.
- Investigate performance metrics with a range of system databases, command-line and graphical tools.
- Design your databases for optimal performance.
- Optimize slow queries.
- Troubleshoot common performance problems.
- Scale your hardware and application environment as your database grows.