That’s a lot of spam
While monitoring my Bad Behaviour installation during the day today, I wanted to know how much comment spam I had been receiving. So I hopped into the database and ran a little mojo on it:
SELECT comment_approved, count(*)
FROM wp_comments
GROUP BY comment_approved
The number returned was staggering. As it turns out, my blog has received 2,726 comments…of which 2,602 are spam (I flag comments as spam rather than delete them so I can do just this sort of analysis). That’s more than 95% spam! I can only imagine how mad I’d get with my email if spam rates there were as high.
Anyway, I just figured I’d share just how much comment spam I’ve moderated since I turned comment moderation on back in May (a little over 5 months ago). There’s a bunch of old spam that I did delete back before I had moderation turned on, so the total amount of spam is actually higher. But ~500 spam entries a month seems about right. *sigh*
