New NoSQL Document Store, and many changes and enhancements including Data Dictionary, Roles, Unicode, CTEs, Window Functions, Security, Replication, SysSchema, GIS, and much more.
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.
Learn To:
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.
Try Oracle MySQL Cloud Service Try MySQL Enterprise Edition Download MySQL Community Edition Download MySQL Cluster Download MySQL Workbench Download MySQL Installer for Windows