Jelastic PaaS Smart Auto-Configuration automatically adjusts the MySQL, MariaDB, and Percona databases in accordance with the resource limit allocated to the containers. Namely, the changes affect the /etc/my.cnf configuration file and the following settings in particular:
Starting with the 5.7 and 8.0 versions of the MySQL/Percona and MariaDB 10.x, two additional parameters are configured by Jelastic:
- innodb_buffer_pool_instances - deprecated in MariaDB since the 10.6.x (always 1 pool instance)
If you want to manually change any of the settings from the list above, you need to set the JELASTIC_AUTOCONFIG environment variable to “false”, “disable”, or “0”. Otherwise, your custom changes will be overwritten.
If you want to manually change the auto-configured settings on the old containers, you need to remove the “#Jelastic autoconfiguration mark.” line at the start of the /etc/my.cnf file.