taking out the trash
As “beltzner laments”:http://www.beltzner.ca/ifeelafel/archives/000451.html, comment spam is making the feared transition from annoyance to full-fledged scourge.
In response, I just added the “CloseComments”:http://thought-mesh.net/MTCloseComments.html plugin to bitchcake’s MT installation, after discovering that all the comments that went in more than 14 days after the post were spam. By happy happenstance, the converse is also true: spam comments come in uniformly to posts that are more than two weeks old, likely due to the orbital rate of various search engine crawlers.
After that, I worked around the “MySQL 3 limitation on multi-table delete”:http://www.mysql.com/doc/en/Rewriting_subqueries.html to remove the pre-existing comment-turds, and now I have a shiny diary again.