This course provides experienced MySQL DBAs with knowledge of how and why server settings affect performance, and when and how to tune them. It teaches students how to monitor their MySQL server and identify areas that impact performance, such as slow queries and replication lag, and how to diagnose and fix these issues.
Troubleshoot common performance problems.
Benchmark your MySQL server.
Tune MySQL server settings.
Investigate performance metrics with a range of system databases, command-line utilities, and graphical tools.
Design your databases and queries for optimal performance.
Diagnose and fix replication lag.
Who Can Benefit
Familiarity with the Performance Schema
Experience of MySQL Enterprise Monitor Required Prerequisite:
MySQL for Database Administrators Ed 4
Knowledge of Linux
Familiarity with the mysql command-line client and tools
*Course cost listed does not include the cost of courseware. Please contact us at firstname.lastname@example.org or 207-775-0244 for additional pricing information, or if you have any questions. Course is subject to minimum enrollment. This course may run as a live distance learning class if minimum enrollment is not met. Required: Students to have their own cloud account to use in class.