Changes to MySQL configuration are reverted automatically

Question

Why are my changes in /etc/my.cnf reverted automatically?

Answer

cPanel/WHM can be configured to automatically adjust the following variables in MySQL:

open_files_limit

max_allowed_packet

innodb_buffer_pool_size

If you would rather set custom values for these variables, cPanel's automated management of them can be disabled in WHM -> Tweak Settings by toggling the following settings to 'Off':

- Allow cPanel & WHM to determine the best value for your MySQL open_files_limit configuration?

- Allow cPanel & WHM to determine the best value for your MySQL max_allowed_packet configuration? 

- Allow cPanel & WHM to determine the best value for your MySQL innodb_buffer_pool_size configuration?

Further information on how cPanel determines the best values for these MySQL variables can be found in our documentation:

https://docs.cpanel.net/whm/server-configuration/tweak-settings/