Login »

Michael Dale

Search Posts

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

Click here if you are looking for Bluetrait, the weblog software.


Login

Username:

Password:

3 Million Comments

Posted by Michael Dale on Fri, 21 Mar 2008 9:25 PM

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...).