MySQL query tuning trilogy: working with optimizer and SQL tuning

This is the final part of our webinar trilogy on MySQL Query Tuning, in which we looked 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 3: Working with the optimizer and SQL tuning.

Content of the webinar

• Optimizer
  • How execution plans are calculated
  • InnoDB statistics
• Hinting the optimizer
  • Index hints
  • JOIN order modifications
  • Tweakable optimizations
• Optimizing SQL