== Description ==
Clean up database by deleting orphaned items such as 'old revisions', 'spam comments', optimize database and more...
If you have been using WordPress for a while, then you should think absolutely about a database cleanup. Indeed, your database may be full of garbage that makes your site sluggish and bloated such as old revisions, orphaned post meta, spam comments, etc. You should clean-up this unnecessary data to reduce your database size and improve website speed and performance. In addition, you will have quicker database backup since the file of your backup will be smaller.
'Advanced Database Cleaner' is a must-have plugin that allows you to clean database, optimize database and more.
= Main Features =
* Delete old revisions of posts and pages
* Delete old auto drafts
* Delete trash posts
* Delete pending comments
* Delete spam comments
* Delete trash comments
* Delete pingbacks
* Delete trackbacks
* Delete orphan post metadata
* Delete orphan comment metadata
* Delete orphan user metadata
* Delete orphan term metadata
* Delete orphan relationships
* Delete expired transients
* Display and view orphaned information before making a database clean-up so you can be sure about what you are going to clean-up
* Search & filter all items based on their names or values
* Keep last x days' data from being cleaned: clean only data older than the number of days you have specified
* Schedule database clean up to run automatically
* Create as many scheduled cleanup tasks as you need and specify what items should be cleaned by the scheduled task
* Scheduled tasks can be executed based on several frequencies: Once, hourly, twice a day, daily, weekly or monthly
* Display database tables information such as the number of rows, table size, etc.
* Optimize database tables (The plugin will notify you if any tables require optimization)
* Repair corrupted database tables or damaged ones (The plugin will notify you if any tables are corrupted or damaged)
* Schedule database optimization and/or reparation to run automatically and specify what tables should be optimized and/or repaired
* Empty database tables rows
* Clean and delete database tables
* Display options list
* Display options information such as option name, option value, option size, option autoload
* Clean and delete options
* Set options autoload to no / yes
* Display active cron tasks list (scheduled tasks) with their information such as arguments, next run, etc.
* Clean and delete scheduled tasks
* User-friendly and simple to use
info: https://sigmaplugin.com/downloads/wordpress-advanced-database-cleaner