// post · 658

3 Million Comments

author: Michael Dale ·

I've noticed that the web server has been running slowly today.


Anyway I think I've found the problem. One of my old blogs sites is currently being spammed. Currently there are 3.3 million comments in the database!


Blog Spam.


EDIT: Problem fixed:


mysql> delete from comments WHERE id > 556;

Query OK, 3305122 rows affected (2 min 21.45 sec)


EDIT2: The spam has been coming from caravan.ru a Russian ISP (who's logo is very similar to optus' old one...).

// comments

· Josh guest
You really should disable commenting, migrate old posts across to Bluetrait, install Akismet, or put a robots.txt in barring that whole directory from being indexed (AND put a rel="nofollow" onto your link in this post) to stop giving any beneficial SEO love to the comments and/or tarring your own website with their dirty brushes of spammy spamness... just sayin' :)
#1 Comment Link

// leave a comment

> click for comments help

HTML allowed: <a href="" title="" rel=""></a> <b></b> <blockquote cite=""></blockquote> <em></em> <i></i> <strike></strike> <strong></strong> <li></li> <ol></ol> <ul></ul>
ie: <b>bold</b>

Your comment may need to be reviewed before it is published.