Severalnines Blog
The automation and management blog for open source databases

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

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


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

Online schema change with gh-ost - throttling and changing configuration at runtime

When performing schema changes online, it is important to be able to control the performance impact on our running databases. This blog post discusses gh-ost’s throttling mechanism. We will also cover the runtime configuration changes that gh-ost allows.

Posted in:

How to perform online schema changes on MySQL using gh-ost

This blog post shows you how to use GitHub’s gh-ost to perform an online schema change on a MySQL master-slave replication setup.

Posted in:

Planets9s - 2016’s most popular s9s resources

Planets9s is a weekly communication on all the latest Severalnines resources and technologies around automation and management of open source databases such as MySQL, MariaDB, PostgreSQL & MongoDB.

Posted in:

How to Perform Efficient Backup for MySQL and MariaDB

There are a number of ways to backup MySQL and MariaDB, each comes with pros and cons. An effective backup strategy will depend on the requirements of the business, the environment you operate in, and the resources at your disposal.

Posted in: