Vital Link: Six of the Best WordPress Database Plugins

Posted on November 6, 2015 by in Resources | 15 comments

Vital Link: Six of the Best WordPress Database Plugins

Most people who own a car would never think twice about the importance of maintaining it. You know that regular oil changes, correct tire pressure and a full tank of gas are necessary to keep everything running smoothly and safely.

Your WordPress database is no different in that regular maintenance will keep it running more smoothly, faster and with fewer problems.

But what we know, and what we do are often two different things. The vast majority of WordPress users, rarely take the time to maintain their database. Relying instead on good luck and crossed fingers. You don’t want to be that person.

The good news is that maintaining your WordPress database is not as complicated as you might think. While you could choose to use phpMyAdmin, there are in fact a few plugin options available that can make maintaining your database much easier.

To help you get started, we’re going to cover some of the best WordPress Database Plugins – designed to make your life easier and your website faster.

Why Your WordPress Database Is So Important

As a WordPress user, you probably realize that your website is essentially made up of three components:

  1. The WordPress core files
  2. Your theme files
  3. Your mySQL database

The first two items, while essential, are easily repaired, replaced or reinstalled. Your database, on the other hand, can not be replaced. It’s unique to your website and the more information it contains, the more valuable it becomes.

Every single piece of content on your website is contained within your database. Post, pages, comments, meta information, users – you name it, it’s there. The easiest way to emphasize the importance of your database is to imagine how you’d feel if every page and post on your website disappeared in the blink of an eye. Bad news, right?

Limiting the number of revisions stored in your database plays a huge role in keeping everything organized and running at optimal speed. As well, over time, your database will accumulate what is called overhead. An excessive amount of overhead can slow down your website. Cleaning, or “optimizing” if we’re to use the correct term, is very similar to performing a defrag on your hard drive or emptying your trash bin.

While the focus of this post is covering some of the different database maintenance plugins, it should go without saying that regular backups are also vital. Even a fast car is useless if you crash it and don’t have insurance.

6 of the Best WordPress Database Plugins

Any plugins covered in this list were required to be compatible with the current version of WordPress (4.3). Searching through the plugin repository, you’ll find that quite a few options are not up to date or the support forums currently indicate unresolved bugs. I’ve done my best to filter out those options which should make your selection process much easier.

I’ve included different types of database plugins, not just maintenance, but also revision control plugins, and a few free database backup plugins.

Optimize Database After Deleting Revisions

optimize database after deleting revision

This plugin is billed as a simple “one-click” solution database cleaner and optimizer. Installing this plugin will add a single menu item under settings called “Optimize DB Options”. With about 30 seconds of setup time, this plugin will be ready to run on a manual or scheduled basis.

The customization options include the ability to set the maximum number of revisions for posts/pages as well as the ability to control the following:

  • Deleting all items currently sitting in the trash
  • Deleting all items currently sitting in spam
  • Deleting any unused tags
  • Deleting expired transients
  • Maintaining a log of all transactions
  • Selecting a schedule if you want to optimize automatically
  • You can choose to display a 1-click activation from within the top admin bar

There is also an option to select tables within your database that you don’t want to be optimized. If you request the plugin to keep a log, you’ll be able to view a complete list of everything that’s been deleted. Plus, you’ll see a summary of your optimization efforts in terms of the overall database size. This is an easy to use plugin capable of getting the job done with little fuss. At 60,000+ installs, it has a decent user base and an active support forum.


WP optimize

Although you can download WP-Optimize from the plugin repository, support is available via email or on Github. This is another database maintenance plugin that you can set to run automatically. It’s capable of performing the following actions:

  • Deleting all post revisions
  • Deleting all auto drafts as well as drafts that are moved to trash
  • Removing spam comments and comments moved to trash
  • Deleting any unapproved comments
  • Removing transient options
  • Removing pingbacks
  • Removing trackbacks
  • Optimize database tables

WP-Optimize also has an additional setting that allow you to retain a predetermined amount of data. For example, you might want to keep the last 2 weeks of data and only delete items older than that. There is also the ability to enable an admin bar link for easier access.

Auto clean-up settings can be set to a predetermined schedule and can also have different settings than the manual option. Finally, this plugin displays a list of all tables including the corresponding data – records, data size, index size and overhead.


WP Sweep WordPress Database Plugin

