Automatic MySQL Performance Tuning. Boost MySQL Performance
Don't tune MySQL configuration manually. MySQL Performance Tuning in 1 minute.
Save your time and improve performance using Releem.
Hello, my name is Roman.
The performance of Wordpress, Drupal, Joomla, Bitrix, Phpbb instance, or that of any other web applications that rely on MySQL, largely depends on the database response speed.
It annoys me that only experienced engineers can tune MySQL configuration to improve the performance, and even they spend a lot of time on this task.
I spent hundreds of hours tuning MYSQL configuration to improve performance of different web apps...
The MySQL configuration tuning process is clear. It includes the following steps:
1. Read the docs.
2. Learn the best practices.
3. Analyze the monitoring data.
4. Analyze the MySQL status.
5. Use the scripts to get recommendations.
6. Determine which settings would yield the best performance.
7. Create the MySQL configuration file.
8. Apply the configuration file.
I’ve gone far and wide in search of applications that could tune MySQL for best performance, preferably in the fully automatic mode. My search did not return a solution that could be called good, let alone perfect.
So I decided to develop one myself…
I teamed up with my friends, experienced software engineers, and we built Releem.
It’s kind of like a virtual assistant for software engineers.
Here is what it does:
1. Collects MySQL status metrics, system information from the server, and transfers them to Releem platform.
2. Analyzes the collected metrics and detects performance issues, fully automatic.
3. Alerts of the MySQL performance issues found.
4. Automatically generates a conf file tailored to your server, with the parameters to boost MySQL performance.
We’ve been testing it for 9 months with one thousand servers, and I am now excited to report that the tool does save time and resources by improving MySQL configuration and significantly boosting its performance in most cases.
Using Releem developers can focus on improving their products without worrying about gaining a depth knowledge of the MySQL database backend domain.
I published the screencast to explain how it works.
We’re still on pre-launch, but you can visit us and sign up to give it a shot at https://releem.com/?utm_source=youtub...
*Update 17.06.2021*
*[New Releem release](https://github.com/releem/mysqlconfig...
Added MySQL Performance Score metric.
Added runtime information. Closes #62
Added Display Recommended Configuration.
Improved documentation Installation, Usage and Tests.
Improved calcualtion of the 'myisam_sort_buffer_size' variable.
Improved calculation of the 'read_rnd_buffer_size' variable.
Improved calculation of the 'sort_buffer_size' variable.
Removed usage of "mysqltuner.pl" domain.
*Update 16.11.2021*
*[New Releem release](https://github.com/releem/mysqlconfig...
Added Display timezone on server page. Closes #72
Added Documentation.
Added Automated Installation of Releem Agent
Fixed Cache values too high. Closes #73
Fixed Error when no Innodb tables only MyISAM. Closes #76
Fixed The values on the left and right are not in the same terminology. Closes #74
Removed MySQLTuner Recommendations
*Update 12.01.2022*
*[New Releem release](https://github.com/releem/mysqlconfig...
Added support of MariaDB 10.6. Closes #82
Added Automated subscriptions and credit card payments
Added hostnames to servers list. Closes #77
Improved documentation
*Update 30.03.2022*
*[New Releem release](https://github.com/releem/mysqlconfig...
Added checks of the database server version
Added configuration file releem.conf
Added -u option to update Releem Agent
Added list of variable changes. Closes #75
Improved calculation of max_heap_table_size
Improved calculation of tmp_table_size
Fixed MySQLTuner version
Fixed metrics collection
