Smart Cleanup Tools

Extended license price: $150.00

This plugin has been purchased 634 times so far.

Plugin released on:
December 28, 2012

Plugin last updated on:
May 7, 2017

Tags: akismet, cache, cleanup, comments, cron, database, gravity forms, optimization, overhead, posts, reset, rewrite, scheduler, tools, transient

Changelog

Version 4.3.3 / 2015.08.24.

Fixed: problem with displaying details for some cleanup tools

Version 4.3.2 / 2015.04.13.

Fixed: memory exhaused error with some cleanup operation
Fixed: missing WP internal cache flush for some cleanups

Version 4.3.1 / 2015.04.05.

Updated: minor changes to the cleanup worker class
Fixed: warning for missing class name with scheduled cleanups

Version 4.3 / 2014.12.08.

Updated: posts draft cleanup tool moved to removal panel
Updated: better cleanup size estimation for some tools
Updated: several minor visual changes and improvements
Fixed: wrong ID for the toolbar activity checkbox settings
Fixed: saving toolbar activity option for multisite

Version 4.2 / 2014.08.24.

Added: WordPress toolbar quick cleanup access menu
Added: toolbar quick cleanup: remove all rewrite rules
Added: toolbar quick cleanup: remove all transients
Added: log cleanup job run through Smart Security Tools
Fixed: missing several translation strings in POT file
Fixed: several styling issues related to multisite mode
Fixed: several minor styling issues with the UI

Version 4.1 / 2014.05.08.

Added: reset tool to remove posts edit lock keys
Added: cron jobs can use selected reset tools too
Added: some jobs now have additional popup information
Updated: internal control for tools available for scheduler
Updated: many changes to the plugin core loader class
Updated: jQueryUI 1.10.4
Updated: compatibility with WordPress 3.9
Fixed: several styling issues with WordPress 3.9

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

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

Version 3.0 / 2013.05.26.

Added: tool to remove all orphaned relationships records
Added: tools for import and export of plugin settings
Added: show detailed popup analysis results for some of the tools
Added: options to fully disable some of the cleanup tools
Added: option to show cleanup summary for all active tools
Added: option to auto hide all tools that are inactive
Added: estimated size for the network mode tools
Improved: estimate size calculation for most of the tools
Improved: expanded descriptions for some of the tools
Improved: look and fill for layouts of all plugin panels
Improved: set tools dropdowns disabled if tools is disabled
Updated: jQueryUI 1.10.3
Updated: jQueryUI Timepicker 1.3
Fixed: several typos and some descriptions errors

Version 2.5 / 2013.04.20.

Added: tool to remove expired transient records
Added: reset tool to remove akismet comments log
Added: most tools display estimated records size
Improved: many small tweaks to the cleanup tools
Improved: expanded PDF user guide with more information
Updated: jQueryUI 1.10.2
Updated: jQueryUI Timepicker 1.2.2
Updated: jQueryUI Multiselect 1.14pre
Changed: WordPress 3.2 is no longer supported

Version 2.1 / 2013.02.08.

Added: tools to remove GravityForms spam and trash records
Added: filters and actions to hook into cleanup process
Improved: few minor changes and code cleanup
Improved: few more changes to the plugin styles
Fixed: some obsolete debug code still included

Version 2.0 / 2013.01.07.

Added: tools to remove draft and auto-draft posts records
Added: tools to remove empty commentmeta and usermeta records
Added: tool to remove all orphaned posts revisions
Added: tool to remove all unapproved comments
Added: reset tool to remove all pingback comments
Added: reset tool to remove comments user agent data
Added: scheduler for cleanup jobs: run once or repeatable
Added: scheduler for cleanup jobs: any combination of tools
Added: log into file: settings and panel for display log files
Added: log into file: sql queries for run and checkup
Added: log into file: reports for the cleanup executions
Added: some tools support selection of post type for cleanup
Added: context help panel with plugin important links
Improved: cleanup classes optimization to use less code
Improved: changed order for some of the cleanup tools
Improved: few changes to the plugin styles
Fixed: revisions removal was not counting closed posts
Fixed: admin side path problem in some cases

Version 1.0 / 2012.12.28.

First release

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

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

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: 23 in version 4.3

Cleanup Tools: 24 in version 4.2
Smart Cleanup Tools contains 24 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 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: 11 in version 4.3

Removal Tools: 10 in version 4.2
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 draft posts records (v4.3)
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: 4 in version 4.2

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

Remove all post edit locks (v4.1)
Reset all sidebars
Reset rewrite rules
Reset plugins data and statistics (also in multisite mode)

Scheduled Jobs for automatic cleanup

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

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

WordPress Toolbar Menu with quick access and cleanup options
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

Integration with Other Plugins

Smart Cleanup Tools adds new event in security log to track execution of cleanup, reset and removal jobs (including cron executions).

Documentation

Plugin contains PDF user guide in the plugin package, inside the ‘docs’ directory. Check out this documentation to get information on plugin options, usage and more.