WP-Sweep is an option from well-known plugin author Lester Chan. It has over 10k+ active installs, a well-maintained support forum and plenty of positive reviews.

This plugin is unique in that you can easily “sweep” individual items or everything at once. The admin screen, located under settings, conveniently breaks down the maintenance tasks into six main categories including:

  • Post sweep
  • Comment Sweep
  • User Sweep
  • Term Sweep
  • Option Sweep
  • Database Sweep

Contained within each category are the individual items you would expect to find such as the ability to clean up revisions, drafts, deleted posts and orphaned items. One thing this particular plugin does not offer is the ability to automatically schedule tasks. That said, it’s probably the easiest plugin to use and it’s clear that functionality comes first.



As the second database management plugin in this list by Lester Chan, WP-DBManager offers some different functionality. Once installed this plugin creates its own menu in the dashboard called Database. Although this plugin offers different features, it’s also worth noting that you could actually do some damage to your database with this plugin. Use it with caution. Features included with this plugin are:

  • Optimize the database
  • Repair database tables
  • Backup the database
  • Delete the database backup
  • Restore the database

Unlike WP-Sweep, this plugin also allows you to schedule certain functions including backup, optimizing and repairing. One feature of this plugin that is particularly convenient is the ability to maintain multiple backup copies of your database. You can also download, restore or delete and specific copy with just 2-clicks.

There are two areas of this plugin that deserve caution. The first is the ability to empty or drop tables from the database and the second is being able to run SQL queries from within the plugin. Unless you’re familiar with either of these, it’s not a good idea to experiment on your live site.

Simple Revisions Delete

Simple revisions delete

There might be times when you wish that you could have revision control over specific posts or pages. Deleting only the revisions that you know you’re done with. Simple Revisions Delete is a plugin that provides this exact functionality. The plugin claims to be very light weight and is easy to use.

Following installation, you’ll find a link next to the default WordPress revision counter. Once clicked, it will delete all revisions for that specific post. As an added feature, when viewing a list of pages or posts, you’ll also be able to perform a bulk revision delete.

This particular plugin might not be an ideal option if you already have many posts or pages published, but for a fresh WordPress installation in which there are not too many different authors, it might be a convenient option.

UpdraftPlus Backup & Restoration


Although this plugin has the ability to perform a full backup, our attention is focused on its ability to backup your database. Both manual and automated database backups are easy to configure and this plugin can easily be integrated as part of your database maintenance program.

Uploading backups to a variety of third-party options is possible including Amazon S3, Dropbox, Google Drive, Microsoft Onedrive and Rackspace. Plus, your database can be encrypted from within the WordPress control panel. If anything ever goes wrong with your database, you can easily perform a one-click restore.

Wrap Up

There is no arguing the fact that your database is the most vital part of your WordPress website. Despite this fact, most people who run a WordPress site give little thought as to what might be going on in the background. Databases are a funny thing, nobody really thinks about them until there’s a problem and it’s too late.

If you are running a WordPress site, one of the best things you can do is implement a regular, scheduled database maintenance program. That includes cleaning and organizing as well as performing regular backups. Take care of your database, and it will take care of you.

Has anything ever gone wrong with the database of your WordPress website? Do you have suspicion that your database is slowing down your WordPress website? If you have a favorite plugin that you use to help maintain your database, please share in the comments below.

Article thumbnail image by Tarchyshnik Andrei /

Premade Layouts

Check Out These Related Posts

9 Non-Profit Child Themes for Divi

9 Non-Profit Child Themes for Divi

Posted on July 27, 2019 by in Resources

There are lots of nonprofit organizations across the globe. Just about every one of them needs a well-designed website to tell their story and receive donations to help their causes. Divi is an excellent theme for nonprofits such as charities. Fortunately, you don’t have to start from scratch for...

View Full Post
55 Web Design Blogs to Follow in 2019

55 Web Design Blogs to Follow in 2019

Posted on January 6, 2019 by in Resources

Inspiration comes in many forms and professional development never ends. With that in mind, we have put together a massive list of web design blogs that can keep your brain fed for the entire year. But don’t worry. You won’t find any duds on this list. We respect your time and feel like...

