Plugin Information Smart Cleanup Tools is an easy to use, powerful plugin for database cleanup with total of 31 cleanup tools. With this plugin you can remove data that is no longer in use, or it is unneeded. Also, it can help you restore database overhead and speed up database operations. Plugin supports WordPress multisite, and it has few tools designed for the Network administration.
You can schedule cleanup jobs to run at any time, they can run once or they can run on a repeat with selected period. All cleanup reports can be saved into files. All plugin settings and settings for scheduled jobs can be exported into file and later imported back. Cleanup Tools
Remove orphaned terms records (v3.2) Remove oEmbed cached postmeta records (v3.1) Remove orphaned relationships records (v3.0) Remove expired transient records (also in multisite mode) (v2.5) Remove GravityForms spammed submissions (v2.1) Remove GravityForms trashed submissions (v2.1) Remove draft posts records Remove auto-draft posts records Remove trashed posts records Remove spammed posts records Remove published posts revisions records Remove orphaned posts revisions records Remove trashed comments records Remove unapproved comments records Remove spammed comments records Remove empty postmeta records Remove orphaned postmeta records Remove empty comment meta records Remove orphaned comment meta records Remove orphaned comments records Remove RSS feeds cache Remove empty user meta records Remove transient records (also in multisite mode) Remove database overhead (also in multisite mode)
Reset Tools
Remove Akismet comments logs (v2.5) Reset all sidebars Refresh rewrite rules Remove pingback comments Remove user agent data for all comments Reset plugins data and statistics (also in multisite mode) Reset plugins log files (also in multisite mode)
Other Features
Tools to export and import plugin settings and scheduled jobs Disable tools you don’t want to use from cleanup and reset panels Use scheduler to create jobs that can run automatically Log all exected SQL queries during cleanup check into file Log all exected SQL queries during cleanup execution into file Log cleanup logs for normal and scheduled executions into files Gathers statistical data for each tool used Gathers global statistics for saved database space Uses AJAX for cleanup operation executing Support translation and includes POT file
Changelog Version 3.2 / 2013.08.02.
Added: tool to remove all orphaned terms records Improved: scheduled job editor shows proper creation messages Fixed: problem with use of admin side only functions
Version 3.1 / 2013.06.01.
Added: tool to remove all oEmbed cached post meta records Improved: cleanup results calculation of removed records Changed: database overhead tool is now always active by default Fixed: problem with removal of orphaned post revisions records
Full changelog available on plugins home page