Severalnines Blog
The automation and management blog for open source databases

MySQL Query Tuning: Process & Tools - View the Replay & Slides

Severalnines
Posted in:

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

Related Post

Video: Interview with Riaan Nolan on the Upcoming DevOps Webinar

We sat down with Riaan Nolan, DevOps Manager for Mukuru, to discuss the upcoming webinar “DevOps Tutorial: How to Automate Your Database Infrastructure”.

Posted in:

An Expert's Introduction to PostgreSQL, Database Management and ClusterControl

Basic concepts of PostgreSQL and how ClusterControl fills the gap. Besides ClusterControl a range of related tools for PostgreSQL usage are highlighted.

MySQL on Docker: Running Galera Cluster in Production with ClusterControl on Kubernetes

In our previous posts, we showed how one can run Galera Cluster on Kubernetes. This blog post covers how ClusterControl being part of the stack helps in running your Galera Cluster in production environment.

Webinar - DevOps Tutorial: How to Automate Your Database Infrastructure

This is a live “DevOps Tutorial: How to Automate Your Database Infrastructure” with guest speaker Riaan Nolan of mukuru.com, the first Puppet Labs Certified Professional in South Africa; Riaan saves the companies he works for 50% of their monthly IT bills on average. In this new webinar we will talk you through the facets of DevOps integrations and the mission-critical advantages that database automation can bring to your database infrastructure.