Analyze & Tune MySQL Queries for Better Performance

Dienstag, 14. März 2017

SQL query performance plays a big role in application performance. If some queries execute slowly, these queries or the database schema may need tuning. Join Senior Oracle MySQL Engineer and query tuning expert, Øystein Grøvlen, to learn how to speed things up.

He will cover how the MySQL Optimizer chooses a specific plan to execute SQL queries and then will show you how to use tools such as EXPLAIN (including the JSON-based output) and Optimizer Trace to analyze query plans.

Øystein will also review how the Visual Explain functionality available in MySQL Workbench helps to visualize these plans. The webinar will contain several examples of how to use query analysis to improve performance of MySQL queries, and improve application performance.

WER:

  • Øystein Grøvlen, Senior Principal Software Engineer Oracle

WO:

Nehmen Sie einfach von Ihrer gewohnten Umgebung, zum Beispiel von Ihrem Büro aus, an diesem Web-Seminar teil.

Zum Webseminar anmelden »

On24-Registrierungsseite wird in einem neuen Reiter/einem neuen Fenster geöffnet