Comment moderation has kept my posts mostly free of comment spam lately, but the moderation queue and its many and frequent notification e-mails have grown overwhelming—sometimes dozens and even well over a hundred notification e-mails arrive at once—so I have disabled comments and pings until I can implement a better solution. I am not sure whether I will implement an existing WordPress plug-in, create my own, or spend some time implementing anti-spam measures in PageDrive then migrate to that.
By the way, WordPress 2.0 allows you to specify whether comments and pings will be allowed by default for all new posts and it allows you to specify those settings on a per-post basis, but I did not see a way to mass-modify them for existing posts, so instead of doing a lot of clicking through page after page of posts to uncheck their “Allow Comments” and “Allow Pings” boxes (under “Discussion”) and resave each post along the way, I employed the following SQL statement, which definitely saved me some time:
UPDATE `wp_posts` SET `comment_status` = ‘closed’, `ping_status` = ‘closed’;
Of course, you might want to back up your existing settings before you use that or anything like it, especially if you plan to reopen some comments or pings later, but not all of them.