MySQL Query Tuning Trilogy: Query tuning process and tools

Presented by Krzysztof Ksiazek
Webinar Replay
Webinar Slides
Please Sign In to View Content
To view the webinar replay video or slides, "MySQL Query Tuning Trilogy: Query tuning process and tools", you must be signed in using your Severalnines.com account. If you don't already have an account you can create one in just a couple minutes. Just click on the "Login to View" button below.

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.

Agenda

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

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.

Comments & questions

Have any questions? Please, contact us.