Optimize your WordPress Database Using RVG Optimize Database Plugin

    Aparna Gawade
Listen to this article
Optimize Your Database

For your WordPress site, every trashed comment, post, draft, has to be deleted permanently. Otherwise it still remains in the database. Apart from these, multiple post revisions, spam comments, etc are nothing more than just clutter which take up database space. Freeing your database of unwanted information is a guaranteed aid to make your WordPress site load faster.

In a previous article, we had mentioned how to clean up and optimize your WordPress Database manually. But to save time and do the optimization without any mistakes a novice user might commit, you could always use a plugin. The simplest way to optimize your WordPress database is by using the Optimize Database after Deleting Revisions Plugin.


The Optimize Database after Deleting Revisions Plugin

  1. Remove Unwanted Data: The plugin scans the entire database and removes data that is unused and unimportant data. There are options provided to select the data you want to remove. These include old post revisions, spam items, trashed items, unused tags, etc.

  2. The plugin also optimizes database tables: You can exclude certain tables, you do not want to affect.

  3. Schedule the optimization process: Lastly, you can schedule optimization on an hourly, daily or weekly basis.


How to use the Optimize Database after Deleting Revisions Plugin

Important Note: Remember to backup your database before using the plugin.

The plugin installs like any other WordPress plugins. Once activated, the plugin settings are available under Optimize DB Options in the Settings menu of your Dashboard.

Deleting Unwanted Data

RVG Optimize Database Options
RVG: Optimize Database Options
  • There are several options available to select the data you want to delete permanently. We recommend selecting every option, this includes deleting trash items, spam items, unused tags and expired transients. You can also select to keep a log file of the optimization process.
  • For Post revisions, you can select to keep 1, which will delete all other post revisions, except the most recent one. If you want to delete all, you can keep it as 0.
  • The scheduler option enables us to schedule the optimization automatically at a timely basis. If you have a website where a lot of content is being added frequently, you can use the scheduler at a weekly basis. Else you can manually use the optimization option as and when needed.
  • There is also an additional option that provides a ‘Optimize DB (1-click)’ link in the admin bar, which is a shortcut available for the site administrator, to optimize the database.

Optimizing Database Tables

The plugin optimizes database tables too. But you can exclude tables from the list, by selecting them from the tables list provided in the settings page.

RGV Optimize Database Tables
RGV: Optimize Database Tables

Once your done with selecting the options, remember to save your settings before you continue.

Optimize your Database

Once you’re done with the settings, you can move on to optimizing your WordPress database. This option is available under Tool-> Optimize Database menu in your Dashboard. Once the database is optimized, you are presented with a detailed report of the optimization process. So go ahead and use the plugin for a lighter WordPress website. You’ll surely save a lot website maintenance time.

Aparna Gawade

Aparna Gawade

Leave a Reply

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

Get The Latest Updates

Subscribe to our Newsletter

A key to unlock the world of open-source. We promise not to spam your inbox.

Suggested Reads

Join our 55,000+ Subscribers

    The Wisdm Digest delivers all the latest news, and resources from the world of open-source businesses to your inbox.

    Suggested Reads