If you feel that some of your wordpress plugins are not working then the answer to this would be plugins conflict and this continues even if some plugins were disabled or uninstalled and deleted because their entries are stored in the database and this can conflict and also slow down the blog. The more plugins you install, activate and later disable the database size grows with this stuff and it makes the database to slow down. A solution for this is Wp Clean Options Plugin which will find orphaned options in your wp_options table and remove them.
First of all you need to Install this plugin and activate if from your Plugins Section, which once done you will find a link to the CleanOptions under Manage > Tools section. Here the link to CleanOptions would also have a number next to it which represents the total number of rows which the Options Table currently has and this includes many which are not required and you can remove.
Click on the ‘Find Orphaned Options’ link to continue to the next step, which would show you a list of all the rows in your wp_options table of your blog’s database. You will be given with a list of ‘Possibly Orphaned Options’ and if you want to understand which rows were found with this plugin you can click on the Google it link next to the row name in order to find more information about it.
- Look at the file names in any Warning messages.
- Look at the text in any Alternate Syntax Warning messages.
- Some information may be available at your wp-admin/options.php page.
- Try a Google search for the option_name.
Carefully Review information on the “View Selected Options Information” page before deleting the option.
The following Options appear to be orphans. When shown, non-selectable Options are known to have been created from files present during upgrade or backup, or are legitimate options that do not “fit” the search for get_option or get_settings. If you wish to remove them by other means, do so at your own risk.
At the end of the page after the rows information you will find a option – Select all / Deselect all “all” means BOTH “plugin” AND “rss_” options. , Click on Select all and then ‘View Selected Options Information’ , then you will get a big list of information stored in these orphan rows which have to be deleted. Please review this information very carefully and only remove Options that you know for certain have been orphaned or deprecated.
Generally i would go with all the rows found by this plugin but its recommended to take a backup of your database and then perform the option – Yes, Remove ALL of these options from the wp_options table, which when once submitted you will find that a report would be generated with the list of rows deleted and the total number of rows currently available in the Options Table.
I had a around 500+ rows on this blogs wp_options table which after cleaning was down to around 200+ which means that overall we cleaned a lot of useless stuff from our database and make sure only the most important data is stored in it.