« [House Project]... | Main | What's up with Inbox... »
20031214 Sunday December 14, 2003

This Site's Stability I don't know if you've noticed, but this site has been incredibly stable the last few days. It had been crashing daily for most of last week. I even considered a new hosting provider to get rid of my OutOfMemory errors. Frequent crashing began shortly after I upgraded to 0.9.9. Driving home on Wednesday night, I had a hunch - my old theme showed that I had 24,000 referrers since I upgraded on November 26th. Referrers weren't rolling over (clearing the list) every night like they were supposed to be - and there is a bug where clearing the referrers through the editor UI doesn't work either.

So, lazy me just let them keep stacking up. When my cache was refreshed every few hours, it must've been putting a pretty big strain on the system to fetch all those referrers. Finally, I deleted the referrers manually ("delete from referrer") and the site hasn't crashed since. Of course, I keep logging in and clearing them out daily, but this does seem to have solved the problem. It's funny how satisfying a stable site can be when you're used to one that crashes 2-3 times per day. Posted in Roller at Dec 14 2003, 05:58:01 AM MST 4 Comments

Comments:

It just occurred to me that I'd seen a similar issue on my site; unable to clear referers via the Referers admin page. The issue I found was a referer from an Asian search engine (I forget whose, one of MSN Google or Yahoo). So please try letting it go one day and see if the nightly works now. If not, check for a referer with strange characters. This all points back to our database needing to support internationalization better.

Posted by Lance on December 14, 2003 at 10:08 AM MST #

Thanks Lance - I'll let it go overnight and see what happens.

Posted by Matt Raible on December 14, 2003 at 10:34 AM MST #

Nope, didn't work. The Editor UI for clearing referers still doesn't work either.

Posted by Matt Raible on December 15, 2003 at 07:34 AM MST #

Funny, mine has been working no problem (though I'm slightly older than CVS now).

Posted by Lance on December 17, 2003 at 04:34 PM MST #

Post a Comment:
  • HTML Syntax: Allowed