Skip to content
OptiWave | Doc
OptiWave · Database
Back to Website
Home / Database Cleanup
Infrastructure

Database Cleanup

Review old data, choose what to remove, and schedule cleanup only after checking the results.

Reviewed

Back up before deleting data

Open OptiWave → Database. Cleanup categories are off by default, and automatic cleanup is disabled. Review the counts and make a database backup before running a cleanup.

Deletion is permanent. OptiWave cannot restore deleted revisions, posts, or comments. Restore from your backup if you remove data you still need.

Choose what to clean

CategoryWhat it removes or changes
RevisionsPrevious saved versions of posts. You lose the ability to restore those versions.
Auto DraftsAutomatically created draft records; review ongoing editorial work first.
Trashed PostsPosts already in the trash, permanently.
Spam CommentsComments marked as spam, permanently.
Trashed CommentsComments already in the trash, permanently.
Expired TransientsTemporary stored values whose expiry has passed.
All TransientsTemporary values, including unexpired ones. Plugins may need to rebuild them.
Optimize TablesAsks the database to optimize supported tables; behavior depends on its engine.

Run a manual cleanup first

Select only the categories you have reviewed, let the settings save, and choose Optimize Database Now. Start with expired transients rather than clearing all temporary values unnecessarily.

Check the result, then visit important pages and open the editor. Deleting old data can reclaim space; it does not guarantee faster queries on every site.

Schedule only the cleanup you need

Schedule Frequency offers Disabled, Daily, Weekly, or Monthly. The saved cleanup categories are used for scheduled work, so review them before enabling a schedule.

Use a quieter period for larger cleanups, maintain regular backups, and make sure WordPress cron runs reliably. Leave the schedule disabled if you prefer to review each cleanup manually.

See the database screen
OptiWave Database tab showing cleanup categories and scheduled cleanup options
Database screen reference. Labels may differ in your installed release.