Clean WordPress Database with Advanced Database Cleaner – Is your WordPress site very slow to access? There are a number of common things that are commonly done to optimize the performance of a WordPress site so that it can be accessed quickly and ultimately improve your site’s ranking in search engines. Some of these things are as follows:
- Use a quality hosting service
- Use a cache plugin like WP-Rocket
- Use less plugins
- Use a CDN service
If you apply the 4 things above, and put in a little work when it comes to describing different file formats, you will have a WordPress site that is fast accessing and will be liked by your visitors. But if in a few months or maybe a few years your WordPress site is running and has decreased speed even very badly even though you have implemented the optimization and used the suggestions as above, then it could be because your database is not working optimally.
There are several plugins that you can use to optimize the performance of your WordPress database such as WP-Optimize and WP Sweep. However, both plugins only work to optimize the database in general, in contrast to the plugins that I will review in this article, namely WordPress Advanced Database Cleaner.
WP Reset
So, if you find yourself looking for a plugin that can bring you back in time when your website was working, look no more! WP Reset’s greatest feature is the Snapshots, which you can take before making any changes to the website, whether they are major or minor.
How do the Snapshots work? Well, before you go forward with your update or a new download, you can take a snapshot. That way, you will preserve that version of your website. Thus, when you realize what you did was wrong, you can easily revert to the old look of the website. It’s literally a time machine that works in your favor. Doesn’t that sound nice?
In addition, WP Reset offers several other tools that work to restore your website. For example, if you want to enable or disable more plugins at the same time, with this plugin, you can. You don’t have to waste time doing it one by one. Moreover, if so happens that you can’t even access your WP admin, you can simply use the recovery tool.
Finally, when you really need a clean slate to start over, you can utilize the Nuclear Reset option. It will remove all options, files, and tables, leaving you with a fresh website ready to be designed. However, despite all of the amazing options that WP Reset offers, it can’t clean up your database, which is why you will have to use the Advanced Database Cleaner plugin.
What is Advanced Database Cleaner?
Advanced Database Cleaner is a useful plugin for cleaning and optimizing your WordPress database so that it can work optimally, has a lean size and it will clean useless databases and tables.
As I said above that other database optimization plugins can only optimize databases in general, but the advantage of Advanced database cleaner is that it can detect useless databases and database tables and then delete them.
In running a WordPress site, chances are that you often test using several plugins and then uninstall the plugins, and when the plugins are uninstalled there are some plugins that really don’t delete the whole data and especially the database.
This will make your database bloated and useless which will result in the slow performance of your WordPress site. Apart from that, Advanced Database Cleaner can also clean the database which contains revisions, drafts, spam comments, Orphan options, Orphan tables and others.
Advanced Database Cleaner Features
You can use the WordPress Advanced Database Cleaner plugin for free and can be downloaded at WordPress.org. However, the free version doesn’t allow you to repair tables & tasks.
If you want to get the full features of the Advanced Database Cleaner plugin, you can buy Advanced Database Cleaner Pro for a very cheap price of $ 29.90. And here is a comparison between several WordPress database optimization plugins with Advanced Database Cleaner.
A : Advanced Database Cleaner (premium)
B : Advanced Database Cleaner (free)
C : WP sweep
D : WP-Optimize
E : Optimize Database after Deleting Revisions
F : WP Clean Up
Here are the different features offered by the free and premium versions of Advanced Database Cleaner:
Free version
- Delete old revisions of posts and pages, Delete old auto drafts
- Delete trash posts, Delete pending comments, Delete spam comments, Delete trash comments
- Delete pingbacks, Delete trackbacks
- Delete orphan post metadata, Delete orphan comment metadata, Delete orphan user metadata, Delete orphan term metadata, Delete orphan relationships, Delete expired transients
- Display and view orphan information before performing database cleanup
- Search & filter all items by name or value
- Schedule database cleanup to run automatically
- Displays database table information such as number of rows, table size, etc.
- Optimize database tables (This plugin will notify you if any tables need optimization)
- Repair damaged database tables, clean and delete database tables
- Show options list and clear and clear options
- Show cron task list, clean and delete scheduled tasks
Pro version
- The options classify according to their “creator”. They can be: plugin options, theme options or WP core options.
- Detect and remove Orphan options. Your ‘wp_options’ table is probably full of Orphan options and thus it could affect the data loading performance of it, which can cause the website to slow down. Clearing the orphan options becomes important.
- Classify database tables based on their “creator”. They can be: plugins table, theme table or WP core table.
- Detect and delete Orphan tables. As for options, you may also have some orphan tables created by plugins / themes that you don’t use anymore. Cleaning the orphan table will reduce the size of your database.
- Classify all cron tasks according to their “creator”. They can be: plugin cron tasks, theme cron task or WP core tasks.
- Detect and delete Orphan cron tasks. After you delete the plugin / theme, some of its cron tasks may still be active causing WordPress to call unknown functions. using pro version, you can detect and clean orphan task
- Search & filter options, filter table, and filter cron tasks based on several criteria such as “name”, “creator”, “value”, etc.
- Get premium support: The team behind the Advanced Database Cleaner plugin will provide fast support as well as technical answers to help you clean your database efficiently
How to Use the Advanced Database Cleaner Plugin
Here I will share the complete steps you can take to clean and optimize the database by deleting Orphan tables & tasks and cleaning the WordPress database & increasing the overall performance of my WordPress blog!
IMPORTANT: Before you start using this plugin, you must back up your WordPress database. You can use the WP-DB Backup plugin to complete database backup or search for other plugins.
By making a backup, it can be used again in case of errors and crashes that result in your WordPress site not running.
So, now that you have backed up your WordPress database, let’s start using the WordPress Advanced Database Cleaner plugin.
You can get the pro version of the Advanced Database Cleaner plugin here . You can also use the free version by following this guide, but only for basic optimization. However, the deep optimization feature only comes with the premium version. And here I will make a special tutorial for the Pro version.
Now please install the plugin & activate it. You will see a new menu item added in the left sidebar with the name “ WP DB Cleaner “.
Click the menu and click on the menu tab ” License “. Enter the license key and click the ” Activate license ” button.
General Clean-Up
Click on the “ General Clean-Up ” tab and tick what you need to get rid of. I suggest following the image below.
Important : Make sure you don’t tick ” Drafts ” & ” Pending comments “. Because those are posts that you still save as drafts and comments that you haven’t approved of.
From the drop-down menu, select ” Clean ” & click ” Apply “.
When the pop-up appears, click “Continue” & in a few seconds, this powerful database optimizer plugin will clean up your database.
Tables
Open the ” Tables ” tab to begin the process of finding orphan tables.
Click ” Scan tables ” and the scan will take some time depending on the size of your database.
After you finish scanning the tables, you will start to see the Orphan Table displayed, and select Orphans at the top to filter out only specific Orphan tables.
Most of the table names are based on plugins you have used in the past, so it will be easy for you to decide whether to delete the table. If you are unsure, then simply delete the ones you believe in.
After that, please tick what you want and Delete then click Apply .
After you are done cleaning up Orphan Tables, it’s time to move on to orphan options.
Options
Click on the ” Options ” tab & click on ” Scan options “.
If you are scanning an old blog database, you will probably find that many orphans options are displayed. For example, my blog has about 326 orphans options. That many tables were created by plugins that I used in previous years and I no longer use them.
After that, I checked everything and select ” Delete ” and ” Apply “.
Cron Jobs
When done, click on the ” Cron jobs ” tab.
Please click Scan Tasks and select Orphans at the top. Select ” Delete ” and ” Apply “.
And that’s all the things you need to do with the WordPress Advanced Database Cleaner plugin. After doing all this, your database will be completely cleaned up & you should be able to see a difference in the performance of your WordPress blog.
Cleaning up your WordPress blog database is an important part of the optimization of your WordPress site to improve WordPress performance so that it is faster. This is one of those activities that WordPress users rarely do and you should do this to get your WordPress site up and running quickly. Hopefully this article is useful and good luck. 🙂
