Let’s take a look at one of the easiest ways to clean up and optimize your WordPress database.
Although there are quite a few plugins available for this, we’re going to use the WP Clean Up plugin. From your blog dashboard, go to “Add New Plugin” and search for WP Clean Up.
After you’ve installed and activated the plugin, you’ll find it’s settings under your Settings menu.
This is where all of the magic happens. You’ll be able to see the types of data that can be deleted from your database: revisions, drafts, auto drafts, moderated comments, spam comments, trash comments.
Go through each one and delete the items that you want to get rid of. Alternately, you can just use the “Delete All” button.
Below that you can see each table in your database and how much space it’s taking up. Click on the “Optimize” button below it to clean and optimize your tables.
Once completed, if there was any optimization that could be done then you’ll know from the total KB number – it will be smaller. You’ve just cleaned and optimized your WordPress database. Wasn’t that easy?
