ShoutMeLoud – Shouters Who Inspire

≡ Menu

Wp-Optimize Plugin: Optimize WordPress Database with Single Click

Wp-Optimize Plugin: Optimize WordPress Database with Single Click

WordPress database optimization is one one of the essential task to keep your WordPress blog healthy. WordPress uses MySQL to create tables and database to store data. With time, you end up adding many redundant table data, database overhead in your database, and you should keep removing them to keep your database healthy. Along with this, WordPress features like post revisions, auto-draft also adds more into database size, and you should empty all such tables to keep your database size low.

For post revisions there are many plugins out there to limit the number of post revisions, but if you are not running a busy blog, instead of limiting post revisions, you can use plugin like Wp-optimize once in a month to delete post revisions.

One of the major reason for slowness of your WordPress blog is huge database, and it’s highly recommended to keep optimizing your blog database once in a while. Earlier, I have talked about Wp-Dbmanager plugin which not only optimize database, but also helps in automating database backup. Wp-Optimize is one of the simplest plugin, which will help you to perform following tasks:

  • Check your database size
  • Delete post revisions
  • Remove all auto-draft posts
  • Clean marked spammed comments
  • Clean unapproved comments
  • Optimize Database tables

You can choose to use all the features, or you can simply select any few of them and process it. Here is a quick tutorial for newbies to understand how to put Wp-optimize plugin to work.

How to use Wp-Optimize to Optimize WordPress database:

Download and install Wp-Optimize WordPress plugin. (Learn how to install WordPress plugin). Once you have activated the plugin, in your WordPress dashboard  left bar, you can see Wp-optimize settings link. Click on the link and you will be on Wp-Optimize page like this, where you can make do all the above mentioned tasks.

Wp-optimize WordPress Plugin

I just used this plugin before writing about it so there is no post revisions. I will quickly explain all the features, and you can select anyone want to use.

  • Post revisions: When ever you save a post, WordPress keep a revision of old post by default, so that you can restore to older saved version anytime. If you have edited, and saved a post 100 times. You have created 100 copy of same post in your database. Post revision is a useful feature of WordPress, but in longer run it makes your WordPress database bulky. It’s a good idea to delete all posts revisions once in a while from your database.
  • Remove all auto-draft posts: Similar to post revisions, WordPress auto-draft is a useful feature, which saves your posts while writing after certain time. Again, this increases your database size in longer run, and emptying all auto-draft posts after regular interval is a good idea.
  • Clean marked spam comments: If you are using Akismet or any other anti-spam comment plugin, you might be seeing lots of spam comments in spam comment folder. This option will let you delete all spam comments with one click.
  • Clean unapproved comment: This option will let you delete all unapproved comment with one click.
  • Optimize Database tables: It’s always a good idea to optimize WordPress database at regular interval to keep your database size at minimum.

When ever you go to Wp-Optimize settings page, you can see if your table needs to be optimize or not. Here is a screenshot of my WordPress blog database, which needs optimisation:

optimize WordPress database

All you need to do is, select the features which you want to use and click on “Process”, and Wp-optimize will do the rest for you. If you have never optimize WordPresss database before, this is a good time to do it. Make sure to take datbase backup before you use any new plugin. I also, recommend you to check out clean-options WordPress plugin, which will help you to remove orphaned database tables.

Let me know, which plugin are you using to optimize database table of your WordPress blog?

Print Friendly
  • Author Bio

  • Latest Post

Article by Harsh Agrawal

Harsh has written 1047 articles.

If you like This post, you can follow ShoutMeLoud on Twitter. Subscribe to ShoutMeLoud feed via RSS or EMAIL to receive instant updates.

{ 9 comments… add one }

  • Naren P

    I’ve been using so many database optimization plugin but wp-optimize does the job well and also increase my site loading speed. With this plugin it’s easy to delete all bulk spam comments with one single click. Thanks for the insight about this plugin harsh

  • Naren P

    Hello Harsh. So far i’ve used so many plugins to optimize my wordpress database. But WP-optimize does the well and also speed up my site speed in between. Must have plugin for every wordpress site. Thanks for the tutorial

  • John

    Thanks Harsh it was very useful info for me.
    And after all u listened to my request.
    You are really one of the best bloggers of the world.

  • Sukhraj Singh

    Hi Bro
    whenever i install this plugin my site starts showing memory outage errors. What to do

    • Harsh Agrawal

      Which version of WordPress are you using? You might like to try disabling existing plugins once, and try installing it. It may happen at times due to lack of memory (low memory on your hosting)…Or plugin incompatibility with any existing plugin.

      • sukhraj

        Using wp 3.4. Yep i disabled all plugins and than activated wp optimize. Its working now. Thanks

  • Dean Saliba

    I have been using this tool for the past six months and I have definitely noticed how much faster my admin panel is after running it a couple of times a months. Am I running it too often though? Will it damage anything if I run it twice a month?

  • Rahul

    The plugin will really help and the bloggers will be able to reach good techniques easily.

  • Shovan Saha

    Thank you Harsh for sharing this. Looks like I am going to use this plugin for my blog.


Leave a Comment