New WHM Tweak Settings – Regarding MySQL

I recently found a specific explanation for why I keep seeing mysql settings being off in my.cnf and causing load issues.
Recent changes in WHM have added an option to Tweak settings that will allow WHM to determine the “best” settings value. So anytime mysql is restarted from within cpanel, the settings are changed/modified. These settings are on by default.
  • Allow cPanel & WHM to determine the best value for your MySQL open_files_limit configuration?
    This setting’s value defaults to On.
  • Allow cPanel & WHM to determine the best value for your MySQL max_allowed_packet configuration?
    This setting’s value defaults to On.
  • Allow cPanel & WHM to determine the best value for your MySQL innodb_buffer_pool_size configuration?
    This setting’s value defaults to On.
If you are experiencing load issues of unknown origin, this would be something else to check.
Documentation can be found at the below link and is current as of Jun 24, 2016

A friend needs help…

https://www.gofundme.com/2j8nnw4

I normally would not do this here but a friend of mine is in a bad spot, working two job, going to school and needs help. Please check it out and drop a $1.00, $2.00, $5.00 or whatever you can to help. She’s a single mom with two small kids who could use a hand and I know this killed her to ask for this… she does not know I am dropping this here…

I’ve been here long enough to know how generous, kind and awesome my fellow g33k’s are in helping those who have hit a rough spot in life…

Thanks for anything you can do to help in advance…

(p.s. she’s an awesome mom and deserves a break!)

https://www.gofundme.com/2j8nnw4