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