I read on PLOA that Michael Carden briefly tried to open his blog for comments, only to find:
The WordPress UI balked at deleting 194,000 (okay, I ignored it for a while) comment spams. I had to dig in as admin and run a fun sql query on the database to delete all 47 meg of them.
I guess I’ve got a couple of suggestions for Michael to make his life a little easier should he decide to try again.
- Akismet has an option to “
Automatically discard spam comments older than a month“, that might help (though it’d be nice to be able to adjust the time).
- Run, do not walk, to Rich Boakes most excellent Worst Offenders plugin. This will both group comments for deletion based on various criteria but also (if you have permission) add Apache “
Deny From” rules for the offending IP addresses. It’s also worth bumping the number of IP addresses it can ban up, Donna’s blog is up to over 8,000 at the moment!
- There are also tools like Bad Behaviour to try and catch bots before they get to you and if you are a member of Project Honeypot then there is the http:BL WordPress Plugin to check and block IP’s listed as baddies there.
Anyway, I hope that helps some people out.