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 usage too high at same time daily

Discussion in 'Workarounds and Optimization' started by adias, Jan 27, 2014.

  1. adias

    adias Registered

    Joined:
    Jan 27, 2014
    Messages:
    3
    Likes Received:
    0
    Trophy Points:
    1
    cPanel Access Level:
    Root Administrator
    I have a big problem with my server. Every night at 2:00 AM is going down for 20-30 minutes. After many investigations mysql looks to be the problem.

    I have :
    CentOS release 6.5 (Final)
    WHM 11.40.1 (build 9)
    5.1.72-cll MySQL Community Server (GPLv2)
    A good server configuration

    What I did:
    - first I thought is to much traffic and I did all kind of optimizations for apache and mysql (mysqltuner.pl , tuning-primer.sh and so on). The problem is not here. I have about 200-300 visitors instantly and the load is : average: 0.26, 0.35, 0.35 . At the midnight when all services are down and is a high load are around 80-100 visitors

    - then I read about backups - so I disabled all kind of backup

    - crons - disabled all crons , stop crond service , removed all crons from cron.daily

    - stop all automatically check for updates and put everything on disable or manually update

    - I put this values on WHM at Configure cPanel Cron Jobs : upcp 0 0 1 1 * and cpbackup 0 0 1 1 *

    - disabled services like Analog,Awstats, Logaholic, Webalizer

    - enabled slow queries and verify each log for mysql, messages, etc

    - all databases optimized

    - no I/O problems

    So at the end I think is still a cron somewhere or something. Like you see on attached image mysql is going crazy . If I stop mysql before 2:00 AM with few seconds then start again after few seconds and everything is normal.

    Any suggestions ?
     

    Attached Files:

  2. cPanelMichael

    cPanelMichael Forums Analyst
    Staff Member

    Joined:
    Apr 11, 2011
    Messages:
    30,678
    Likes Received:
    648
    Trophy Points:
    113
    cPanel Access Level:
    Root Administrator
    Hello :)

    Check the output of the following command when MySQL is under heavy usage:

    Code:
    mysqladmin processlist
    This should provide information about which databases are using up your resources.

    Thank you.
     
  3. adias

    adias Registered

    Joined:
    Jan 27, 2014
    Messages:
    3
    Likes Received:
    0
    Trophy Points:
    1
    cPanel Access Level:
    Root Administrator
    After this command I removed leechprotect, Eximstats and cPBandwd. Now waiting for Santa at 2:00 AM.

    Thanks a lot for reply .
     
  4. adias

    adias Registered

    Joined:
    Jan 27, 2014
    Messages:
    3
    Likes Received:
    0
    Trophy Points:
    1
    cPanel Access Level:
    Root Administrator
    At the end was an wordpress plugin : Wordpress Popular Posts . Thanks a lot for help.
     
  5. cPanelMichael

    cPanelMichael Forums Analyst
    Staff Member

    Joined:
    Apr 11, 2011
    Messages:
    30,678
    Likes Received:
    648
    Trophy Points:
    113
    cPanel Access Level:
    Root Administrator
    I am happy to see you were able to determine the cause of the issue. Thank you for updating this thread with the outcome.
     
Loading...

Share This Page