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