Forum Stats

  • 3,751,294 Users
  • 2,250,339 Discussions


Analyze & Tune MySQL Queries for Better Performance

Laura Engin
Laura Engin Member Posts: 130 Green Ribbon
edited Apr 23, 2016 11:24AM in Social Groups

By Oystein Grovlen, Senior Principal Software Engineer, Oracle

Performance of SQL queries plays a big role in application performance. If some queries execute slowly, these queries or the database schema may need tuning. This session covers how the MySQL optimizer chooses a specific plan to execute SQL queries. We will show you how to use tools such as EXPLAIN (including the JSON-based output) and Optimizer Trace to analyze query plans. We will also review how the Visual Explain functionality available in MySQL Workbench helps us visualize these plans. The presentation will contain several examples of how to take advantage of the query analysis to improve performance of MySQL queries.

Additional Sources