WP-Optimize Plugin – Optimize Database Tables in WordPress

If you are running a self hosted WordPress blog, you should care about WP SEO, WordPress Security as well as blog’s health. You can care about it’s SEO using installing essential SEO plugins. You can maintain it’s security using security plugins for WordPress. When matter comes about blog’s health, you should really care about it. WordPress uses MySQL to create tables and database to store data. If you don’t know, it would create auto post revision when you create any post. It would help you to recover previous version of your post easily. Your WordPress auto draft post would be also saved in database tables there.

Time to time, you should Clear WordPress Database Tables or optimize it to keep your blog healthy. Here is the quick tip that would help you to optimize your blog’s database tables.

WP-Optimize Plugin for WordPress is the best WordPress plugin to Optimize SQL Database tables. We have to use plugins for WordPress, since it’s database would not clear automatically.

Database Optimization Options :

When you download and install WP-Optimize WordPress plugin, you would see WP-Optimize options on your WordPress Dashboard. You can schedule automatic database cleaning on WP-Optimize Plugin if you want.

Recommended options are checked by me on the above setting. As I discussed earlier, when you write any post, it would create post reversion and it is stored. There are also auto draft posts that would occupy unnecessary space on your database. There is great option that would clean all spam comments from your WordPress blog with one click. You just have to check that option Remove spam comments (This will also clear out comments in Trash). That would clear all comments from your spam box and trash box on your WordPress blog.

Pingbacks and trackbacks can be directly disabled from WordPress dashboard > Setting > Discussion Settings. If you have enabled them from there, you can directly optimize them from WP- Optimize WordPress plugin setting. Last option is optimize database tables, that is important and optimize all tables from your WordPress MySQL Database automatically.

When you press process button, all checked options would be automatically set and optimize your database tables of your WP blog.After optimizing it, you would see Database Table Optimization results and it would show how much space saved.

There is also auto cleanup function, if you enable it, it would automatically optimize your database tables on mentioned time.You can set it on every week or every month. 

You just have to schedule automatic cleaning and it would Remove revisions, auto drafts, posts/comments in trash, transient options. After that it will optimize the db.You can also optimize your database tables on your WordPress blog manually from phpmyadmin but it would be little difficult. if you use such database optimizer WordPress plugin it would be more simple than expected.