Cleaning a WordPress Database with the Advanced Database Cleaner Plugin

Over time, your WordPress database accumulates unnecessary data such as old revisions, spam comments, trashed posts, and orphaned metadata. This clutter can slow down your site. On ruachost.com, you can use the Advanced Database Cleaner plugin to safely remove unused items and optimize performance.

Why Clean the Database?

• Reduces database size and improves site speed.
• Removes clutter like spam comments and orphaned data.
• Optimizes tables for better query performance.
• Helps maintain a healthy WordPress installation.

Steps to Install the Plugin

1. Log in to WordPress with an administrator account.
2. In the dashboard, go to Plugins → Add New.
3. Search for Advanced Database Cleaner.
4. Click Install Now, then Activate.

Running Advanced Database Cleaner

1. Back up your database before cleaning (recommended).

2. In the dashboard, go to WP DB Cleaner.

3. The plugin provides several tabs:

   • General Clean‑up → Select items like spam comments, trashed comments, orphaned options.
   • Tables → Optimize and repair database tables.
   • Options → Review unused WordPress settings.
   • Cron Jobs → Manage scheduled tasks.
   • Overview & Settings → See a summary of unused data.

4. Select the items you want to clean.

5. Click Apply → Continue to confirm.

6. The plugin will remove the selected data and optimize your database.

Important Notes

• Be cautious when cleaning Revisions or **Auto Drafts,**you may delete work in progress.
• Run the cleaner when no one else is logged in to WordPress.
• Always keep a backup in case you need to restore deleted data.