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/