SOLVED [CPANEL-21968] Auto Adjust Mysql Limits using 100%

[starchild2012]

Hi,

I've noticed for a few days now, the following script using 100% CPU constantly. I don't ever recall seeing this before.

Should I be concerned?

/usr/local/cpanel/3rdparty/bin/perl /usr/local/cpanel/scripts/auto-adjust-mysql-limits --no-restart

We're currently running CENTOS 7.4 standard [server], v74.0.6

 

[cPanelMichael]

Hello @starchild2012,

This is a known issue where it's possible for the auto-adjust-mysql-limits script to hang during the attempt to restart MySQL upon the adjustment to the /etc/my.cnf file. A fix is scheduled for publication in an upcoming build of cPanel & WHM version 74 as part of internal case CPANEL-21968. I'll update this thread again once it's published. In the meantime, the temporary workaround is to manually kill the auto-adjust-mysql-limits process and then restart MySQL using the steps below:

1. Find the process ID associated with the auto-adjust-mysql-limits process:

ps aux|grep auto-adjust-mysql-limits

2. Kill the process ID:

kill -9 $PID

3. Restart MySQL:

/scripts/restartsrv_mysql

Thank you.

 

[cPanelMichael]

Hello,

To update, this is fixed in cPanel & WHM version 76:

Fixed case CPANEL-21968: Avoid hang when restarting MySQL if my.cnf needs adjustment.

You can monitor the following page to see when version 76 reaches each release tier:

cPanel Release Highlights

Thank you.

 

[starchild2012]

Thank you kindly.

 

[sparek-3]

Why does this have to run? Can it be disabled?

I'm still on cPanel 74, so maybe this has been answered in cPanel 76.

 

[cPanelMichael]

Why does this have to run? Can it be disabled?

Hello @sparek-3,

You can disable the following options in WHM >> Tweak Settings if you want to disable the automatic adjustment of the /etc/my.cnf file:

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?

We document how this script works at:

The auto-adjust-mysql-limits Script - Version 76 Documentation - cPanel Documentation

Thank you.