blog

Webinar Replay: MySQL Database Performance Tuning

Jean-Jérôme Schmidt

Published

Thanks to everyone who participated in this week’s popular webinar on MySQL Database Performance Tuning, which looked at answering the following questions:

  • You’re running MySQL as backend database, how do you tune it to make best use of the hardware?
  • How do you optimize the Operating System?
  • How do you best configure MySQL for a specific database workload?

The replay of this webinar is now available online:

Watch the replay

In this webinar, Krzysztof Książek, Senior Support Engineer at Severalnines, discussed some of the settings that are most often tweaked and which can bring you significant improvement in the performance of your MySQL database. Krzysztof  also covered some of the variables which are frequently modified even though they should not. Performance tuning is not easy, but you can go a surprisingly long way with a few basic guidelines.

Agenda

  • Database tuning – the what and why
  • Principles of the tuning process
  • Tuning the Operating System configuration
  • Tuning the MySQL configuration
  • Useful tools
    • pt-summary
    • pt-mysql-summary
  • What to avoid when tuning OS and MySQL configuration

Speaker

Krzysztof Książek, Senior Support Engineer at Severalnines, is a MySQL DBA with experience managing complex database environments for companies like Zendesk, Chegg, Pinterest and Flipboard. This webinar builds upon recent blog posts and related webinar series by Krzysztof on how to become a MySQL DBA.

Subscribe below to be notified of fresh posts