MySQL Performance

Základní info

Popis kurzu

This training teaches how to safely and effectively optimize the performance of MySQL server. Students understand how to use the tools to monitor, evaluate and tune. The course makes participants proficient in evaluating architecture, using tools, configuring databases, and tuning SQL code and applications.


This training teaches how to safely and effectively optimize the performance of MySQL server. Students understand how to use the tools to monitor, evaluate and tune. The course makes participants proficient in evaluating architecture, using tools, configuring databases, and tuning SQL code and applications.

Obsah kurzu

  • Performance Schema

  • Memory, Connections, and Threads

  • Tables, Files, and Logs

  • Statement Monitoring, Sort Buffer and Query Cache

  • InnoDB Storage Engine

  • Schema Design and Performance

  • Query Optimization

  • Using EXPLAIN to Analyze Queries

  • General Table Optimizations

  • Monitoring status variables that affect performance

Studijní materiály

V angličtině

MySQL Performance

Vybraný termín:

4.4.2022  Online

Cena

Kontaktovat dodavatele


Kontrola proti spamu. Kolik je deset a jedna ? Součet zapište číslicemi.