Advanced Database Cleaner is a must-have plugin that cleans and optimizes your WordPress database.

WordPress Advanced Database Cleaner Pro Features

• Clean up Posts Table
  Delete old revisions of posts and pages, delete old auto drafts & delete trash posts.
• Clean up Comments Table
  Delete pending comments, spam comments, trash comments, pingbacks and trackbacks.
• Clean up Orphaned Metadata
  Delete orphan post metadata, orphan comment metadata, orphan user metadata, orphan term metadata and orphan relationships
• Clean up Expired Transients
  Expired transients are temporary options that should not exist in your database since they are expired! Learn more
• Display & View Orphaned Items
  View details about orphaned item before making a database clean-up so you can be sure about what you are going to clean-up
• Keep Last x Days’ Data
  You can keep the last x days’ data from being cleaned and clean up only data older than the number of days you have specified
• View & Manage Tables
  Display tables information such as the number of rows, table size, etc.
• View & Manage Options
  Display all options list and options information such as name, value, size, autoload, etc.
• View & Manage Cron jobs
  Display active cron tasks list (scheduled tasks) with their information such as arguments, next run, etc.
• Get and overview
  The plugin will help you get a clear idea of what is happening in your database.
• Scheduling
  The plugin will automate the process and run a cleanup/optimization automatically based on your settings. No need to do it manually each time
• Reduce DB size
  By deleting unused/orphaned items, you will save space in your database and make quicker backups since the file of your backup will be smaller
• Detect & delete orphaned options
  Your ‘wp_options’ table may be full of orphaned options and therefore can impact the performance of your website.
• Detect & delete orphaned tables
  You may have orphaned tables that were created by plugins/themes you are not using anymore. Clean up orphaned tables will increase performances
• Detect & delete orphaned cron jobs
  After you uninstall a plugin/theme, some of its cron tasks may still be active making WordPress calling unknown functions.
• Scan & Edit Categorization
  You can scan specific items or all items to verify to which plugin/theme they belong.
• Search & Filter Anything
  You can search and filter options, tables and cron jobs based on several criteria such as the “name”, “creator”, “value”, etc.