Webinar Replay: MySQL & MariaDB Performance Tuning for Dummies

Thanks to everyone who participated in this week’s webinar on Performance Tuning for MySQL & MariaDB!

If you’ve missed the live session or would like to watch it again, it is now available online to view; especially if any of the following questions sound familiar to you:

You’re running MySQL or MariaDB 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 or MariaDB for a specific database workload?

A database server needs CPU, memory, disk and network in order to function. Understanding these resources is important for anybody managing a production database. Any resource that is weak or overloaded can become a limiting factor and cause the database server to perform poorly.

In this webinar, 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.

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

Speaker

Krzysztof Książek, Director of Support at Severalnines. For nearly 15 years Krzysztof has held positions as a SysAdmin & DBA designing, deploying, and driving the performance of MySQL-based databases. In his role at Severalnines Krzysztof and his team are responsible for delivering 24/7 support for our clients mission-critical applications across a variety of database technologies as well as creating technical content, consulting and training. His spare time is spent with his wife and child as well as the occasional hiking and ski trip.

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