The Holy Grail Webinar: Become a MySQL DBA - Database Performance Tuning

Presented by Krzysztof Ksiazek
Webinar Replay
Webinar Slides
Please Sign In to View Content
To view the webinar replay video or slides, "The Holy Grail Webinar: Become a MySQL DBA - Database Performance Tuning", you must be signed in using your Severalnines.com account. If you don't already have an account you can create one in just a couple minutes. Just click on the "Login to View" button below.

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?

Do these questions sound familiar to you? Maybe you’re having to deal with that type of situation yourself?

In this webinar, we’ve discussed some of the settings that are most often tweaked and which can bring you significant improvement in the performance of your MySQL database. We 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.

This webinar is based on our popular blog series ‘Become a MySQL DBA’.

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

Presenter

Krzysztof Ksiazek

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.

Comments & questions

Have any questions? Please, contact us.