View Full Post


  1. Until my co-blogger friend told me to take regular backups, I was not taking it seriously.
    I’ve tried many many plugin and finally found Duplicator the best one.
    Recently I’ve noticed that duplicator is failing to take backup and giving an error. Is there any other good plugin I can use to take backup.

    • As mentioned here : UpdraftPlus free works well. Give it a try.

      • I use ‘Optimize database after deleting revisions’ and Updraft Plus Paid full version.

        Highly recommend Updraft Plus. I used the free version but immediately switched to the full service suite because of:

        1) Great support – like ET
        2) Additional features like cloning and migration are 1-click, especially helpful since I do my build on a staging environment then push to live site. Migrator feature does it all for me.
        3) With upgrade you get 1GB of cloud backup storage. Means if I lose my site – I don’t lose my BackUps cuz they are not on the hosting server. You can have more than one site storing to cloud space!

    • I use backupwp very usful one

    • Back Up Buddy is the best for back up of the database and posts. It is a little costly.

  2. Even updraft plus didn’t cut it. Blog Vault has saved my life last summer. They do two backups daily stored on their servers. Auto Restore works great. You can also download a copy to your hard drive. For $9 per month, a true bargain. Great support.

  3. Because I use BlogVault (highly recommended) I hadn’t considered using anything like this but now I think it’s a really good idea. Especially for the clean up/maintenance viewpoint.


  4. Thanks so much for this info Joe. I’m not a dev but am about to create my first WP website (have had some prev experience with WP so am ok for a beginner).

    My host does backups of my site & I use BackUp Buddy so I do a database backup weekly.

    What I don’t “get” is this…eg;
    Being a newbie I find I do lots of revisions as I design / write a page.
    I’ll be blogging a LOT once I’m up & running too (& same goes as above I expect).

    Do these revisions get stored in my DB each time I do a new “save”?

    Which plugin would you suggest for someone like me who’s learning on the job & needs to “save & see” after each revision – I’m a very visual person.

    I have another question too if you don’t mind.

    I’m confused about where its best to store images, videos (and PDF downloads I’d like to make available in a particular area of my site).
    By best I mean…

    1. To keep my site clean & as fast to load as possible
    2. To ensure best user experience & little or no friction
    3. For SEO purposes

    I have AWS but am still just learning about how to make the best use of it.

    Perhaps my questions will inspire you for a new post :))

    Thanks again for this one. You definitely flagged something important I need to address.

  5. I’ve been hearing a lot about UpdraftPlus lately – need to try it out. Thanks for the article!

  6. Thanks for the nifty tools. I’ve used WP DB Backup from the start. I didn’t have to be convinced of the value of backing up. What got my attention was the need for housekeeping in the database. I do this for our contact management database, but never considered all those numerous post revisions that still lurk in my database. Thanks for setting me up for an early Spring Cleaning.

  7. I was always afraid of deleting revisions of posts and pages. But since they are automatically deleted with such plugins, I can breathe normally now. And install one of these plugins.

  8. Hi

    what do the Plugin do, when they say they “optimize” or “repair” the DB?

    I understand that cleaning means deleting old stuff like post-reviews. But the other two?

  9. i am an ‘old’ IT developer (35+ years in the bizness) and i understand the importance of both keeping your database optimized, and backing up your work – i agree with your assessment and personally use wp-optimize and updraft plus (free version) – both of these meet my requirements 100% and i have never had any issues with them

    also, since i took the time to write, i want you to know i have been subscribing to this blog for a few months now, and it is one of the better, if not the best, wordpress blog out on the interweb – many thanks for all of your most excellent articles

    have a wonderful day (sorry not timely on this comment – just catching up on some emails)

  10. Thank you for the post. It came into my mailbox, just as I was thinking about site backup. This was perfectly written for a newbie like myself. Keep up the good work 🙂

  11. > Limiting the number of revisions stored in your database plays a huge role
    > in keeping everything organized and running at optimal speed.

    I would be surprised by that given that displaying posts and pages uses high cardinality or unique indexes. The number of post revisions can’t make any difference in the speed to retrieve a single one.

    I would draw your attention to this formula:

    log(row_count) / log(index_block_length / 3 * 2 / (index_length + data_pointer_length)) + 1.

    This is the method the number of seeks required to access a row in a MySQL database. If you use some values from a WordPress install you will discover that a post with a single revision and one with 20,000 revisions will require the same number of seeks to retrieve. In fact, I find an additional seek is required around 200,000 revisions. I would be surprised if any wordpress posts table numbered 200,000 rows in total.

Join To Download Today

Pin It on Pinterest