<img height="1" width="1" style="display:none;" alt="" src="https://dc.ads.linkedin.com/collect/?pid=95128&amp;fmt=gif">

Troubleshooting Slow Queries


Effective queries are a core requirement of MySQL performance. Even a perfectly optimized MySQL server running on the most powerful hardware can lag due to badly optimized queries. EXPLAIN is one of the most powerful and always-available query tuning instruments built-in to MySQL.

In this webinar, we will discuss EXPLAIN, its extensions, new EXPLAIN features, and other tools you can use to tune queries. You will learn how to use:
  • Traditional EXPLAIN and its extensions: EXPLAIN FORMAT=JSON, EXPLAIN PARTITIONS, EXPLAIN EXTENDED
  • Handler metrics
  • Information Schema: OPTIMIZER_TRACE
  • Performance Schema: EVENTS_STATEMENTS_*, EVENTS_STAGES_*
  • Performance-related views in sys schema