Our Guide to MySQL & MariaDB Performance Tuning

Presented by Krzysztof Ksiazek

Webinar Replay

Webinar Slides

Please Sign In to View Content

To view the webinar replay video or slides, "Our Guide to MySQL & MariaDB 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.

If you’re asking yourself the following questions when it comes to optimally running your MySQL or MariaDB databases:

How do I tune them to make best use of the hardware?
How do I optimize the Operating System?
How do I best configure MySQL or MariaDB for a specific database workload?

Then this replay is for you!

We discuss some of the settings that are most often tweaked and which can bring you significant improvement in the performance of your MySQL or MariaDB database. We also cover some of the variables which are frequently modified even though they should not.

Performance tuning is not easy, especially if you’re not an experienced DBA, but you can go a surprisingly long way with a few basic guidelines.

This webinar builds upon blog posts by Krzysztof from the ‘Become a MySQL DBA’ series.

Agenda

What to tune and why?
Tuning process
Operating system tuning
- Memory
- I/O performance
MySQL configuration tuning
- Memory
- I/O performance
Useful tools
Do’s and do not’s of MySQL tuning
Changes in MySQL 8.0

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.