MySQL 8.0: Performance Tuning

Cui îi este dedicat cursul?

Database Administrator

Cunoștințe și abilități inițiale

-

Prezentarea cursului

The MySQL 8.0 Performance Tuning course will teach you how to use the vast array of configuration options, monitoring tools, and techniques employed by MySQL database professionals to keep your applications fast, efficient, and safe.

You will understand performance tuning concepts; be able to benchmark and tune your server; investigate performance metrics with a range of system databases, command-line, and graphical tools; design your schema for optimal performance; identify and optimize slow queries, and troubleshoot common performance problems.

Ce subiecte abordează cursul

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

Ce abilități se dobândesc în urmă cursului

• -