Releem - Automatic MySQL performance tuning. Boost MySQL performance in under a minute.

Описание: Releem latest video:    • Automatic MySQL Performance Tuning. Boost ...  

We made a brief video showing how you can give your MySQL running on a Linux server a 30% boost with the help of automated settings optimization service. It literally takes about a minute to complete.

The service in question is Releem MySQLconfigurer, https://releem.com/?utm_source=youtub...

It analyzes the MySQLTuner report for your server and provides settings recommendations in the form of a MySQL configuration file.

The procedure is quite simple and well-described on the service page:
1. Download the script, its code is quite simple and can be viewed on github.
2. Launch the script.
3. Get the configuration file with recommended values (and current values in the comments).
4. Copy the newly created configuration file to the MySQL configuration directory.
5. Restart MySQL.

We tested the results with Sysbench on a virtual server running Debian 9 (2 CPU, 2GB Ram) the table contained 10 million entries.
Two configurations were tested, the MySQL default configuration and the configuration recommended by the MySQLConfigurer service. The tests were two-step: read (test1) only and read/write (test2).

Recommended configuration delivered a 30% boost to MySQL performance compared to the default configuration. Follow this link to see test results:
https://releem.com/blog/how-to-improv...

*Update 24.05.2020*

The launch of our new website [releem.com](https://releem.com)


*Update 24.06.2020*

*[New release](https://github.com/initlabopen/mysqlc...

Tested compatibility with MySQL 5.5, MySQL 5.6, MySQL 5.7, MariaDB 10.1, MariaDB 10.2, MariaDB 10.3.
Added calculation of the 'key_buffer_size' variable for improve performance of the MyIsam storage engine.
Added calculation of the 'innodb_buffer_pool_chunk_size' variable for MySQL 5.7.5 and later, MariaDB 10.2.2 and later.
Added calculation of the 'max_connections' variable based on 'Max_used_connections' MySQL status variable.
Improve calculation of the 'innodb_log_file_size' variable using 'innodb_log_files_in_group' variable.
Improve documentation with install dependencies step for Debian/Ubuntu and Centos/Redhat.
Fix documentation. Update example of the recommended configuration file.
Fix documentation. How to safely apply the configuration file.


*Update 08.07.2020*

*[New release](https://github.com/initlabopen/mysqlc...

Added calculation of the 'table_open_cache' variable.
Added calculation of the 'table_definition_cache' variable.


*Update 24.08.2020*

*[New release](https://github.com/releem/mysqlconfig...

Added MySQL 8 support.
Fixed calculation of the 'key_buffer_size' variable for MySQL 8.0.
Tested compatibility with MySQL 5.5, MySQL 5.6, MySQL 5.7, MySQL 8.0, MariaDB 10.1, MariaDB 10.2, MariaDB 10.3, MariaDB 10.4, MariaDB 10.5.
Improved documentation with Security section.
Improved documentation with information about setting open_files_limit.
Improved documentation with installation perl-Data-Dumper module on Centos.

*Update 21.11.2020*
*[New release](https://github.com/releem/mysqlconfig...

Improved documentation
Added option -m to set memory limit for MySQL in MBs. Closes #42.
Fixed downloading MySQLTuner every launch. Closes #46.
Added option -k - Releem API Key authorization.
Created Releem Community groups on Slack and Telegram.