When your WordPress site gets bigger, your database can get full of old post revisions, drafts, spam comments, and other temporary data. This extra information can make your site run more slowly. Regularly optimizing your database keeps it running at its best.
The LiteSpeed Cache plugin comes with the LiteSpeed Database Optimizer, which is a simple and useful tool for this.
Before you optimize the database, make sure to back up your site. This ensures you can restore it if something goes wrong.
Go to LiteSpeed Cache > Manage in your WordPress dashboard.
Select the DB Optimizer tab.
Blue checkmarks mean it’s already clean.
Red crosses mean that it needs to be improved.
Clean All—Cleans most things at once, except for Optimize Tables and Clean CSS/JS Optimizer.
Post Revisions—Deletes all but the most recent post revisions.
Auto Drafts—Stops WordPress from automatically saving drafts.
Trashed Posts and Comments – Permanently deletes items in the Trash.
Spam Comments—Deletes spam comments permanently.
Trackbacks and Pingbacks—Deletes old trackbacks and pingbacks.
Expired Transients—Deletes temporary data no longer needed.
All Transients—Clears all transients, whether expired or still active.
Optimize Tables—Optimizes database tables (not part of Clean All).
Clean CSS/JS Optimizer—Cleans minified and combined CSS/JS files if you use these features.
If you’re not sure about an option, contact the Cyberin support team. We’re happy to help!