Webové stránky používají k poskytování služeb, personalizaci reklam a analýze návštěvnosti soubory cookie. Informace, jak tyto stránky používáte, jsou sdíleny se společností Google. Používáním souhlasíte s použitím souborů cookie. Více informací.

Rozumím

Course code: MYSQLP

MySQL Performance

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.

Course overview

  • 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

Course price

€510 (excl. VAT)
€617 (incl. VAT)

Available terms

Currently no terms available. Please contact us.

Virtual Course

Date Language Duration
7. February 2022 Czech 2 days Register
28. February 2022 English 2 days Register
4. April 2022 Czech 2 days Register
25. April 2022 English 2 days Register
20. June 2022 Czech 2 days Register
27. June 2022 English 2 days Register
5. September 2022 Czech 2 days Register
19. September 2022 English 2 days Register
7. November 2022 Czech 2 days Register
21. November 2022 English 2 days Register

Alternative terms

Suggested dates do not suit you? Contact us for an alternative date.

Contact us