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)
- FTP the WPDBSpringClean folder to the /wp-content/plugins/ directory,
upload the WPDBSpringClean.zip file from the Plugins->Add New page in the WordPress administration panel.
- 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 email@example.com.
- 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)
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.
He does his job!
Seemed to work well on WP 4.5.3. Deleted many unused tables from old plugins.
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!
I’ve been searching for a better plugin to hunt down unused tables and this plugin is the best I’ve tried, Simple and it works.
Just thought to drop this in…
I have just tried this plugin today as my DB (Listing Directory) was mega slow after tons of plugins test and deleted had left hundreds of tables behind!
My site slowed down to a crawl!!
Applied this plugin, cleaned up the tables and BAM!!! > Such a difference!
In short, it works wonderfully well even though it has not been updated for 3 years!
Congrats to Dev, look forward to an update, create a Pro, I’ll buy it!
Contributors & Developers
“WPDBSpringClean” is open source software. The following people have contributed to this plugin.Contributors
- 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.
- 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
- Fixed and tested any incompatibilities and errors for WP 3.5.1
- 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.
* 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.
- Improved page load performance when a delete is being performed
- Added spinner GIF to represent progress bar during search operation
- First Release