MySQL Problems

Analyze & Tune MySQL Queries for Better Performance (14 Mar 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.



Date and Time: Tuesday, 14 Mar 2017, 09:00 US/Pacific