The Community Forums

Interact with an entire community of cPanel & WHM users!
  1. This site uses cookies. By continuing to use this site, you are agreeing to our use of cookies. Learn More.

Mysql cpu high since upgrade to whm56

Discussion in 'Workarounds and Optimization' started by popeye, May 18, 2016.

Tags:
  1. popeye

    popeye Well-Known Member

    Joined:
    May 23, 2013
    Messages:
    313
    Likes Received:
    0
    Trophy Points:
    16
    Location:
    Texas
    cPanel Access Level:
    Root Administrator
    Hi i noticed that since my upgrade to whm 56 dailey process log says mysql cpu 9.65 mem 1.03 mysql processes 0.0

    And when i look at process manager mysql cpu is over 100 it's use to be around 40.

    Does anyone know what can be doing this please.
     
  2. 24x7server

    24x7server Well-Known Member

    Joined:
    Apr 17, 2013
    Messages:
    1,146
    Likes Received:
    34
    Trophy Points:
    48
    Location:
    India
    cPanel Access Level:
    Root Administrator
    Hello :),

    I will suggest you please try to monitor your MySQL server process with " mysqladmin proc " command, With this command you can easily find out which user OR databases is using high CPU on your server.
     
  3. popeye

    popeye Well-Known Member

    Joined:
    May 23, 2013
    Messages:
    313
    Likes Received:
    0
    Trophy Points:
    16
    Location:
    Texas
    cPanel Access Level:
    Root Administrator
    You can see the same in whm under show mysql processes.

    And i have checked they are aew sleep progress is all 0

    It's something to do with the upgrade to 56 it was all fine until then.
     
  4. popeye

    popeye Well-Known Member

    Joined:
    May 23, 2013
    Messages:
    313
    Likes Received:
    0
    Trophy Points:
    16
    Location:
    Texas
    cPanel Access Level:
    Root Administrator
    I have now got MySQL Tuning Primer installed but not sure how to use or what code to add to my.cnf could anyone please give me some guidance
     
  5. tank

    tank Well-Known Member

    Joined:
    Apr 12, 2011
    Messages:
    236
    Likes Received:
    0
    Trophy Points:
    16
    Location:
    Chicago, IL
    cPanel Access Level:
    Root Administrator
    popeye

    Run
    :./mysqltuner.pl

    Post the results here.

    To make changes to you my.cnf, use your favorite linux text editor. I use nano

    nano /etc/my.cnf

    Change the variables that you would like and save. Make sure to restart MySQL.

    I would also encourage you to search on the internet for how to do this. There is tons of information out there.
     
  6. popeye

    popeye Well-Known Member

    Joined:
    May 23, 2013
    Messages:
    313
    Likes Received:
    0
    Trophy Points:
    16
    Location:
    Texas
    cPanel Access Level:
    Root Administrator
    Hi thanks for the reply so do i jsut run :./mysqltuner.pl ? i was told it's sh tuning-primer.sh
     
  7. popeye

    popeye Well-Known Member

    Joined:
    May 23, 2013
    Messages:
    313
    Likes Received:
    0
    Trophy Points:
    16
    Location:
    Texas
    cPanel Access Level:
    Root Administrator
    I would not remove anything until your sure. i need to find some help because waiting for answers from here takes to long.
     
  8. cPanelMichael

    cPanelMichael Forums Analyst
    Staff Member

    Joined:
    Apr 11, 2011
    Messages:
    30,854
    Likes Received:
    676
    Trophy Points:
    113
    cPanel Access Level:
    Root Administrator
    Hello,

    Please review the following thread and let us know if you have additional questions:

    mysqlmymonlite.sh server stats gathering tool for cPanel Server

    Thanks!
     
Loading...

Share This Page