Your website’s CSS and Javascript aren’t the only things you should consider optimizing with the LSCache for WordPress plugin. You should also use its Database optimization features to improve the response time of database queries and more.
In this Knowledge Base article, we will cover how to use the database optimization settings in the LSCache for the WordPress plugin.
Let’s begin!
How to Configure the LiteSpeed Cache Database Optimization Settings in WordPress
Step 1: Login to your /wp-admin and hover over the LiteSpeed Cache area in the menu on the left and when the little menu pops out, click Database.
Step 2: When the Database Optimization page loads, you’ll have a few options, like the ones below:
Let’s explore what each of these options does:
- Clean All performs all of the optimizations listed alongside the Clean All button.
- Post Revisions deletes all post revisions in your WordPress site.
- Auto Drafts deletes all auto-saved drafts from your WordPress site.
- Trashed posts delete all trashed posts and pages from your WordPress site.
- Spam Comments deletes all comments marked as spam from your WordPress site.
- Trashed Comments deletes all trashed comments from your WordPress site.
- Trackpacks/Pingbacks delete all trackbacks and pingbacks from your WordPress site.
- Expired Transients deletes all transient options from your WordPress site.
- All transients delete all transients from your WordPress site.
- Optimize Tables is super helpful and you should run this maybe once or twice a month, depending on how frequently you add content to your website. This optimizes the tables in your database and makes them more readable to WordPress.
Next let’s look at the Database Table Engine Converter, which is below the 10 buttons at the top of the Database page:
If you don’t see any databases here to convert, then there’s really nothing to do here.
What would appear here are databases that are listed in the MySQL MyISAM format which is much slower than the newer InnoDB format. You would be given the option to convert them to InnoDB from within the WordPress Admin area, which is SUPER handy, let me tell you!
Are you tired of slow WordPress hosting? We use LiteSpeed caching to deliver content to your visitors almost instantly. ⚡ Check out our WordPress Hosting plans
Next, let’s look at the Database Summary area at the bottom of the page:
The most important thing you want to keep an eye on in Database Summary, and by keeping an eye on, we mean just periodically checking in on, is the autoloads.
You should try to keep the total autoloads below 1 MB, but the best is when it’s below 500 KB.
Step 3: Return to the top of the page and click the DB Optimizations tab.
- For Revisions Max Number, you can set a limit if you find your database is too big and you have too many revisions. For my site, I leave this at 20, but I tend to revise my posts a lot as a perfectionist.
- Revisions Max Age is an interesting feature that I don’t use as sometimes one of your posts can have an issue in a revision and by the time you get to it, the revision has been cleared out by the system.
Using the Database Optimization options in the LSCache plugin for WordPress will surely keep your website running smooth and keep your database clean.
We hope you enjoyed this Knowledge Base article. If you have any questions, be sure to open a ticket or Live Chat from your Client Area and we’ll be happy to help!
▶️ Please join us in the next tutorial, where we will walk you through the configuration of the LiteSpeed Cache Page Optimization Settings in WordPress