blog

Webinar Replay: MySQL Query Tuning – Process & Tools

Ashraf Sharif

Published

Many thanks to everyone who participated in this week’s first part of our webinar trilogy on MySQL Query Tuning. This time we looked at the process and tools to consider when tuning MySQL queries. It was an interactive session with interesting feedback and questions, some of which we’d like to share in this blog.

The majority of this week’s participants currently use MySQL 5.6 or 5.7 (54%), followed by Percona Server 5.6 or 5.7. It was nice to see that many of our participants are on the most recent versions of their databases of choice. As we discussed query tuning, we also found that 100% of participants use slow log to collect their slow queries as well as other tools, such as tcpdump or performance schema. And everyone seems to run full query reviews, whether it’d be monthly, quarterly or yearly …

You can view the detail of the polls we ran during the webinar below in this blog or by watching the replay.

Watch the webinar replay or view the slides

When done right, Tuning MySQL queries and indexes can increase the performance of your application and decrease response times. We’re covering this complex topic over the course of three webinars of 60 minutes each, of which this was part 1; feel free to also register for parts 2 & 3 here.

Agenda Part 1

  • MySQL Query Tuning Trilogy: Process and tools
    • Query tuning process
    • Build
    • Collect
    • Analyse
    • Tune
    • Test
  • Tools
    • tcpdump
    • Pt-query-digest

Speaker

Krzysztof Książek, Senior Support Engineer at Severalnines, is a MySQL DBA with experience in managing complex database environments for companies like Zendesk, Chegg, Pinterest and Flipboard. He’s the main author of the Severalnines blog and webinar series: Become a MySQL DBA.

Webinar Poll Results

Subscribe below to be notified of fresh posts