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?
A database server needs CPU, memory, disk and network in order to function. Understanding these resources is important for a DBA, as any resource that is weak or overloaded can become a limiting factor and cause the database server to perform poorly. A main task of the DBA is to tune operating system and database configurations and avoid overutilization or underutilization of the available resources.
In this webinar, we’ll discuss some of the settings that are most often tweaked and which can bring you significant improvement in the performance of your MySQL database. We will also cover 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.
Date, Time & Registration
Tuesday, June 14th at 09:00 BST / 10:00 CEST (Germany, France, Sweden)
Tuesday, June 14th at 09:00 Pacific Time (US) / 12:00 Eastern Time (US)
- Database tuning - the what and why
- Principles of the tuning process
- Tuning the Operating System configuration
- Tuning the MySQL configuration
- Useful tools
- What to avoid when tuning OS and MySQL configuration
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.
This webinar is based on our popular blog series ‘Become a MySQL DBA’.
We look forward to “seeing” you there!
To view all the blogs of the ‘Become a MySQL DBA’ series visit: http://www.severalnines.com/blog-categories/db-ops.