Does your WordPress blog run slowly in a fast hosting company?
It could be due to your WordPress database. This can be solved with a good database optimization plug-in.
When it comes to cleaning the WordPress database, we have many excellent options such as WP-Sweep, WP-Optimize and WP-Db Manager. These add-ons eliminate overhead, optimize the database and in turn make your WordPress blog work faster.
However, none of them clean unused tables, tasks and options left by add-ons that are no longer used.
- Do you know that even when you delete an add-in it does not clean everything you added to the database?
I already informed you about the deep cleanup of your WordPress database. in a previous post.
Recently, I was working on optimizing the WordPress database of my main blog (ShoutMeLoud) and I had to thoroughly clean up the orphan tables and options . The use of existing accessories (such as cleaning options) was not enough and I was looking for a free alternative.
This is where I came across the add-in Advanced WordPress Database Cleaner that is available for free in WordPress repo However, the free version is limited to the features offered by other base optimization add-ons. data like WP-Sweep.
They also have a premium version that made me buy the add-on ($ 15 for a site or $ 30 for 5 sites).
In this post, I will give you a detailed description of the WordPress Database Cleaner advanced and show you how to use it.
How to use the WordPress advanced database cleaner plug-in
If you just want to try the plug-in with limited features, you can download the free version from here.
If you are in the process of cleaning and optimizing a WordPress database (your site or your client’s site), purchase the Pro plug-in from here. Remember, it may take approximately 5 minutes to receive the email with your add-in file and the license key.
Download the plug-in by clicking on the link in the email and install it manually.
you can access the settings by going to Tools> WP DB Cleaner and enter your license key to activate the add-in.
Using the plug-in  After activation, go to “General information and settings” to see the current status from your WordPress database.
- Don’t forget to make a backup copy of your database before you start cleaning and optimizing!
Now, go to the “General cleaning” tab and start basic optimization. If you are not sure what to do, just use the settings as shown below.
Once this is done, click on the “Optimize” tab to or optimize the database . Something good about this add-on is that it shows only those tables that require optimization.
Search and remove orphan tables
Click on “Tables” “And click on” Detect orphan tables “.
Depending on the size of your database, it may take a few seconds to display all orphan tables.
 Now, click on the orphan table and you will see the name of the table that does not belong to any currently installed plug-in.
Warning: This function is for users who know the WordPress plugins and only for those who manage your WordPress blog, however, take a backup of WordPress before deleting any table.
Search and delete option tables  Now click ic on the “Options” tab and similar to orphan tables, click on “Detect orphan options”.
And you can continue the cleaning process.
Scheduled tasks option: (Cron Tasks)
Here you can detect all scheduled tasks and, like the last two options, use “Find orphan tasks” and start cleaning.
Once everything is done, you can simply deactivate the plug-in.
You should continue to optimize your database once a month and do a deep clean once a quarter.
Download Advanced WordPress Database Cleaner
Here is a table that compares all the features Popular WordPress database optimization and cleanup plugins:
Let me know what WordPress database optimization plug-in you are using.
If you are also an Advanced WordPress Database Cleaner user, let me know your experience.
You should also check our WordPress file to find many other useful WordPress plugins.