Please whitelist cPanel in your adblocker so that you’re able to see our version release promotions, thanks!

The Community Forums

Interact with an entire community of cPanel & WHM users!

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

Discussion in 'Database Discussion' started by starchild2012, Aug 28, 2018.

  1. starchild2012

    starchild2012 Member

    Joined:
    Jul 24, 2012
    Messages:
    16
    Likes Received:
    1
    Trophy Points:
    3
    cPanel Access Level:
    Root Administrator
    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
     
  2. cPanelMichael

    cPanelMichael Technical Support Community Manager Staff Member

    Joined:
    Apr 11, 2011
    Messages:
    47,335
    Likes Received:
    2,163
    Trophy Points:
    363
    cPanel Access Level:
    Root Administrator
    Twitter:
    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:

    Code:
    ps aux|grep auto-adjust-mysql-limits
    2. Kill the process ID:

    Code:
    kill -9 $PID
    3. Restart MySQL:

    Code:
    /scripts/restartsrv_mysql
    Thank you.
     
    Stop hovering to collapse... Click to collapse... Hover to expand... Click to expand...
  3. cPanelMichael

    cPanelMichael Technical Support Community Manager Staff Member

    Joined:
    Apr 11, 2011
    Messages:
    47,335
    Likes Received:
    2,163
    Trophy Points:
    363
    cPanel Access Level:
    Root Administrator
    Twitter:
    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.
     
    Stop hovering to collapse... Click to collapse... Hover to expand... Click to expand...
  4. starchild2012

    starchild2012 Member

    Joined:
    Jul 24, 2012
    Messages:
    16
    Likes Received:
    1
    Trophy Points:
    3
    cPanel Access Level:
    Root Administrator
    Thank you kindly.
     
    cPanelMichael likes this.
  5. sparek-3

    sparek-3 Well-Known Member

    Joined:
    Aug 10, 2002
    Messages:
    1,920
    Likes Received:
    167
    Trophy Points:
    343
    cPanel Access Level:
    Root Administrator
    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.
     
  6. cPanelMichael

    cPanelMichael Technical Support Community Manager Staff Member

    Joined:
    Apr 11, 2011
    Messages:
    47,335
    Likes Received:
    2,163
    Trophy Points:
    363
    cPanel Access Level:
    Root Administrator
    Twitter:
    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.
     
    Stop hovering to collapse... Click to collapse... Hover to expand... Click to expand...
Loading...

Share This Page

  1. This site uses cookies to help personalise content, tailor your experience and to keep you logged in if you register.
    By continuing to use this site, you are consenting to our use of cookies.
    Dismiss Notice