The spam I was getting had reached sickening levels. I could delete all the spam, and then literally watch new ones come in. Now don’t get me wrong, I love \1agra as much as the next guy, but it was pretty tough to sort out the one or two real comments in the 28,000 messages I had awaiting me.
So I got my hands dirty and went to town with SQL, trying to delete posts based on heinously weak heuristics I made up on the spot (for example, if the content of a post was only a single link with rel=”nofollow” I deleted it. That said, if you’ve left a comment and I didn’t approve it, I apologize.
As for the future, I’ve installed the lovely reCAPTCHA for my comments which will hopefully stop at least the stupider spam bots (I think my favorite one that actually left “Jakarta Commons HTTP Client” as the user-agent. So very weak!) So while it will be a tiny bit more of a pain to comment, the chances of them getting accepted and making it through are increased by untold orders of magnitude. I believe you can get the CAPTCHA words read to you if you like that sort of thing (I know I get my Mac to read my posts back to me.)
I also went ahead an upgraded to the latest version of WordPress (have to say the post authoring section is vastly improved) so that it will stop bothering me about it.
So there we have it – hopefully there will be less spam, and hopefully there will be more comments. Because what the world needs now is love, sweet love.
It’s the only thing there’s just too little of.
 What, doesn’t everyone?