July 04, 2005

Yeesh, check out these spam stats

After fixing the Blacklist, the first order of business was to clean out all the spam that accumulated over the weekend.

Total number of URLs added to the list: 4
Number of comments deleted: 658
Number of pings deleted: 123

The real problem was actually just a single URL, which represented 639 of the comments and all of the pings.

And I'd like to go on record as saying that mass-deleting that much spam all at one time is not fun. The system can only reliably handle 100 "delete-and-rebuild" functions at a time I've found, so I have to search-and-destroy all that stuff in bunches of 100. It took 15 passes, averaging about 40 seconds each time, but I finally got it all.

What an excellent way to spend the Fourth of July!</sarcasm>

Posted by Eric at July 4, 2005 11:04 AM
Comments

Thanks a bunch, man. This crap really annoys me.

Posted by: nemo at July 4, 2005 11:07 AM

Ditto. Thanks.

Posted by: Kelly at July 4, 2005 05:11 PM