How do you keep high-performance MySQL configuration?
SEPT 21, 2020 • WRITTEN BY ROMAN AGABEKOV
We conducted a survey of several hundreds software engineers who have experience in manage servers with installed MySQL / MariaDB / Percona and asked them how do they improve performance of their servers and how long does this process take?
Here are some results:
We made the infographic that summarizes results of this survey.
Here are some results:
- More than 60 percent of all engineers analyze MySQL Monitoring reports to detect performance degradation. To go further and take proactive measures, check out our guide on Advanced Strategies for Proactive MySQL Performance Optimization.
- More than 70 percent of all engineers optimize MySQL configuration routinely and manually to improve performance and reduce costs. For detailed methods on optimizing your database, see our article on Database Performance Tuning Techniques.
- MySQL configuration files optimization (per one server) takes from 30 minutes to several hours. Learn how to improve performance even with MySQL 5.7’s default setup in our article How to Improve Performance in MySQL 5.7 Default Configuration.
We made the infographic that summarizes results of this survey.
Releem can automatically detect MySQL performance degradation and optimizes MySQL configuration files to improve MySQL performance and reduce costs. Sign up here.
Article by
- Founder & CEORoman Agabekov has 17 years of experience managing and optimizing MySQL and MariaDB in high-load environments. He created Releem to automate routine tasks like performance monitoring, tuning, and query optimization. His articles share practical insights to help others maintain and improve their MySQL databases.