3 Million Comments
Posted by Michael Dale on Fri, 21 Mar 2008 9:25 PMI'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...).
1: Comment Link
Comments?
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.
0.0514 Seconds Powered by Bluetrait
2.12 MB 9 Queries
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' :)