Severalnines Blog
The automation and management blog for open source databases

Watch the replay: MySQL Query Tuning Part 2 - Indexing and EXPLAIN

Posted in:

We’ve just completed Part 2 of our webinar trilogy on MySQL Query Tuning this week and if you didn’t get the chance to join us for the live sessions (or would like to watch them again), the recording is now available to view online as a replay.

As announced in our communications, these webinars are almost 1.5hrs long, as the content is quite dense (and we got some great questions from participants as well), so be sure to make sufficient time available to watch the replay ;-)

Watch the replay

About 40% of our audience indicated that they currently either use MySQL / Percona Server 5.5 (or earlier), MySQL / Percona Server 5.6 or MariaDB 10.1, so it was an interesting mix. We also found that the majority of participants don’t have a process to check for unused indexes, which was a good opportunity to explain why this might be a good thing to implement. And finally, 68% of the audience confirmed that they use EXPLAIN Analyzer to analyse query execution plans. You can view the detail of the polls further below.

Our colleague Krzysztof Książek, Senior Support Engineer at Severalnines, presents this webinar trilogy and this week he looked into answering questions such as why a given query might be slow, what the execution plan might look like, how JOINs might be processed, whether a given query is using the correct indexes, or whether it’s creating a temporary table.

In order to answer these questions, Krzysztof discussed how to use database indexes to speed up queries and, more specifically, he covered the different index types such as B-Tree, Fulltext and Hash, deepdive into B-Tree indexes, and discussed the indexes for MyISAM vs. InnoDB tables as well as some gotchas.

Watch the replay

And if you’re ready for Part 3 of the MySQL Query Tuning Trilogy, please do sign up for the webinar on October 25th, which will cover ‘working with optimizer and SQL tuning’.

Feedback detail of this week’s webinar:

Related Post

Database Automation: Integrating the ClusterControl CLI with your ChatBot

The new ClusterControl command line client allows easy integration with other automation and collaboration tools, such as chatbots. Instead of integrating the CLI in your own chatbot, you can use the Hubot based ClusterControl chatbot called CCBot alternatively.

Webinar - How to use ClusterControl from the command line and integrate with your DevOps tools

The Severalnines command line interface offers an open source alternative for the web-based ClusterControl User Interface on the command line. You can perform almost any deployment, management or scaling task from the command line.

Webinar Replay and Q&A: how to deploy and manage ProxySQL, HAProxy and MaxScale

This blog provides details for the replay of our webinar on how to deploy and manage ProxySQL, HAProxy and MaxScale, as well as answers to the questions asked during this session.

Posted in:

Video: ProxySQL ClusterControl Demonstration

This video demonstrates the latest features in ClusterControl for deploying and managing ProxySQL, a new flexible load balancing technology.

Posted in: