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!

MySQL Governor not working properly

Discussion in 'CloudLinux' started by Deker, Oct 20, 2018.

  1. Deker

    Deker Well-Known Member

    Joined:
    Feb 15, 2011
    Messages:
    99
    Likes Received:
    4
    Trophy Points:
    58
    cPanel Access Level:
    Root Administrator
    Hi there,
    We are running Cloudlinux + Cpanel (both latest version) , 8 core i7 CPU + 32GB of RAM.
    Our server load was too high (100+) so we decided to install mysql governor to manage mysql queries and reduce the server load.
    The mysql governor was installed successfully and seems to be working, but mysql cpu usage is still high (Up to 800% !!).
    We are using default configuration in abusers mode (I also tried "all" mode but didn't see any differences).
    I have 2 questions in this regard:
    1. I realized that the cloudlinux did not create /usr/container/dbuser-map file automatically.
    Should I do something to force cloudlinux to create this file?
    2. Why the mysql usage is still too high? Are we missing any specific configuration? We just using default settings.
     
  2. cPanelLauren

    cPanelLauren Forums Analyst II Staff Member

    Joined:
    Nov 14, 2017
    Messages:
    5,815
    Likes Received:
    443
    Trophy Points:
    233
    Location:
    Houston
    cPanel Access Level:
    DataCenter Provider
    Hi @Deker

    I'd suggest looking over the documentation here: CloudLinux Documentation to ensure that it's behaving properly as well as configured correctly.

    Thanks!
     
    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