WP-Optimize Plugin: How To Use It (Complete Settings)

WPOptimize Guide
  • Save

WordPress database optimization is one of the essential tasks of keeping your WordPress blog speedy & healthy.

WordPress uses MySQL to create tables and databases to store data. Over time, you end up adding many redundant tables and databases. In order to keep your blog running smoothly, you need to remove all of these unnecessary things in a process called “database optimization.”

Along with this, WordPress features like post revisions and auto-saved drafts also add more weight to the overall database and need to be removed.

For post revisions, there are plugins that will let you limit the number of post revisions, but if you are not running a busy blog, instead of limiting post revisions, you can just clean up your blog once a month.

One of the major reasons for a slow WordPress blog is a huge database.

It’s highly recommended to keep optimizing your blog’s database once in a while.

Earlier, I have talked about the WP-DB Manager plugin which will not only optimize your database but will also help in automating database backups.

WP-Optimize is one of the simplest plugins, which will help you to perform the following tasks:

  • Check your database size.
  • Delete post revisions.
  • Remove all auto-saved draft posts.
  • Clean spam comments.
  • Clean unapproved comments.
  • Optimize database tables.

You can choose to use all of these features, or you can simply select a few of them.

Here is a quick tutorial to understand how to use the WP-Optimize plugin.

Also read: How To Optimize WordPress Database With Advanced Database Cleaner Plugin

How To Use WP-Optimize: Settings & Usage Guide

Download and install the WP-Optimize WordPress plugin. (How to add plugins to WordPress.)

Once you have activated the plugin, on your WordPress dashboard’s left bar, click on the WP-Optimize settings button.

You will now be on the WP-Optimize page where you can do all of the above-mentioned tasks.

WP optimize Plugin Settings
  • Save

(Ignore the numbers in the screenshot as I just used the plugin before writing about it, so my DB is pretty clean…)

Here are the features:

  • Clean all post revisions: Whenever you save a post, WordPress keeps a revision of the old post by default so that you can restore to an older saved version anytime. If you have edited and saved a post 100 times, you have created 100 copies of that same post in your database. This is a useful feature of WordPress, but over a long period, your WordPress database becomes bulky. It’s a good idea to delete all posts revisions once in a while from your database.
  • Clean all auto draft posts and posts in the trash: Similar to post revisions, WordPress’s auto-save drafts is a useful feature. It saves your posts while writing them in case your browser crashes midway through a post. Again, while useful, this increases your database size by a lot over time and emptying all of these auto-saved posts after a regular interval is a good idea.
  • Remove spam comments and comments in the trash: If you are using Akismet or any other anti-spam comment plugin, you might be seeing lots of spam comments in the spam comment folder. This option will let you delete all of these spam comments with one click. It will also delete any comments that are in the “Trash” folder.
  • Remove unapproved comments: This option will let you delete all unapproved comments with one click.

No go over to “Actions” and click on:

  • Optimize database tables: It’s always a good idea to optimize your WordPress database at regular intervals to keep your database size at a minimum.

Whenever you go to the WP-Optimize settings page, you can see if your table needs to be optimized or not.

Here is a screenshot of my WordPress blog database which needs optimization:

optimize WordPress database
  • Save

All you need to do is select the features which you want to use and click on “Process.”

If you have never optimized your WordPresss database before, this is a good time to do it.

Important: Make sure to take a database backup before you use any new plugin.

For more on databases, check out:

Let me know, which plugin are you using to optimize the database table of your WordPress blog? Share your suggestions in the comments below!

Don’t forget to share this post!

Was this helpful?

Thanks for your feedback!
  • Save
Authored By
A Blogger, Author and a speaker! Harsh Agrawal is recognized as a leader in digital marketing and FinTech space. Fountainhead of ShoutMeLoud, and a Speaker at ASW, Hero Mindmine, Inorbit, IBM, India blockchain summit. Also, an award-winning blogger.

17 thoughts on “WP-Optimize Plugin: How To Use It (Complete Settings)”

  1. Ruhani Rabin

    Thanks for featuring this Harsh 🙂 I am glad it is getting better at helping others.

    1. @Ruhani
      Good work with the plugin. Are you still maintaining and updating it?
      Looking forward to see more features in the days to come.

      1. Ruhani

        Currently the development has been transferred to UpdraftPlus team, I am confident they have done a great job (and will continuously improve it). I am still part of it as consultant of ideas.

  2. Duncan

    Wow! This is a timely post, for I realized my blog had pages with issues to do with optimization. I was not sure which plugin to use and information online bombarding from left to right about the best optimization plugin, I will definitely try working on this. Awesome one.

  3. Saud Khan

    I prefer wp-sweep over wp-optimize because it’s coded by a senior wp developer Chan and it uses proper wp delete functions instead of direct queries.

  4. Sakshi

    Any recommendations on DB optimization when using InnoDB tables?

  5. Graham

    Hi Harsh

    Like everyone else I’d like to thank you for your helpful blog. Just on thing, in Optimizer you didn’t mention “Remove Transient Option”, as I have 1700 of them I wondered about their significance?



  6. 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

  7. 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

  8. 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.

  9. Sukhraj Singh

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

    1. 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.

      1. sukhraj

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

  10. 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?

  11. Rahul

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

  12. Shovan Saha

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

Leave a Comment

Your email address will not be published. Required fields are marked *

Scroll to Top