Plugin: Cleanup Database

Plugin: Cleanup Database

Essential WordPress Tips To Help Optimise And Cleanup Database

WordPress › WP Clean Up Optimizer - Optimize WordPress « WordPress Plugins

Clean up database

Remove post revisions, remove unused database options, remove expired transient options, optimize tables, etc.

WP-Sweep

My selected champion is WP-Sweep, from a recognized plugin developer. I really do like this plugin as it is simple and efficient - exactly what is needed (review) review

Delete Expired Transients

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.

  • Tweak Option
    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.

  • Option Inspector
    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.php page. 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.

  • Options Pixie No way to edit or delete options - there is payed version for that. Other than that it’s written as it should be.

  • Clean Options is the oldest and obviously not maintained.


Manually remove plugin residues in database

Cleanup tables.

# WP Wizard Cloak (pmlc_*)
DROP TABLE wp_gdsr_*;

# GD Star Rating (gdsr_*)
DROP TABLE wp_gdsr_*;

Database reset

WordPress Database Reset

date 25. Nov 2016 | modified 17. Jan 2023
filename: Plugins » Cleanup Database