PLUGIN INFORMATION

Smart Cleanup Tools is an easy to use, powerful plugin for database cleanup with total of 37 cleanup, reset and removal 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.

Powerful Database Cleanup for WordPress

Cleanup will be more effective if done after several months of normal database use. For example cleanup on www.dev4press.com website, cleanup was done 6 months after previous cleanup. Plugin saved amazing 2/3 of the database space, and database from 192MB was scaled down to 63MB. That is 129MB of junk and unneeded data. Full test is available here.

Quick cleanup: one click full cleanup

Main plugin panel shows quick cleanup tool with overview of active tools, found records for removal and estimated size to be recovered. Quick cleanup uses all cleanup tools. If you want to review everything before cleanup, open Cleanup panel for list of all available tools.

Cleanup Tools: 30 in version 4.0

Smart Cleanup Tools contains 30 cleanup tools that can remove most of the obsolete or orphaned data in the WordPress database. You can see estimated records that each tool will remove. You can also disable each tool from plugin Settings panel.

List of 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)

Removal Tools: 10 in version 4.0

Removal tools can remove data that might be still in use but no longer needed. It can delete attachments, posts, comments or terms based on different criteria. Before using these tools, you should always have backup ready.

List of removal tools

• Remove attachments with missing files (v4.0)
• Remove attachments with missing parent posts (v4.0)
• Remove attachments that are not attached (v4.0)
• Remove missing post types posts (v4.0)
• Remove missing taxonomies terms (v4.0)
• Remove missing unassigned taxonomy terms (v4.0)
• Remove missing all available taxonomy terms (v4.0)
• Remove Akismet comments logs (v2.5)
• Remove user agent data for all comments
• Remove pingback comments

Reset Tools: 3 in version 4.0

With reset tools you can remove some data from database, and it will be recreated to default values. Removing widgets from sidebars is useful when changing themes, and refreshing rewrite rules is useful when having problems with permalinks.

List of reset tools

• Reset all sidebars
• Reset rewrite rules
• Reset plugins data and statistics (also in multisite mode)

Scheduled Jobs for automatic cleanup

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.

Export and Import of settings and jobs

All plugin settings and settings for scheduled jobs can be exported into file and later imported back.

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
• Log all executed SQL queries during cleanup check into file
• Log all executed SQL queries during cleanup execution into file
• Log work with normal and scheduled executions
• 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 4.0 / 2013.09.18.

• Added: one click cleanup from plugin front page
• Added: plugin now has own admin menu and submenus
• Added: panel for filtered data removal tools
• Added: removal – attachments with missing files
• Added: removal – attachments with missing parent posts
• Added: removal – attachments that are not attached
• Added: removal – missing post types posts
• Added: removal – missing taxonomies terms
• Added: removal – unassigned taxonomy terms
• Added: removal – all available taxonomy terms
• Improved: many improvements to the plugin interface
• Improved: more information added to various panels
• Improved: removal of Akismet data removes error records
• Changed: logs deletion moved from reset to logs panel
• Changed: comments related reset tools moved to removal
• Changed: main execution moved into own worker class
• Changed: admin interface controls moved into own class
• Updated: jQueryUI Timepicker 1.4
• Fixed: detection of the network specific database tables
• Fixed: deletion of log files for network

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