Main Content

Cleaning up the database.

WordPressI never fully realized how bad WordPress’ database gets after a while. Plugins leave all sorts of junk behind and it’s just a huge mess. So I started deleting information. Hopefully I didn’t break anything.

This all started because my site got suspended yesterday for using to many server resources. I thought that was odd as I didn’t have a spike in traffic or any new posts. So I started looking for other possibilities.

When looking though the site I found that my subscribe to comments plugin (the original) was capturing thousands of spam emails. I had over 6000 and I think spammers were just attacking it.

So I got a new subscribe to comments plugin, one that was up-to-date and it helped me clean out the bad emails.

I then went into phpMyAdmin and stared poking around in there. Turns out there is all sorts of information from old plugins; such as Ultimate Tag Warrior. Remember that one?

I also found out that Akismet was saving all spam comments, or at least a lot of them. Nearly 3k there that I blew away.

I also dropped tables for plugins that I no longer used.

Plugin developers really have to write uninstall scripts as this is ridiculous.

Overall I feel my database is in better shape, however I’m not sure if I deleted anything important. If so, I have a backup.

This isn’t what I wanted to spend my evening and early morning hours on, but if it helps the server run better, then everyone wins.

Leave a Reply