Webinars
Join our free webinars on MySQL, MongoDB, PostgreSQL and ClusterControl

MySQL Query Tuning Trilogy: Working with optimizer and SQL tuning

Presented by Krzysztof Ksiazek

This is the final part of our webinar trilogy on MySQL Query Tuning, in which we look at query tuning process and tools to help with that. We’ll cover 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

Agenda

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

Presenter

Krzysztof Ksiazek

Krzysztof Książek, Senior Support Engineer at Severalnines, is a MySQL DBA with experience managing complex database environments for companies like Zendesk, Chegg, Pinterest and Flipboard.