Categories

Bluetrait
        Bluetrait
                Bluetrait
                    Coding
                    Geek
                    General
                    Videos
                    Solar
                    Coding
                    Geek
                    General
                    Coding
                        PHP
                        Bluetrait
                        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