WordPress makes it so easy to bring your site online. But you need to spend time to optimize your database and maintain your website. You can always maintain your database manually. Optimize Database after Deleting Revisions happens to be a handy plugin that makes the process easier. It deletes trashed posts, unused tags, and everything else to optimize your database.
The plugin is pretty simple to use. You can pick and choose what you want to delete. You can delete redundant revisions, trash, spammed comments, unused tags, orphan postmeta items, and more. The plugin gives you the option to schedule the script to run on an hourly, daily, or a weekly basis. Want to a create a log file of the optimizations? The plugin has you covered. You can try the plugin for free.