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