Fri, 21 Mar 2008 9:25 PM
3 Million Comments
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!
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
On Fri, 02 May 2008 at 3:04 PM, Josh wrote
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