# Cleaning a WordPress database with the Advanced Database Cleaner plugin

> Remove old revisions, spam comments and orphaned data from your WordPress database with the Advanced Database Cleaner plugin.

Source: https://helpcenter.ruachost.com/wordpress/guides/cleaning-a-wordpress-database-with-the-advanced-database-cleaner/

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.
