So the experiment with running both Akismet and Bad Behavior 2 anti-spam systems with ExpressionEngine seems to be working out pretty well. Akismet is even managing to stop around 95% of those useless comment spams that consist of nothing but random characters that serve no purpose at all and on the ones that make it through I just close the comment and then use the Akismet module to mark it as spam and delete it which helps to cut down on how frequently those make it through in the future.
Bad Behavior doesn’t really outwardly show anything when it’s working, but it does keep a table in the database with all the comments/trackbacks that it has rejected. This makes for interesting browsing on occasion because it reveals just how much activity the spammers engage in. Consider these simple facts: The total size of the mySQL database that makes up not only SEB but the other 6 blogs I run for family members and such is around 78.7MB in size. The total current size of the Bad Behavior log table in the database is 13MB. The total size of the table that holds every single one of the 7,700 (counting this one) entries from every single blog is only 14.1MB.
Here’s the kicker: The Bad Behavior 2 system only keeps 7 days worth of activity so that’s 13MBs over 7 days making it the third largest table in the database.
What’s the first? The table that holds the 58,274 (combined) comments. That table is 42.4MBs. Damn, but you people are a chatty bunch.
Anyway I just thought that was somewhat amazing and seeing as it’s almost 3AM and I’m still awake for no good reason I thought I’d take a moment and share it with you.