Advanced Database Cleaner Premium

Over time a WordPress database collects clutter. Post revisions, auto drafts, spam comments and expired transients pile up, and plugins or themes that were uninstalled often leave options, tables and cron jobs behind. This data takes up space, makes backups larger and can add load to your site. The plugin gives you one place to find that clutter and remove it, with tools to repair and optimize tables as well.

The Premium version adds detection for orphaned options, tables and scheduled cron jobs, so you can see what was left behind and delete it. You can assign orphaned items to the plugin or theme they belong to, and search or filter by name or creator. Routine cleanups can run in the background on a schedule. It also works on multisite installations, which makes it a fit for developers and site owners who look after several sites.

Features

• Posts table cleanup: Remove old post revisions, auto drafts and trashed posts to reduce the size of the posts table.
• Comments table cleanup: Delete pending, spam and trashed comments, along with pingbacks and trackbacks, so the comments table holds only what you need.
• Orphaned metadata removal: Find and remove orphaned post, comment, user and term metadata that no longer connects to any content.
• Expired transient clearing: Clear expired transient data that takes up space in the database without serving a purpose.
• Database table management: Inspect table information, repair corrupted tables, and optimize or delete tables when needed to keep the database healthy.
• Options and autoload control: Browse all options with detailed information, then clean them or toggle their autoload property.
• Orphan detection for leftovers: Premium detects orphaned options, tables and scheduled cron jobs left by uninstalled plugins and themes, and lets you delete them.
• Scheduled automatic cleaning: Set up routine cleanups and optimizations that run in the background, so you do not have to repeat them by hand.

Best for

• WordPress sites with years of accumulated database clutter
• Developers and agencies maintaining several client sites
• Multisite networks that need database cleanup across sites