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 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.
ClusterControl
The only management system you’ll ever need to take control of your open source database infrastructure.
Sign up for Planets9s
