Plugin: Cleanup Database
Clean up database
Remove post revisions, remove unused database options, remove expired transient options, optimize tables, etc.
The WP CleanFix plugin requires the wpXtreme Framework plugin to run properly. This is enough reason not to use it anymore anywhere. WP CleanFix
Not updated: Transient Cleaner
Unfortunately, expired entries will only be deleted if you attempt to access the transient again.
- WP-Optimize is a similar to a WP-Sweep, but I do like more the latter as it shows the details about what it will clean. This one also supports scheduled cleanups.
SQL Queries from Wordpress
WP-DBManager can do everything. The only thing I don’t like is it uses server commands directly.
Plugin - Optimize wp_options
Really advanced idea how to remove unneeded options is explained here.
Perfect! This one has it all. Simple and efficient. You can edit as well as delete options and there is search functionality. Autoloading is indicated, also.
Also very good. Has it everything + very nice visualization of serialized data. Autoload flag is not displayed in main table, and overall - design is a bit rough. Close second.
Above two are good enough.
Part of Wordpress Core is
/wp-admin/options.phppage. There are a lot of plugins that create a link to that page in dashboard.
WP Options Editor All the options editing (click on value) and removing. Too ambitious for me.
Clean Options is the oldest and obviously not maintained.
Manually remove plugin residues in database
# WP Wizard Cloak (pmlc_*) DROP TABLE wp_gdsr_*; # GD Star Rating (gdsr_*) DROP TABLE wp_gdsr_*;