Community Forums
Connect with us on LinkedIn
+ Reply to Thread
Results 1 to 7 of 7
  1. #1
    Member
    Join Date
    Dec 2003
    Posts
    19

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

    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. #2
    Member
    Join Date
    Mar 2006
    Posts
    1,215

    Default

    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. #3
    cPanel Partner NOC cPanel Partner NOC Badge AndyReed's Avatar
    Join Date
    May 2004
    Location
    Minneapolis, MN
    Posts
    2,223

    Default

    Quote Originally Posted by Drowned View Post
    lots of mysql lost connection errors by vbulletin on my inbox...
    What are these error messages?
    Andy Reed
    RHCE and CCNA
    ServerTune.com

  4. #4
    Member
    Join Date
    Dec 2003
    Posts
    19

    Default

    Quote Originally Posted by jayh38 View Post
    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.
    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...

  5. #5
    Member
    Join Date
    Dec 2003
    Posts
    19

    Default

    Quote Originally Posted by AndyReed View Post
    What are these error messages?
    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 :

    mysql_connect(): Lost connection to MySQL server during query
    /home/client/public_html/forum/includes/class_core.php on line 273

    MySQL Error :
    Error Number :
    Date : Saturday, November 18th 2006 @ 01:18:06 AM
    Script : http://website.com/
    Referrer :
    IP Address : 220.92.24.149
    Username : Unregisterd
    Classname : vb_database

  6. #6
    Member
    Join Date
    Dec 2003
    Posts
    19

    Default

    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. #7
    Member
    Join Date
    Mar 2006
    Posts
    1,215

    Default

    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.

Similar Threads & Tags
Similar threads

  1. Replies: 0
    Last Post: 03-12-2010, 11:09 PM
  2. lost connection during setup
    By assassin85 in forum New User Questions
    Replies: 1
    Last Post: 10-14-2009, 10:08 PM
  3. Connection lost when upgrading..
    By benito in forum cPanel and WHM Discussions
    Replies: 1
    Last Post: 06-01-2007, 10:24 PM
  4. Lost connection to MySQL server during query
    By DjMiX in forum cPanel and WHM Discussions
    Replies: 1
    Last Post: 08-15-2006, 01:58 PM
  5. Most likely causes of intermittent mysql connection errors?
    By spaceman in forum cPanel and WHM Discussions
    Replies: 0
    Last Post: 07-31-2005, 08:58 AM
Linkedin       Facebook       Twitter       RSS       Flickr       YouTube