Behind the scenes
23Nov2004 Filed under: LogisticaMy beloved web mistress, Jennifer, is helping me transition to mySQL, so you may notice some weirdness around here for a bit. Never fear: it’s all part of the process to try to reduce some of the load on my server from the comment spam flooding in (4000+ spam comments blocked so far — jeez). First we switch over to mySQL, then we close comments for all posts older than 10 days. Voila!
Update: All done! The only change y’all should notice is faster loading time and closed comments on old posts. If anyone’s feeling really geeky and curious, here’s what Jennifer did:
1. Convert from berkeley db to mySQL
2. Install and run the MT-Close2 plugin
3. Tada!
- Previous: Flickr Screensaver
- Next: Hi, Phidelity
5 Responses to “Behind the scenes”
Leave a reply
Hey there. I'm Ariel Meadow Stallings, a native Seattleite who's written my way up and down the Left Coast. Electrolicious is where I post daily randomata, but I also write for a living. My first book, Offbeat Bride, was published last year.
You're reading a page from the archives. Check the homepage for current content.
McGil
November 27th, 2004 at 2:24 pm
“we close comments for all posts older than 10 days” … wow … astonishing … you’re really going to do that ???!!?!?! …
Ariel
November 27th, 2004 at 3:39 pm
Yup, McGil. Thanks to MT-Close2, closing comments is totally automated and very easy. Plus, no one really comments on those old posts anyway.
McGil
November 29th, 2004 at 1:41 pm
I totally agree that it’s very easy … But what a loss on freedom of speech for your visitors
I mean there’s got to be a better way to avoid spammers than cutting the user input … what will happen in 6 months ? cut every comment ?
Dawn
December 3rd, 2004 at 11:51 am
Are you using Jay Allen’s MT-Blacklist plug-in?
http://www.jayallen.org/projects/mt-blacklist/
I still get some spam, but this really does control a lot of it.
I think it’s a bummer to close comments on old entries…you never know when an old friend is going to stumble by via an old entry.
Ariel
December 3rd, 2004 at 11:55 am
Yup: I was using mt-blacklist v2.01b, and it kept me from actually getting many spams, but the comment spammers were absolutely HAMMERING my mt-comments.cgi script, at points almost crashing the server my site lives on. My host was threatening to shut my site down, because that one script was ruining the server for everyone. Therefore: this was what I had to do.
More info here.