If you use a MySQL or MariaDB database with Helium and have a lot of tracks you might need to do some additional configuration to your database config file.
MySQL 5.6+ or MariaDB 10.1+ should be used.
The most important settings are listed below:
- lower_case_table_names=1 (no longer required starting with Helium 14.2)
- innodb_buffer_pool_size=1017M
- innodb_log_file_size=500M
- innodb_log_buffer_size=800M
- max_allowed_packet=64M
- wait_timeout=7000
If some of the attributes listed above does not exists in your configuration file, please add them.
Please note that you should restart the Mysql service after you have updated your configuration.
Additional details can be found here:
- http://dev.mysql.com/doc/refman/5.7/en/identifier-case-sensitivity.html
- https://dev.mysql.com/doc/refman/5.6/en/innodb-parameters.html#sysvar_innodb_buffer_pool_size
- http://dev.mysql.com/doc/refman/5.7/en/innodb-parameters.html
- http://dev.mysql.com/doc/refman/5.7/en/server-system-variables.html#sysvar_max_allowed_packet
- http://dev.mysql.com/doc/refman/5.7/en/server-system-variables.html#sysvar_wait_timeout
The configuration file for MySql (Windows) is generally found at:
%PROGRAMDATA%\MySQL\MySQL Server 5.6\my.ini
The configuration file for MariaDb is generally found at:
%PROGRAMFILES%\MariaDB 10.1\data