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

Automating MySQL Replication with ClusterControl 1.4.0 - what’s new

This blog post will go through new replication features in ClusterControl 1.4.0, including enhanced multi-master deployment, managing replication topology changes, automated failover and handling of replication errors.

Posted in:

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: