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!

Every morning at 2:05am my server slows down for a couple of minutes.

Discussion in 'General Discussion' started by OahuRE.com, Mar 24, 2012.

  1. OahuRE.com

    OahuRE.com Registered

    Joined:
    Mar 24, 2012
    Messages:
    4
    Likes Received:
    0
    Trophy Points:
    51
    cPanel Access Level:
    Website Owner
    At 2:05am every morning all MySQL queries that normally take 1/2 second or less take 6 to 7 seconds and end up in my slow query log.

    I ran Top at 2:05am and noticed the following command which seemed to be very CPU intensive at 99.4%.

    PID USER PR NI VIRT RES SHR S %CPU %MEM TIME+ COMMAND
    7899 oahure 39 19 77284 58m 1176 R 99.4 0.7 0:13.20 /usr/local/cpanel/3

    Anyone know what the command above is doing and is it possible this could be the cause of my slow down?
     
  2. storminternet

    storminternet Well-Known Member

    Joined:
    Nov 2, 2011
    Messages:
    460
    Likes Received:
    0
    Trophy Points:
    66
    cPanel Access Level:
    Root Administrator
    Have you checked crons added for user oahure. Perhaps cron might be scheduled to run at that time.
     
    Stop hovering to collapse... Click to collapse... Hover to expand... Click to expand...
  3. OahuRE.com

    OahuRE.com Registered

    Joined:
    Mar 24, 2012
    Messages:
    4
    Likes Received:
    0
    Trophy Points:
    51
    cPanel Access Level:
    Website Owner
    I did check my Crons and I do not have anything setup to run at that time.

    Not sure if cPanel by default has its own Cron jobs that perhaps rotate logs or do something else at 2:05am.
     
  4. OahuRE.com

    OahuRE.com Registered

    Joined:
    Mar 24, 2012
    Messages:
    4
    Likes Received:
    0
    Trophy Points:
    51
    cPanel Access Level:
    Website Owner
    I am thinking it might be a reference to the 3.html file that the Analog stat collection program is creating. I have disabled Analog and will see if I get the same slow down again.
     
  5. cPanelTristan

    cPanelTristan Quality Assurance Analyst
    Staff Member

    Joined:
    Oct 2, 2010
    Messages:
    7,609
    Likes Received:
    32
    Trophy Points:
    238
    Location:
    somewhere over the rainbow
    cPanel Access Level:
    Root Administrator
    Since the command line is truncate, next time you see that happen (if it does again), please ps aux processes by that username:

    Code:
    ps aux | grep oahure
    This way you will see the full command line for what is running.
     
    Stop hovering to collapse... Click to collapse... Hover to expand... Click to expand...
  6. OahuRE.com

    OahuRE.com Registered

    Joined:
    Mar 24, 2012
    Messages:
    4
    Likes Received:
    0
    Trophy Points:
    51
    cPanel Access Level:
    Website Owner
    Thanks, I added your ps command too.

    I did disable Analog stat collection and so far no slow queries so I think it might have fixed the problem but I will wait a few more days to make sure.
     
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