Why are my changes in
/etc/my.cnf reverted automatically?
cPanel/WHM can be configured to automatically adjust the following variables in MySQL:
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: