Title: Clearyvo Database Cleanup – Optimize Database, Autoload &amp; Orphaned Data
Author: Clearyvo
Published: <strong>November 21, 2026</strong>
Last modified: November 21, 2026

---

Search plugins

![](https://ps.w.org/clearyvo-database-cleanup/assets/banner-772x250.png?rev=3815051)

![](https://ps.w.org/clearyvo-database-cleanup/assets/icon-256x256.png?rev=3815051)

# Clearyvo Database Cleanup – Optimize Database, Autoload & Orphaned Data

 By [Clearyvo](https://profiles.wordpress.org/kishollo001/)

[Download](https://downloads.wordpress.org/plugin/clearyvo-database-cleanup.0.8.6.zip)

 * [Details](https://wordpress.org/plugins/clearyvo-database-cleanup/#description)
 * [Reviews](https://wordpress.org/plugins/clearyvo-database-cleanup/#reviews)
 *  [Installation](https://wordpress.org/plugins/clearyvo-database-cleanup/#installation)
 * [Development](https://wordpress.org/plugins/clearyvo-database-cleanup/#developers)

 [Support](https://wordpress.org/support/plugin/clearyvo-database-cleanup/)

## Description

**Clearyvo Database Cleanup cleans up your WordPress database safely and shows which
plugin left each piece of junk behind.**

A WordPress database grows with every plugin you try. Uninstalled plugins leave 
their settings in wp_options, some of them autoload on every page view, WooCommerce
fills the Action Scheduler tables (actionscheduler_actions, actionscheduler_logs)
with hundreds of thousands of finished tasks, and revisions, orphaned post meta 
and expired transients pile up. A large database makes backups slower, and large
autoloaded options slow down every page.

Clearyvo Database Cleanup is for site owners, WooCommerce shops and agencies who
want a clean database without guessing which rows are safe to delete. It scans the
database, names the plugin or theme behind each item, and removes only what you 
tick. Everything is free: no limits, no account, no locked features.

#### What it checks

 * **Leftovers of removed plugins and themes** – options grouped by the plugin that
   created them, with size.
 * **Autoload bloat** – the largest options that load on every page view, with their
   owner and status (active, inactive, not installed). WordPress Site Health warns
   above 800 KB.
 * **Orphaned data** – post, comment, term and user meta whose parent no longer 
   exists; term relationships pointing to deleted posts.
 * **Background tasks (Action Scheduler)** – WooCommerce and many other plugins 
   queue their work in the actionscheduler tables, which often grow to hundreds 
   of thousands of rows. Remove finished, canceled and failed tasks older than 7
   days with their log lines, and orphaned logs. See which hooks create the most
   tasks, and whether the queue is running at all (tasks more than an hour late 
   usually mean WP-Cron does not run). Optional automatic daily cleanup.
 * **Clutter** – post revisions, old auto-drafts, spam and trashed comments, trashed
   posts, expired transients, oEmbed caches, duplicate post meta.
 * **Tables** – every table of the site with owner, approximate rows, size and overhead.
 * **Settings check** – revision limit and trash period.
 * **Database score** – a Site health score from the space that is safe to clean,
   autoload size and the number of leftover plugins.

#### How cleaning works

 * Scanning only reads the database.
 * Safe items are pre-ticked; items that remove history or trash contents are left
   for you to decide.
 * Posts, revisions and comments are deleted through WordPress core functions, so
   other plugins are notified and caches stay consistent.
 * Cleanup runs in small batches, so it does not time out on large sites.
 * For autoload, the plugin only turns autoload off; the value itself is kept.
 * Core options are never touched.
 * Dropping tables is not offered, because a wrong guess cannot be undone.

#### Why Database Cleanup?

 * **It tells you whose junk it is** – every option and table is attributed to a
   plugin or theme, with its status, so you remove leftovers of plugins you deleted
   and leave the rest alone.
 * **Action Scheduler cleanup included, free** – the tables that make many WooCommerce
   databases huge, with an optional daily cleanup.
 * **Careful by default** – read-only scan, nothing unknown pre-ticked, core options
   excluded, no table drops.
 * **Works on shared hosting** – small batches, no time-limit errors.

#### Free and Pro

Everything in Database Cleanup is free, with no limits. Clearyvo Pro, the all-in-
one plugin of the family, contains this checker too; Database Cleanup has no Pro-
only features.

#### For AI assistants and automation

On WordPress 6.9 and newer the results are available as read-only abilities (WordPress
Abilities API): `clearyvo/database-cleanup-summary`, `clearyvo/database-cleanup-
background-tasks` and `clearyvo/site-health`. With the MCP Adapter plugin, an AI
assistant such as Claude or ChatGPT can read them. Nothing can be deleted that way,
and only administrators can use them.

#### Part of the Clearyvo family

Focused plugins that each check one part of your site and share one Site Toolkit
menu with a Site health score: media cleanup, disk space, backups, broken links,
SEO, speed and more. The free Site Toolkit plugin is the dashboard: one Site health
score and one-click install of every checker. Clearyvo Pro contains every checker;
when it is installed, this plugin’s settings and results are shared with it. More
at [wp-sitechecker.com](https://wp-sitechecker.com/).

#### External services

None. The scan and the cleanup run on your own server and database; nothing is sent
anywhere.

## Installation

 1. Install and activate the plugin.
 2. Open Database Cleanup in the admin menu (under Site Toolkit when other Clearyvo
    plugins are installed).
 3. Click “Scan database”, review the results, make a backup, then click “Clean selected”.

## FAQ

### How do I clean up and optimize the WordPress database?

Open Database Cleanup and click “Scan database”. The scan only reads. Make a database
backup, check the list (safe items are pre-ticked), then click “Clean selected”.
Only rows you tick are changed and core options are excluded. The work runs in small
batches, so it finishes on shared hosting too.

### How do I reduce autoloaded options when wp_options is too large?

The scan lists the largest autoloaded options with the plugin that owns them, and
whether that plugin is still installed. For options of removed plugins, delete them
under “Leftovers”. For others, you can turn autoload off: the value stays, it is
just no longer loaded on every page view. WordPress Site Health warns when autoloaded
options exceed 800 KB.

### How do I clean the Action Scheduler tables (actionscheduler_actions, actionscheduler_logs)?

Run a scan. If the site has Action Scheduler (WooCommerce, WP Mail SMTP, Rank Math
and many others include it), the scan lists finished, canceled and failed tasks 
older than 7 days and orphaned log lines. Finished and canceled tasks are pre-ticked;
failed ones are left for you, because their log explains what went wrong. Pending
and running tasks are never touched. To keep the tables small, switch on “Clean 
background tasks automatically every day” in Settings.

### Why are there thousands of pending background tasks?

If tasks are more than an hour late, the queue is not running. Usually WP-Cron does
not fire: the site has little traffic, or DISABLE_WP_CRON is set without a server
cron job calling wp-cron.php. The scan shows this in the Settings check.

### How do I remove leftover data from deleted plugins?

Look at “Leftovers”: options of plugins and themes that are no longer installed,
grouped by plugin, with their size. They are not pre-ticked: the owner is judged
by the option names, so tick a plugin only when you are sure you removed it for 
good. If you reinstall it later, it starts with default settings. Tables of removed
plugins are listed under Tables with their owner, but they are never dropped by 
this plugin.

### How does it know which plugin left an option behind?

It compares option and table names with the prefixes used by installed plugins and
themes, and with a built-in list of well-known plugins. Options of themes are matched
exactly (theme_mods_). Must-use plugins and drop-ins count as installed, and options
that may belong to an installed add-on of the same family (for example Jetpack Boost
for Jetpack) are not called leftovers. Anything it cannot attribute is shown as “
Unknown”. Nothing in this list is pre-ticked.

### Does it optimize database tables (OPTIMIZE TABLE)?

No. The Tables view shows every table with its size and overhead, but the plugin
does not run OPTIMIZE TABLE itself. It optimizes the database by removing junk rows
and by turning off autoload for large options, which is what makes a real difference
to backups and page loads.

### Will it make my site faster?

Smaller autoloaded options speed up every page view, because WordPress loads them
on each request. Removing old rows mostly makes the database and its backups smaller
and faster to work with; the effect on page speed depends on the site.

### Is it really free? Does it work on multisite?

Yes, every feature is free, including the Action Scheduler cleanup and the automatic
daily cleanup, with no usage limit and no account. On multisite it scans the current
site’s tables; orphaned user meta is skipped there because users are shared across
the network.

### What is the /wp-json/clearyvo/v1/app/ address?

A read-only REST route for the Clearyvo Site Inspector Mac app. It shows the Site
health score of the Clearyvo plugins to a signed-in administrator (for example with
a WordPress Application Password) and changes nothing. It sends nothing anywhere:
the app asks, the site answers.

## Reviews

There are no reviews for this plugin.

## Contributors & Developers

“Clearyvo Database Cleanup – Optimize Database, Autoload & Orphaned Data” is open
source software. The following people have contributed to this plugin.

Contributors

 *   [ Clearyvo ](https://profiles.wordpress.org/kishollo001/)

[Translate “Clearyvo Database Cleanup – Optimize Database, Autoload & Orphaned Data” into your language.](https://translate.wordpress.org/projects/wp-plugins/clearyvo-database-cleanup)

### Interested in development?

[Browse the code](https://plugins.trac.wordpress.org/browser/clearyvo-database-cleanup/),
check out the [SVN repository](https://plugins.svn.wordpress.org/clearyvo-database-cleanup/),
or subscribe to the [development log](https://plugins.trac.wordpress.org/log/clearyvo-database-cleanup/)
by [RSS](https://plugins.trac.wordpress.org/log/clearyvo-database-cleanup/?limit=100&mode=stop_on_copy&format=rss).

## Changelog

#### 0.8.6

 * Fixed: the daily background-task cleanup is scheduled again after the plugin 
   is deactivated and reactivated (it showed as on but did not run).
 * Fixed: “Last run” counts the removed log lines too.
 * Fixed: switching autoload off accepts only options shown on the results page;
   this plugin’s own settings are no longer listed.
 * Faster duplicate post meta cleanup when post IDs have large gaps.
 * Uninstall also removes the resume point of an interrupted duplicate cleanup.
 * Shared Clearyvo framework 3.7.5: CSV export without file functions, sanitised
   query names in filter links, every assembled block printed through wp_kses(),
   the “moved into the Clearyvo menu” notice only on the Plugins screen and the 
   Clearyvo page.

#### 0.8.5

 * Plugin name: “Clearyvo Database Cleanup – Optimize Database, Autoload & Orphaned
   Data”.

#### 0.8.4

 * Plugin name without the name of another project.
 * Shared Clearyvo framework 3.7.4: the “moved into the Clearyvo menu” notice shows
   only on the Dashboard, the Plugins screen and the Clearyvo page; the redirect
   of old page addresses passes on only sanitised query names; one unneeded core
   include removed.
 * Every PHP file stops when it is loaded outside WordPress.

#### 0.8.3

 * Shared Clearyvo framework 3.7.3: the pointers to other Clearyvo plugins (“Get
   it”, “Install”, “More from Clearyvo”) only name plugins that are already in the
   WordPress.org plugin directory.

#### 0.8.2

 * The backup warning above the results no longer links to another plugin.

#### 0.8.1

 * Shared Clearyvo framework 3.7.1, the same as in the other Clearyvo plugins: the
   plugin installer of the shared menu installs only packages from WordPress.org
   and checks permissions before reading the request; “Hide for 30 days” and the
   review prompt check the nonce and permissions first; uninstall also removes the“
   Hide for 30 days” user setting and the cached WordPress.org data of the shared
   menu.

#### 0.8.0

 * Leftovers: must-use plugins and drop-ins count as installed; options that an 
   installed add-on of the same plugin family may use (Jetpack Boost, Secure Custom
   Fields, Event Tickets, BuddyBoss …) are no longer called leftovers. Leftovers
   are never pre-ticked and count as “to review”, not as safe.
 * Orphaned term relationships: only taxonomies of posts are checked, so user and
   group taxonomies are never touched.
 * Autoload: only options listed by the scan can be changed.
 * Duplicate post meta is cleaned in post ID ranges, so large sites do not time 
   out.
 * Shared Clearyvo framework 3.6.2.

#### 0.7.1

 * Security: all database queries are fully prepared, including the Action Scheduler
   cleanup.
 * The shared Clearyvo framework loads WordPress admin include files only when their
   functions are missing.

#### 0.7.0

 * Unified Clearyvo interface: the shared Clearyvo layout of every checker, with
   Overview and Settings views. Summary cards (Score, database size, safe to remove,
   needs review, autoloaded options, plugins that left options) also show the last
   scan on later visits; one “Scan database” button with a progress bar while the
   scan runs; results as tables with Status pills; a “How it works” card.
 * New: Export CSV of the tables, the autoloaded options and the leftovers; a filter
   for the tables by owner status. The daily background-task cleanup moved to Settings(
   with the CSV separator).
 * Plugins screen: the link is called “Open”.
 * Unchanged: the scan, the cleanup and all stored data.
 * Shared Clearyvo framework 3.3.0: number columns line up, code names such as hooks
   and file names no longer break letter by letter on phones and long filter choices
   stay compact.

#### 0.6.3

 * Shared Clearyvo framework 3.2.0: when several installed Clearyvo plugins contain
   this checker (this plugin, Site Toolkit), only the newest copy runs; an older
   plugin that keeps its own copy is named in an “Update” notice.
 * Site Toolkit menu: one entry per topic, the checkers of a topic as tabs. Site
   health shows a “Fix these first” list.
 * Uninstall keeps the data while another installed plugin still uses it, and cleans
   every site of a multisite network.
 * The interface stays English with every combination of Clearyvo plugins.

#### 0.6.2

 * Shared Clearyvo framework 2.5.0: built on 2.3.2 (the order of the SEO group in
   the menu), with the abilities of 2.4.0, and the new Cron Checker and Permalink
   Checker in the family list.
 * The new Clearyvo Cron Checker and Permalink Checker are recognised as part of
   the family (their settings are not shown as leftovers).

#### 0.6.1

 * Readme: clearer description of what the plugin cleans, and answers to common 
   questions about database cleanup, autoload and Action Scheduler.

#### 0.6.0

 * New: Background tasks (Action Scheduler). Removes finished, canceled and failed
   tasks older than 7 days together with their log lines, and orphaned log lines,
   in batches. Pending and running tasks are never touched. Shows tasks by status,
   the hooks that create the most tasks, and whether the queue is late or stuck.
   Free, no limits.
 * New: optional automatic daily cleanup of finished and canceled background tasks(
   failed ones are kept for review).
 * New: oEmbed caches in post meta, and duplicate post meta (same post, key and 
   exact value; one copy stays). Duplicates are compared byte for byte, so values
   that differ only in letter case are kept.
 * New: read-only abilities for the WordPress Abilities API (WordPress 6.9+): clearyvo/
   database-cleanup-summary and clearyvo/database-cleanup-background-tasks. AI assistants
   can read the results through the MCP Adapter; nothing can be deleted that way.
 * Shared Clearyvo framework 2.4.0: the “clearyvo” ability category and clearyvo/
   site-health.
 * Fix: the version shown inside the plugin matches the plugin version again (it
   showed 0.5.4).

#### 0.5.5

 * Shared Clearyvo framework 2.3.1: the SEO checker is listed as Clearyvo SEO (formerly
   Image Alt & SEO) everywhere, whichever Clearyvo plugin loads the framework.

#### 0.5.4

 * Database: every query goes through $wpdb->prepare(), with %i placeholders for
   table names.

#### 0.5.3

 * New icons: one design for the whole Clearyvo family, with a colour per group 
   of checkers.

#### 0.5.2

 * The other checkers in the shared menu have their new names (SSL Checker, Security
   Checker, Indexing Checker and the rest).

#### 0.5.1

 * The plugin links point to wp-sitechecker.com again, until the site has moved 
   to clearyvo.com.

#### 0.5.0

 * New: read-only connection for the Clearyvo Site Inspector Mac app (Site health
   as data, for administrators with an Application Password).

#### 0.4.1

 * Links to the new home of the Clearyvo WordPress plugins: clearyvo.com/wordpress.

#### 0.4.0

 * First release under the Clearyvo name (folder and text domain: clearyvo-database-
   cleanup). Settings and results of the earlier versions are kept; activating this
   plugin switches the earlier copy off.

## Meta

 *  Version **0.8.6**
 *  Last updated **1 hour ago**
 *  Active installations **Fewer than 10**
 *  WordPress version ** 6.2 or higher **
 *  Tested up to **7.1.5**
 *  PHP version ** 7.4 or higher **
 * Tags
 * [action scheduler](https://wordpress.org/plugins/tags/action-scheduler/)[autoload](https://wordpress.org/plugins/tags/autoload/)
   [clean database](https://wordpress.org/plugins/tags/clean-database/)[database cleanup](https://wordpress.org/plugins/tags/database-cleanup/)
   [wp_options](https://wordpress.org/plugins/tags/wp_options/)
 *  [Advanced View](https://wordpress.org/plugins/clearyvo-database-cleanup/advanced/)

## Ratings

No reviews have been submitted yet.

[Your review](https://wordpress.org/support/plugin/clearyvo-database-cleanup/reviews/#new-post)

[See all reviews](https://wordpress.org/support/plugin/clearyvo-database-cleanup/reviews/)

## Contributors

 *   [ Clearyvo ](https://profiles.wordpress.org/kishollo001/)

## Support

Got something to say? Need help?

 [View support forum](https://wordpress.org/support/plugin/clearyvo-database-cleanup/)