WpW: Database Optimization

September 20th, 2017 by LSCache 18 Comments

Welcome to another installment of WordPress Wednesday!

We’re on quite a roll lately, with all of the new functionality being introduced into our cache plugin. But don’t worry if you haven’t had a chance to figure it all out yet. That’s why I’m here! Today, allow me to be your guide through the new Cache Management screens, in particular the DB Optimizer tab.

From your WordPress Dashboard, navigate to LiteSpeed Cache > Manage. You’ll notice some shiny new icons and buttons, and you may also notice that the page has been split up into two tabs: Purge and DB Optimizer.


Before this latest update, when you navigated to the Manage menu item, you were brought to a single page of options. This page is what is now in the Purge tab. Updated graphics aside, you should recognize most of the functionality that is here.

The biggest difference from older versions is the Purge Error Pages button has been split up into individual buttons for each kind of error page.

Our wiki has more information about the Purge tab functions, if you are needing a refresher on anything.

DB Optimizer

This tab is brand new. While not, strictly-speaking, cache management, database optimization is a useful tool when it comes to speeding up your site. We’ve included it here because there’s nothing we love more than an accelerated internet! This is the first of many such “extras” we’ll be adding to the plugin.

Our DB Optimizer gives you an easy way to keep your WordPress database slim, trim, and as efficient and possible.

You’ll notice that some of the buttons have green check-marks while others have red X’s. The check marks indicate that the area has already been cleaned-up. If you see a red X, it is an indication that you have an opportunity to do some optimization.

A word of caution: as with most tools of this nature, it is a good idea to have a current backup of your database before you begin pressing buttons!

So let’s take a look at each of those buttons and see what they do.

Clean All

This button is for the site admin in a rush. It allows you to clean up everything at once by executing all of the other cleanup buttons with a single click.

NOTE: Optimize Database is different than the other buttons, so it’s not included in Clean All. Its functionality is explained in more detail below.

Post Revisions

When you edit an existing post, WordPress saves a copy of the original version, just in case you make a mistake and need to revert back. If you edit the post 8 times, you will have 8 revisions saved. That’s 8 full copies of the post, each just a little bit different than the others. This button removes all but the most recent revision from the database.

The Post Revisions button has the potential to free up a considerable amount of space, if you are prone to frequent edits. Just be aware that you will sacrifice your ability to ever restore old versions of posts. This is a sacrifice that most site owners can easily live with, though.

Auto Drafts

When you create or edit a post, WordPress automatically saves drafts now and then. This is to protect you in case you unexpectedly lose your connection, or your computer crashes. If you know that all of your posts are either published or saved correctly as drafts, then it is safe to press this button and remove the automatic drafts.

Trashed Posts

If you’ve put a post or page into the trash, then that’s a pretty good sign that you don’t need it anymore. Press this button to permanently empty that garbage can.

Spam Comments

There should be no need to keep comments that have been marked as spam. Press this button to erase them once and for all.

Trashed Comments

Trashed comments, too, take up space. Press this button to permanently delete them.

Trackbacks & Pingbacks

When other blogs link to you (or when you link back to other posts on your own blog), it can create trackbacks or pingbacks. These are stored as comments and can be seen in the Comments section of your WordPress Admin. Additionally, some themes display trackbacks and pingbacks in among the comments on a post. If keeping a record of these external (and internal) links is not important to you, press this button to clear them from the database.

Expired Transients

Transients are the result of a form of caching that can happen in the WordPress database with the results of remote API calls. This option clears all of the expired transients from the database.

All Transients

This option clears all of the transients in the database, whether expired or not.

Optimize Tables

This button is different than the others. It’s the cleanup after the cleanup, if you will. When you delete large amounts of information from your database, it leaves gaps. The Optimize Tables button reclaims that disk space and reorganizes the table indexes for better efficiency. It’s a useful last step once you’ve done all you care to with the other buttons.

Keeping your database clean and free of trash is a great way to keep your WordPress site running efficiently. We hope you’ll give the new DB Optimizer tab a try! Be sure to let us know if you have any questions, or any suggestions for future enhancements. We’d love to hear from you!

Be sure to meet us back here next week to talk about another new set of LSCWP features: Minification, Combination and HTTP/2 Push!

Have some of your own ideas for future WordPress Wednesday topics? Leave us a comment!

Don’t forget to meet us back here next week for the next installment. In the meantime, here are a few other things you can do:


Related Posts