MySQL query tuning trilogy: query tuning process and tools

This is part 1 of a webinar trilogy on MySQL Query Tuning, in which we look at query tuning process and tools to help with that. We’ve covered topics such as SQL tuning, indexing, the optimizer and how to leverage EXPLAIN to gain insight into execution plans. Part 1: Query tuning process and tools.

Content of the webinar

• Query tuning process
  • Build
  • Collect
  • Analyze
  • Tune
  • Test
• Tools
  • tcpdump
  • pt-query-digest