Help! My Host and Restarted continously!

Discussion in 'Site & Server Administration' started by cowy, Sep 13, 2009.

  1. #1
    Hi DP fellow,
    I just moven my sites from Shared hosting to a managed VPS account due to traffic increase. It went well, but sometimes once or twice a day, my sites down and when they up, I receive message like this:

    httpd failed @ Sun Sep 13 20:09:29 2009. A restart was attempted automagically.
    Service Check Method: [tcp connect]

    Failure Reason: Unable to connect to port 80

    Then my site when OK. The downtime is not too long, maybe just about 5 minutes. Today I receive about 18 message like that to my inbox and that mean I experience 5x18 minutes downtime. It's really disgusting!!

    I'm not a techie person and just use VPS to store Wordpress blogs. What is the best solution to solve this problem? Because everytime I contact support, they said the blogs are OK, it's because the downtime only 5 minutes and by the time they read the email, the server is solved but 30 minutes later my VPS crashed again!!

    If I have to move again.. What is your recommendation? I have about 7000-8000 traffic a day and using heavy Wordpress Plugins like Related Post, All in One SEO pack and many more.

    Any advice will be appreciated, Thanks!!
     
    cowy, Sep 13, 2009 IP
  2. RHS-Chris

    RHS-Chris Well-Known Member

    Messages:
    1,007
    Likes Received:
    35
    Best Answers:
    10
    Trophy Points:
    150
    #2
    The best solution, is to get your managed VPS, managed! It sounds like they are ignoring the problem. Logs can be checked. Tell them to do the job you are paying them for, or, find another host that will.
     
    RHS-Chris, Sep 13, 2009 IP
  3. cowy

    cowy Peon

    Messages:
    240
    Likes Received:
    3
    Best Answers:
    0
    Trophy Points:
    0
    #3
    Yes, I contacted today and they tweaked my account, but the problem still insist.

    They check the logs and said that there are "sleep queries" in my heavy wordpress site, can you help me what it means and how to resolve it?

    Thanks a lot!!!
     
    cowy, Sep 13, 2009 IP
  4. RHS-Chris

    RHS-Chris Well-Known Member

    Messages:
    1,007
    Likes Received:
    35
    Best Answers:
    10
    Trophy Points:
    150
    #4
    What are the logs stating? I am going to guess that apache is hitting the max connections limit? Perhaps tweaking your mysql configuration to drop connections quicker, or, cache more so that queries take up less time.
     
    RHS-Chris, Sep 13, 2009 IP
  5. cowy

    cowy Peon

    Messages:
    240
    Likes Received:
    3
    Best Answers:
    0
    Trophy Points:
    0
    #5
    Hi Chris,
    Thanks for solution.
    My host support optimize the sever and I installed wp super cache now (previously Wp cache).

    Yeah, I think the mysql database is so heavy and the apache hitting the maximum connection limit. Now I tried to disabling some plugins and let's see if it works.

    Anyway Chris, thanks for your solution :)
     
    cowy, Sep 13, 2009 IP