Home > Wordpress > Clean Options WordPress Plugin: Delete Orphan Tables from Database

Clean Options WordPress Plugin: Delete Orphan Tables from Database

WordPress is no doubt a memory hogging blogging platform, but by the end, it’s the best blogging platform. There are thousands of plugins which will help you to do anything with your WordPress blog.

One thing which WordPress need in a regular basis is optimization. This could be optimization of your WordPress theme or database. Whenever we install a plugin, it adds tables into the database, and when we disable and uninstall the plugin, it doesn’t mean those tables are deleted.

To uninstall a WordPress plugin completely, you should also delete those options created by the plugin.

Clean options WordPress plugin is one such plugin which helps you to find all orphaned options from your database and help you to delete them completely. Though before you read further and install this plugin, I highly recommend you to take a backup of your WordPress database.

February 2017 Update: WordPress Advanced database cleaner seems to be the best plugin at this moment for cleaning the unused & orphan WordPress database tables. It makes detecting the orphan tables & orphan options easier.

Advance WordPress Database cleaner


How to use Clean Options WordPress plugin?

Now download and install Clean Options WordPress plugin and go to setting by clicking on Tools> CleanOptions.


Now you will see a list of suspected orphaned options. You should not delete all the options. Instead select options manually by looking into the name and if you have uninstalled the plugin, remove it.  In case of doubt, you can search for that option name in Google to find which plugin added that option.


On the next page you will see value added to those options table and you can quickly verify if you are no longer using those plugin or still using it. Once you are satisfied with your selection, select Yes, Remove ALL of these options from the wp_options table and click on Submit.

submit-optionThat’s it and now you have removed useless options table from your database. Before you use this plugin, I highly recommend you to take back up of your database and you should be aware of which options you are removing. In case of doubt, give benefit of doubt to that options and don’t remove it.

Plugin Link

If you are doubtful about any particular options, feel free to ask and I will try to let you know which plugin or theme added that option.


Leave a Reply

Your email address will not be published. Required fields are marked *

This site uses Akismet to reduce spam. Learn how your comment data is processed.


Enjoy this blog? Please spread the word :)

Follow by Email1k