Several things done tonight;
- Removed about 1 million spams from comments and trackback. Quite literally. Database was getting sluggish, and I’m sure the scripts I was running made it worse for about an hour. It’s running a lot faster now, however. Obviously, I found a new tool for the task and it works pretty well. I’ll write a post about it later, for the WP crowd. What amazes me, however, is the amount of Spam this place has collected. I’m not kidding about the 1 million figure. Most users never see it, because the system is really good about marking stuff that’s spam, as such and putting it where it can’t be seen. Trouble is, the database gets clogged with that garbage, and kills the performance. They’re all gone now, and the DB queries are flying. Nice to see.
- Updated a few plugins that needed it.
- Did some scanning for exploits in the DB. We lok OK, I guess.
- Touched up a couple issues with some of the graphics. Mostly, you’ll never notice them unless you’re running something funky for a browser. It was on my list, though.
- Touched up the RSS feeds.
- Upgraded to WordPress 2.6.3. Mostly Squishing bugs, and a weak vul or two removed in this release. Nothing major. The biggie is 2.7.
By the way, the domain and server renewals are about due. I’m considering moving off the Windows server to a Linux box, so this may cause some downtime while they move us. I’ll let you know when/if, but it’ll be the leading part of November… after the election… if it does happen.