Site downtime again
Looks like SQL was unhappy again, and my host helpfully locked down the site for me. This time, it looks like it was the “get recent comments” plugin, because there’s 30,000 comments on the site (that’s after deleting all the deleted ones and all the spam ones).
I’m opening the site temporarily just to see if we get errors again — if we do, it’ll shutter again briefly while I ponder what to try next.
Edit: looks like disabling the plug-in did the trick. However, it also looks like there’s a newer version of the plug-in that hits the database a lot less often (instead of every time the site is hit, it only hits it when a comment arrives). So I will try installing that tonight when I get home from work when I can watch the site to see if it is overloading again.
4 Responses to “Site downtime again”
Sorry, the comment form is closed at this time.
Not sure if its host related but you might want to check Hostmysite, Ive never had any issues they couldnt solve in less than 15 minutes, even at 3:30am on a holiday they usually pick up the phone before it rings 3 times. Also thier package really good for the price and scales really well.
[…] Raph’s Website » Site downtime again Says: January 3rd, 2007 at 0:21 […]
Did it work out?
Yeah, the new plug-in seems to be OK. Now when I check the SQL logs for slow queries, it’s far fewer of them instead of every time the site gets hit.
Now instead, I only seem to get it when people hit the monthly archives widget on the side here…