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

Improve Site Performance by Optimizing Queries


Effective queries are a core requirement of site performance. Even a well written application can cause lag due to poorly 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