First off, if you’re not regularly backing up your WordPress® database, go do it right now. Seriously. The words here will wait.
Backed up? Good. Ahem.
Now then, if you’re managing your own WordPress site, you definitely want and need to keep it cleaned up and in optimal form. Part of doing this is getting rid of the cruft that accumulates in your WordPress database. Spam comments and other digital detritus can cause your database to balloon in almost no time.
Just as you sometimes need to recharge to get your brain back in tip-top shape, so you need to clean out the junk that accumulates in your database over time, just from use.” ~ Luvvie Ajayi
Using a couple of tools like the WP-Cleanup plugin and some judicious tweaking of the database (again, careful!) with phpMyAdmin, Luvvie was able to get rid of tens of thousands of rows of data that were gumming up her database, and was able to shrink her database by about 70 percent. Your milage may vary, of course, but if you want to try it yourself, check out Luvvie’s post.
For more great tips, check out the GoDaddy Tool Kit on BlogHer.