Database Optimization

Overview

The Database Optimization feature in Super Page Cache allows you to automatically or manually clean up unnecessary data from your WordPress database, improving performance and reducing overhead. You can activate the feature, execute cleanups manually, or schedule them to run at regular intervals.

How to Enable Database Optimization

1. Navigate to Super Page Cache → Settings → Database Optimization.
2. Toggle the Enable Database Optimization option to Yes.
3. Configure the available cleanup operations based on your preferences.

Once enabled, you’ll be able to perform the following optimizations either manually (using the Clean Now button) or on a scheduled basis.

Available Optimization Options

Each cleanup option includes:

• A manual trigger (Clean Now or Optimize Now)
• A schedule (choose Never or a predefined interval like Daily/Weekly/Monthly)

1. Post Revisions Cleanup

• Description: Deletes all post revisions (pages, posts, and custom post types).

  Why: Reduces database bloat caused by WordPress auto-saving content versions.

2. Auto-Draft Cleanup

• Description: Removes automatically generated drafts that are no longer needed.

  Why: Clears stale data created when editing new posts/pages.

3. Trashed Posts Cleanup

• Description: Permanently deletes posts, pages, and custom types in the trash.

  Why: Frees up space by removing deleted content from the database.

4. Spam Comments Cleanup

• Description: Deletes comments flagged as spam (manually or by anti-spam plugins).

  Why: Prevents spam data from accumulating in your database.

5. Trashed Comments Cleanup

• Description: Permanently removes trashed comments from the database.

  Why: Ensures your site is not storing unnecessary deleted comments.

6. Transients Data Cleanup

• Description: Deletes all stored transients (temporary cached data).

  Why: Useful for resetting expired or unused transients and reclaiming storage.

7. Database Tables Optimization

• Description: Runs the SQL OPTIMIZE TABLE command on all database tables.

  Why: Helps defragment tables and reclaim unused space, improving query performance.

Scheduling Cleanup Tasks

Each cleanup task supports a scheduling option. You can choose:

• Never (default – only runs on manual trigger)
• Daily / Weekly / Monthly (available depending on plugin version)

Scheduled tasks run automatically based on your configuration and require no manual intervention.

Benefits of Regular Database Optimization

• Faster database queries and reduced latency
• Smaller database size and backups
• Better overall site performance, especially on high-traffic websites
• Cleaner WordPress admin interface

Congratulations! You've successfully optimized your site's database with the help of Super Page Cache.