This plugin hasn’t been updated in over 2 years. It may no longer be maintained or supported and may have compatibility issues when used with more recent versions of WordPress.

WPDBSpringClean

Description

1) Database Table Clean:

Many plugins do not clean up their database tables after you uninstall them.

What happens most of the time is that the plugin files and folder is deleted but not the corresponding plugin database tables.

This where this plugin comes to the rescue. The WPDBSpringClean plugin identifies unused, WordPress DB tables which have
been left over from old plugins you have uninstalled on your site and it then gives you the option of deleting these tables.

2) Database Table Optimization:

Due to regular insertions and deletions in the various DB tables on your system, these tables can quite often hold allocated but unused space.
Consequently this can make your DB tables inefficient, fragmented and unoptimized.
This plugin will identify unoptimized tables and will allow you to optimize them by deleting the allocated unused space within a particular table.
The plugin also optionally allows you to specify search criteria such as the minimum amount of overhead per table and minimum unused space for a table.

By default if no search criteria is specified, the plugin will identify all tables which have an overhead of greater than 10%.
(Note: “Overhead” in this plugin is defined as (Data_free/Data_length) expressed as a percentage and where Data_free and Data_length are MySQL table parameters)

For more information on the WPDBSpringClean and other plugins, visit the WPSolutions-HQ Blog.
Post any questions or feedback regarding this plugin at our website here: WPDBSpringClean.

Screenshots

  • Screen shot file screenshot-1.jpg shows the table delete admin menu.
  • Screen shot file screenshot-2.jpg shows the table optimize admin menu.

Installation

  1. FTP the WPDBSpringClean folder to the /wp-content/plugins/ directory,

OR, alternatively,

upload the WPDBSpringClean.zip file from the Plugins->Add New page in the WordPress administration panel.

  1. Activate the WPDBSpringClean plugin through the ‘Plugins’ menu in the WordPress administration panel.

If you encounter any bugs, or have comments or suggestions, please contact the WPSolutions-HQ team on support@wpsolutions-hq.com.

FAQ

Will this plugin prevent me from deleting the wrong table?

WPDBSpringClean identifies only those database tables which are considered
not part of any of your installed plugins (either ACTIVE or INACTIVE).
When WPDBSpringClean has finished its query it will list all of the tables it
believes are not being used and it will give you the option of deleting some or all of these tables.

(As a matter of prudence it is recommended that you take a DB backup if you are unsure about deleting particular tables)

Reviews

not there yet

It does detect tables that are empty, which is a big difference from tables that are not used. So once you get the list you must really search the web for every single name, to find out that the web is not helpful at all.
All in all, counting the very few other plugins that are supposed to help you in this matter (they all do half the job and are far too outdated) I believe we are still far beyond the moon.

Brilliant (but getting scary after 3 years and no update)

Brilliant and effective.
Gets rid of loads of clutter that plug ins leave behind.
There shouldn’t even be a need for this plug in, but even pro versions with tens of thousands of installs don’t necessarily ask if you want to retain data as part of uninstall.
Since having it I have been far more likely to give a plug in a test run, knowing this will tidy up after it.
BUT
3 years without an update, it is getting scary to use it.
If ‘wpsolutions’ is out there and reads this, come back man. I would love to see ‘update available’ in my plug in list.

Excelente plugin

Simplemente cumple con lo que promete, mi instalacion de wordpress tenia ya 60 tablas de las cuales me dejo unicamente las necesarias y mi sitio sigue funcionando perfectamente.

works wonderfully

Don’t be put off by the fact that the plugin hasn’t been updated in 3 years. Just tested this on my blog and it still works great. Found a bunch of database tables that old plugins left behind and was able to remove them without any issues!

Read all 50 reviews

Contributors & Developers

“WPDBSpringClean” is open source software. The following people have contributed to this plugin.

Contributors

Translate “WPDBSpringClean” into your language.

Interested in development?

Browse the code, check out the SVN repository, or subscribe to the development log by RSS.

Changelog

1.6

  • Improved the way in which the “plugins” directories are retrieved when searching. The plugin will now also work correctly for instances where people may have moved the “wp-contents” directory.

1.5

  • Corrected a mistake in the logic which was automatically performing an unused table search when plugin was installed for the first time
  • fixed bug where deletion of tables using bulk delete was not working properly

1.4

  • Fixed and tested any incompatibilities and errors for WP 3.5.1

1.3

  • Added new functionality:
    WPDBSpringClean now also offers the ability to search for unoptimized DB tables (ie, tables which have a high overhead whereby they have a high percentage of allocated but unused space)
    WPDBSpringClean then gives you the option of optimizing these tables so that your database uses its space more efficiently.

1.2

Bugs Fixed:
* This release has fixed a problem which some people were encountering which displayed the error: “Maximum execution time of 30 seconds exceeded”.
With this fix the search time has been greatly reduced too.

1.1

  • Improved page load performance when a delete is being performed
  • Added spinner GIF to represent progress bar during search operation

1.0

  • First Release