WordPress.org

Ready to get started?Download WordPress

Forums

Please help me discover why my site goes down every week (38 posts)

  1. db0
    Member
    Posted 5 years ago #

    Hello all, I'm finally opening a topic here as I'm getting desperate with the problems I am experiencing. Basically what is happening is that almost weekly, my main site dbzer0.com will suddenly go down with "internal server errors". I am currently hosted with Dreamhost on a VPS which means my RAM is limited to 150MB (but I can increase it at will).

    Normally, those 150Mb are more than enough for 4 WordPress sies and 2 Gallery2 installations but at these (random?) points, my RAM usage will spike and all of them (which are on the same VPS) will go down.

    This is definitely related to only dbzer0.com as when this happens I can't access this site, no matter how much I increase my resources and I can avoid the usage spike by simply taking down only this site (renaming the root directory to something else for example) everything else keeps working splendidly. But as soon as I rename the dir back to its original name everything stops once more)

    I have tried many things to resolve it, even going as far as replacing my WP installation with a "factory default" one (so-to-speak) with no plugins and just the default theme. As soon as I restored the dir site usage once again spiked.

    I suspected a DDOS but I am quite a small fish so I can't imagine why this would happen. I also checked my access.log and didn't find much evidence to support this. I suspected web crawlers and I've even ammended my bots.txt file to slow them down but this keeps going on.

    I am really at the end of my wits. Is there anything you can suggest I should look for? Any way to troubleshoot this? Currently the site is down (I've renamed the dir again) and I lack ssh access as I'm currently behind a corporate firewall and lack internet access at home for the moment. So I can use only FTP for now.

    I've also contacted Dreamhost about this but in the past they haven't been of much help with issues such as these and can take up to 2 days to respond so I'm not expecting help soon from there.

    So please, help?

  2. Samuel B
    moderator
    Posted 5 years ago #

    my 1st option would be to run a repair on the database tables with phpmyadmin
    sounds like the wp_options table might be crashing

  3. db0
    Member
    Posted 5 years ago #

    Mate, you're genius! I just run a repair on the wp_options table and it immediately worked!

    Thanks!

    Why would the table become corrupted however? Server hiccup?

    EDIT: It seems I spoke too soon. The site loaded once but after I reloaded after posting this message, it was down again :(

  4. db0
    Member
    Posted 5 years ago #

    Ok, so I've run anothe repair on wp_options and this let the site back up again. 1 minute later, it was down. Another repair lasted 1 more minute etc. It seems that something is continuously corrupting this table?

    Deactivating plugins like crazy now

  5. db0
    Member
    Posted 5 years ago #

    I think I've got the suspect. As soon as I disabled the Intense Debate plugin the problem seems to have gone away.

    I am contacting the Devs now

    UPDATE: Nope, it lasted for longer this time but eventually site went down again. Looking more

    UPDATE2: Deactivated some other plugins with DB calls and enabled Intense Debate again. So far site still up

    UPDATE3: Nope, down again after 10 mins or so. This time a wp_options repair doesn't bring it up

  6. db0
    Member
    Posted 5 years ago #

    I disabled all plugins, switched to the default theme, and Internal Server error (IEE) occurred after a while again. Argh!

    Now rebooted server, disabled all plugins (bar Akismet for spam) and repaired wp_options. Will see IEE happens again

    UPDATE: It could be that the server was being brought down by another one of my sites before. Now took down everything except the main site dbzer0.com and waiting...

  7. dyords
    Member
    Posted 5 years ago #

    did you figure this one out already? i'm having trouble with my wp-options as well but it takes days for it to happen so i can't troubleshoot properly.

    do you have wp supercache installed? i think that's what's causing my db to crash.

  8. db0
    Member
    Posted 5 years ago #

    I'm still figuring it out.

    What I've done since is

    • Clean my Wp-options of its RSS (h/r)ash using the plugin clean options
    • Further Clean my WP-Options from its old info. Since I've been using the same DB since 2006, it had gotten a bit bloated (and still is)
    • Deactivated all plugins I use just a bit. I am slowly activating them (1 per week) and waiting to see what happens
    • I don't run WP-Supercache, but I know it causes problems if one is on Dreamhost PS. I user Hypercache.

  9. dyords
    Member
    Posted 5 years ago #

    my wp_options just crashed and all I did was posted something new. are you also using Live Writer to post?

  10. db0
    Member
    Posted 5 years ago #

    No, normal WP interface. It happened in a similar way for me. I would post something and then a bit (or a while) later, site would be down again. I haven't had it for the last 3 posting though so I'm hopeful.

    Which plugins are you currently using? Perhaps we can triangulate

  11. dyords
    Member
    Posted 5 years ago #

    heres my suspect plugins
    wp supercache
    yet another related post plugin
    subscribe to comments

    as for the others:
    all in one seo
    google sitemap
    feedburner feedsmith
    nextgen gallery
    wordpress stats

  12. db0
    Member
    Posted 5 years ago #

    Ok we seem to march on:

    • Platinum SEO pack (which is an updgrade over All in One SEO which has been discontinued AFAIK)
    • Google Sitemap
    • Feedburner Feedsmith
    • WordPress Stats

    I think it could be WP Stats at I think it's the only one of these accessing the DB. Also Sitemaps is one that can grab a lot of RAM to generate the map.

    However with both of them active, my site has been working fine now.

  13. dyords
    Member
    Posted 5 years ago #

    hmm i thought WordPress Stats doesn't take bandwidth off your site since it uses WordPress.org's tracking.

    anyway, let's wait whether your site is gonna crash again or not and backtrack from there.

  14. db0
    Member
    Posted 5 years ago #

    It's not the bandwidth that is killing the site though, it's something breaking wp_options

  15. dyords
    Member
    Posted 5 years ago #

    well ever since my wp_options kept crashing i always check my db every now and then even when there's nothing wrong with it.

    recently, i found that my db needs repairing (wp_options again) eventhough the effect is not evident on my site (did not redirect to install page).

    what I did prior to that was to edit some of the comments from my dashboard. i don't know if this is relevant but it's something we could use as reference.

  16. db0
    Member
    Posted 5 years ago #

    How can you tell if your wp_options is corrupted?

  17. whooami
    Member
    Posted 5 years ago #

    How can you tell if your wp_options is corrupted?

    wordpress will behave like its not installed, and you will be prompted to install (again).

    you can check for crashed tables inside phpmyadmin.

  18. dyords
    Member
    Posted 5 years ago #

    yeah i used phpmyadmin from my cpanel. there's an option to repair db.

  19. dyords
    Member
    Posted 5 years ago #

    i turned off supercache for a while. havent crashed yet for 3 days.

    what wordpress version are you using db0? I'm on 2.7.

  20. db0
    Member
    Posted 5 years ago #

    @whooami: In my case WordPress didn't behave like this. It simply started spawning runaway php processes. In phpmyadmin I just went to the table and selected "Repair" but I didn't see any notice of it being corrupted.

    @dryords: I'm using 2.7.1 without Supercache which is known to cause problems for Dreamhost.

  21. dyords
    Member
    Posted 5 years ago #

    hmm, just checking back. my blog seems to be stable for now with supercache turned off. how about yours? have you tried turning off hypercache?

    if this continues for another week i'll try using db-cache instead of supercache.

  22. db0
    Member
    Posted 5 years ago #

    Mine seems to be stable as well but I'm still using Hypercache and no DB-Cache.

    Of course I'm mostly offline lately so even if it did go down, I would probably miss it

  23. Michael Torbert
    WordPress Virtuoso
    Posted 5 years ago #

    @db0
    Platinum SEO is certainly not an upgrade over All in One SEO Pack, and AIOSEOP has absolutely not been discontinued.

  24. db0
    Member
    Posted 5 years ago #

    Unfortunately even though my site seemed to be running stably for 2 months now and I thought I'd found the culprit, once again I get the same issue now.

    Resource use takes off and Internal Server Errors happen. I repair the wp_options table and then it works fine.

    Can anyone tell me where to look to figure why this is happening? How can my wp_options table be corrupted just like that? Is there a way to start debugging this?

  25. cfisher
    Member
    Posted 4 years ago #

    Sorry to disappoint with all the work you did, but best I can tell, internal server errors and random website problems are a common experience with Dream Host. I had the EXACT same issues as you, and found that many others do as well. That is - until I came across HyperCache. After I installed this plugin, notices of my website being down went to essentially zero (use to get notices throughout the week). I still get random internal server errors and the WP admin is always slow, but my website is very fast. I use WP 2.8.4. Check out my website: http://www.bmedreport.com

    I then added WP Widget Cache to HyperCache with no problems for added speed. I am not sure if I can leave good enough alone as I now contemplate uninstalling the WP Widget Cache and replacing it with the DB Cache Reloaded. I read (actually at DreamHost support) that the HyperCache/DB Cache creates a fantastically fast website.

  26. db0
    Member
    Posted 4 years ago #

    cfisher, I've been using Hypercache for a long time now and it's not a caching issue. I'm the one who's written the unofficial DH WordPress performance guide and the one who suggested DB cache along with Hypercache. However afaik DB Cache's latest versions might be buggy so I suggest you stay away from it for now..

  27. cfisher
    Member
    Posted 4 years ago #

    Hi dB0,

    I think you might have misread my post just a bit. I said that HyperCache solved many of my problems - not that it caused them. Also, notice too that I said DB Cache Reloaded (notice: Reloaded)... it is a fork of the original DB cache that is suppose to be compatible with WP 2.8.4. Check it out..

    Also, I went ahead and installed the DB Cache Reloaded alongside HyperCache today and have not had a single problem, and my website seems really fast.

  28. db0
    Member
    Posted 4 years ago #

    I said that it's not a "caching issue" not that Hypercache is "causing the issue" ;)

    I know it's not, It's just that the same thing has happened many times while under Hypercache.

    I didn't know about DB Cache Reloaded. I might check it out, thanks :)

  29. elizabethrichardson
    Member
    Posted 4 years ago #

    Just wondering if you've checked your database with php MyAdmin wp-users for any bogus admin additions...?

    My site would crash after trying to publish a post - it had been infected. Repairing database tables didn't work for me either. It's fixed now, just thought I might mention it in case the same thing happened to you.

    All the best.

  30. db0
    Member
    Posted 4 years ago #

    I have in fact checked it. I couldn't find anything suspicious but I am considering recreating the DB just to get that possibility out of the way. It's only the myriad of options I'll have to reset that are holding me back....

Topic Closed

This topic has been closed to new replies.

About this Topic