Buy Percona ServicesBuy Now!
  Thursday, April 28, 2016
   Sveta Smirnova

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

Sveta Smirnova
Principal Technical Services Engineer
Sveta joined Percona in 2015. Her main professional interests are problem solving, working with tricky issues, bugs, finding patterns which can solve typical issues quicker, teaching others how to deal with MySQL issues, bugs and gotchas effectively. Before joining Percona Sveta worked as Support Engineer in MySQL Bugs Analysis Support Group in MySQL AB-Sun-Oracle. She is author of book "MySQL Troubleshooting" and JSON UDF functions for MySQL.

Visit Percona Store


General Inquiries

For general inquiries, please send us your question and someone will contact you.