Severalnines Blog
The automation and management blog for open source databases

MySQL Query Tuning Trilogy: Working with optimizer and SQL tuning (3rd and final part)

Severalnines
Posted in:

Join us on Tuesday, October 25th, for the third and final part of our webinar trilogy on MySQL Query Tuning, in which we look at the query tuning process and tools to help with that. So far in this trilogy we’ve covered topics such as SQL tuning, indexing, the optimizer and how to leverage EXPLAIN to gain insight into execution plans.

For Part 3, Krzysztof Książek, Senior Support Engineer at Severalnines, will now take a look at working with the optimizer as well as SQL tuning. This will include a discussion on how execution plans are calculated and a closer look at InnoDB statistics, how to hint optimizer and finally, how to optimize SQL.

MySQL Query Tuning (III): Working with optimizer and SQL tuning

Tuesday, October 25th

Sign up for the webinar

We look forward to “seeing” you there!

Agenda

  • Optimizer
    1. How execution plans are calculated
    2. InnoDB statistics
  • Hinting the optimizer
    1. Index hints
    2. JOIN order modifications
    3. Tweakable optimizations
  • Optimizing SQL

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.

If you’ve missed the first two part of this trilogy, you can catch the replays here:

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: