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.

Sites go down, load drops to cero, mysql lost connection errors...?

Discussion in 'General Discussion' started by Drowned, Nov 17, 2006.

  1. Drowned

    Drowned Member

    Joined:
    Dec 5, 2003
    Messages:
    19
    Likes Received:
    0
    Trophy Points:
    1
    This has been happening for the past 2 weeks, at around 7pm mostly, it seems every 2 days or so... all sites go down, the load drops to zero but the server is VEEERY SLOW, like the connection was maxed out... lots of mysql lost connection errors by vbulletin on my inbox... sites go backup after cpanel restarts everything itself...

    What could cause something like this? There are ZERO clues in the logs :( I'm out of ideas :(
     
  2. jayh38

    jayh38 Well-Known Member

    Joined:
    Mar 3, 2006
    Messages:
    1,215
    Likes Received:
    0
    Trophy Points:
    36
    Check for cronjobs on the server. If you are seeing 0 load in whm then most likely
    the load is thru the roof. Monitor in top and or try ps aux to see what is running.

    This could be something such as backups or some other system process which
    is why it may not look obvious in the logs.
     
  3. AndyReed

    AndyReed Well-Known Member
    PartnerNOC

    Joined:
    May 29, 2004
    Messages:
    2,222
    Likes Received:
    3
    Trophy Points:
    38
    Location:
    Minneapolis, MN
    What are these error messages?
     
  4. Drowned

    Drowned Member

    Joined:
    Dec 5, 2003
    Messages:
    19
    Likes Received:
    0
    Trophy Points:
    1
    I checked last night since it happened again and it wasn't at 0 all the time, but it was too low, like the cpu was just idling there... the server still was super slow.

    I'm going to check the cronjobs...:mad:
     
  5. Drowned

    Drowned Member

    Joined:
    Dec 5, 2003
    Messages:
    19
    Likes Received:
    0
    Trophy Points:
    1
    I'm running a vbulletin forum on my server and vbulletin is setup to send you an e-mail any time it gets a mysql error. It gives you a lot of details, like this:

    Database error in vBulletin :

     
  6. Drowned

    Drowned Member

    Joined:
    Dec 5, 2003
    Messages:
    19
    Likes Received:
    0
    Trophy Points:
    1
    My server seems to crash at around 7pm my time, 1am server time, which is exactly when the backup is made according to my crons... I'm going to delay the backup to 1am my time cause at 7pm the server's load is still high... wish me luck...
     
  7. jayh38

    jayh38 Well-Known Member

    Joined:
    Mar 3, 2006
    Messages:
    1,215
    Likes Received:
    0
    Trophy Points:
    36
    You did not mention you had forums an probably a very large mysql databse.

    When the backup runs, it will shut down mysql so that it can dump the
    databases. This is why there is no response from the pages and the
    load is low.

    Schedule your backup for low usage time and perhaps tell your forum
    admins to announce server maintenace times.
     
Loading...

Share This Page