The WordPress database stores all the information and options that the plugins use to make the full site works. But in the majority of cases, people try lots of plugins just to see what can these tool changes in their blogs, and in other cases, bloggers want to extend functions and so on. The common things about deactivating WordPress plugins after trying them is that the database tables still save the deleted plugin’s options and that can be a big problem with the time.
If you’re one of those who sees lots of tables that the site no longer uses and you want to clean the MySQL tables, then, you have to use a free plugin called Options Optimizer and it’s a lightweight tool that scans and find every stored option for deleted plugins that the site no longer uses. Unlike some other tools, this one helps you to find the exact data and you just need to select the appropriate ones in order to delete them. This tool has not updated since the last two years, but it still works correctly with the latest versions of WordPress without any issues.
- Related: How to repair database in PHPMyAdmin.
To start scanning the database options, you don’t need any settings, just click the plugin’s link from your left menu, you can find it under the “Settings” menu. then, you will see something like the below example.
As you can see, the second columns let you know if the options will autoload or not with every page view.
If you find the options that from deleted plugins, just check the “delete” box and scroll down to click the update button. Then, that orphan option. At the same time, other plugins can make your blog loads slowly by adding an option that auto loaded with every page view, in this second case, you can turn the autoload off by checking the box “yes”. To change back that option, check the box “no” from the “change autoload” column.
It’s an easy to use tool to clean up the full database from the options. However, never touch options that the site uses actually, you can try disabling the autoload only and see if that helps to speed up the site. Then, change them back when something wrong happens. The best thing is that there is no risk, options can be disabled or enabled again to be autoloading. But when you’re sure about plugins that you’ve deleted completely, then deleting the related options will not affect the site, simply because they’re an orphaned tables and removing them completely is the right action.
Normally, when you uninstall a plugin, the related options should be removed also from the database, unluckily, it’s not the case for all the tools. Lots of these plugins will just remove the file associated with it, but not the options and the data. That’s why using this simple, but effective database cleaner will save lots of space and makes the site perform better with fewer options that slow the site and make the loading time a big problem to solve.
To clean the database even better from post auto draft, spam comments and all the other junk files, read this post.
I hope that this helped, do you have other tools to remove orphaned data from the site databases? So share them in your comment.