My blog software, Serendipity (yes, there is something else out there besides WordPress), released a new update. After waiting a few weeks to let all the bugs get found and now that the first maintenance release is out, I thought I would take the plunge and perform the upgrade.
I’m pretty bad about doing regular backups, but before a version change, I always do them. It turns out the database for this little blog had swelled from 7MB back in August to nearly 50MB. Something was definitely awry. I took a look in the file and found one table that had nearly 60,000 records. The spamblocklog table. Once I emptied that table the database was down to 4MB.
What a mess. This blog doesn’t get many hits…it’s not something I expect to given the content and my lack of marketing effort, but to find out that that much spam is hitting this little site is mind boggling. I can’t imagine the amount of crap major websites have to deal with. When I looked through the list, the majority of it was for pharmaceutical and pron sites. Good thing the spam filters work as well as they do. I occassionally get some spam comments I have to delete but they come in spurts then subside.
You have to give it to the spammers, they know how to try to get their message out there. Now if only I knew how to market my site as well, maybe I’d have more traffic
For now, I’ve turned off logging of the spam, but I’m thinking it might be interesting to see how much I get after posting a new entry, just to see. Maybe a post for another day.
I know I’m a bit late with this, but I just got back from Taos, NM where I had little access to the Interwebs, so I couldn’t post this on New Year’s Day.