Categories

Bluetrait
        Bluetrait
            Coding
            Geek
            General
            Coding
                PHP
                Bluetrait
                WordPress
                    Plugins
                PHP
                Bluetrait (Program)
            Geek
                Juniper
                Cisco
                IBM N2200 8363
                PCs
                Spam
                IPv6
                Apple
                NetScreen
                Internet
            General
                Uni

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!

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

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

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.

Message

Name

Email (not shown)

WWW (optional)

Allow contact form email

Remember details