Subscribe Via RSSClean WordPress Options
Clean WordPress Options
When you probably already know if you’ve read my other articles on reducing WordPress CPU usage, deleting a plugin can leave a small footprint in the MySQL ‘wp_options’ database. To help optimise the database and maximise page load times it’s a good idea to clean the WordPress Options database after you have deleted plugins which are no longer required.
The WordPress plugin, Clean Options, seems to fit this purpose well [http://WordPress.org/extend/plugins/clean-options/]. The plugin’s goal is to give you an easy and safe way to get a bloated wp_options table down to a manageable size, thus improving the performance of your blog, just what we want.
The Clean Option plugin searches PHP files in your blog’s folders for get_option(‘option_name’) and get_settings(‘option_name’) with slight variations. The plugin will display a warning to help you identify options which may not really be orphaned. Files that are temporary, such as during upgrade and back-up, are ignored.
Clean Options Limitations
At the time of writing the plugin was only compatible with WordPress to version 2.9.2. Hopefully the author will remedy this quickly.
- Remember to deactivate and delete unused plugins first before performing the cleaning up process.
Thanks for the heads up. I’ve used this plugin several times now. It worked great.
This is best way to remove disabled plugin entries in database.
A word of warning though, make sure you backup your database BEFORE using this plugin. You could really mess things up if you’re not careful.
I am using Optimize DB (http://wordpress.org/extend/plugins/optimize-db) but am not sure if does anything more than what it says it does…optimize your database. So I may be looking to switch. Anyway thanks for the great info.