How to optimize Wordpress database

There are multiple ways to optimize Wordpress database. If you are a database developer, or an administrator or atleast have some knowledge on database then it will be helpful, but what if you are like me with no knowledge on database but interested in doing atleast the basic optimization.

There is a plugin named WP-Optimize which is simple and easy to use. All that you need to do is search for this plugin and install it. You can use this tool to cleanup and optimize Wordpress database. Using this plugin you can remove post revisions, remove draft posts which are saved automatically, clean comments which are marked as spams or any unapproved comments.

All unapproved comments, spam comments, auto draft posts, post revisions will consume database space. You can optimize database by removing all these using this plugin. Also, this plugin can apply optimized MySQL commands on your Wordpress database without phpMyAdmin; which means this plugin doesn't require phpMyAdmin to optimize database tables. This is a very easy to use plugin and hardly takes few seconds to optimize database. Give it a try if you are using Wordpress.