Clean WordPress Database With Advanced Database Cleaner Plugin [Tutorial]

0
0


Deep-Clean & Speed up WordPress Database

Is your WordPress weblog appearing slowly on a quick web hosting corporate?

It might be as a result of your bloated WordPress database. This will also be mounted with a excellent database optimization plugin.

When it involves cleansing the database of WordPress, we’ve many nice choices like WP-Sweep, WP-Optimize, and WP-Db Manager. These plugins transparent the overload, optimize the database & in-turn make your WordPress weblog carry out quicker.

However, none of them blank the unused tables, duties & choices left by means of plugins that you’re now not the usage of.

  • Do you already know that even while you delete a plugin, it doesn’t blank the whole thing that it added onto the database?

I’ve already advised you about deep-cleaning your WordPress database in an previous submit.

Recently, I used to be operating on optimizing my primary weblog’s (ShoutMeLoud) WordPress database & needed to deep blank the orphan tables & choices. Using current plugins (equivalent to Clean choices) weren’t sufficient and I used to be on the lookout for a loose choice.

This is the place I ran into the Advanced WordPress Database Cleaner plugin which is to be had without spending a dime within the WordPress repo. However, the loose model is proscribed to options which can be introduced by means of different database optimization plugins equivalent to WP-Sweep.

They even have a top class model which made me acquire the plugin ($15 for one web site or $30 for 5 websites).

In this submit, I will be able to provide you with a detailed review of the Advanced WordPress Database Cleaner plugin & display you how you can use it.

How to make use of the WordPress Advanced Database Cleaner plugin

If you simply wish to take a look at out the plugin with restricted options, you’ll be able to obtain the loose model from right here.

If you’re within the strategy of cleansing & optimizing a WordPress database (your web site or your consumer web site), acquire the Pro plugin from right here. Do take into accout, it will possibly take about 5 mins to obtain the e-mail along with your plugin report & license key.

Download the plugin by means of clicking at the hyperlink within the e-mail & set up it manually.

You can get entry to the settings by means of going to Tools > WP DB Cleaner & enter your license key to turn on the plugin.

Activate WordPress database cleaner plugin

Using the plugin

Upon activation, cross to “Overview & Settings” to look the present standing of your WordPress database.

  • Hey, don’t omit to take backup of your database sooner than beginning to blank & optimize!

Before cleaning database

Now, cross to the “General Cleanup” tab & get started the elemental optimization. If you aren’t certain what to do, simply use the settings as proven beneath.

WordPress General cleanup

Cleanup Database

Once that is carried out, click on at the “Optimize” tab to optimize the database. One advantage of this plugin is it displays simplest the ones tables which require optimization.

Optimize WordPress database

Find & delete orphan tables

Click at the “Tables” tab & click on on “Detect orphan tables”.

Depending at the measurement of your database, it’ll take a couple of seconds to turn the entire orphan tables.

detect Orphan WordPress tables

Now, click on at the orphan desk & you are going to see the desk identify which doesn’t belong to any recently put in plugin.

unused tables in WordPress

Warning: This function is for customers who’re neatly conscious about WordPress plugins & simplest for many who are managing their WordPress weblog. Nonetheless, do take a WordPress backup sooner than deleting any desk.

Find & delete choices tables

Now click on at the “Options” tab & very similar to orphan tables, click on on “Detect orphan options”.

Delete WordPress Orphan Options table

And you’ll be able to proceed the cleansing procedure.

Scheduled duties possibility: (Cron duties)

Here you’ll be able to stumble on all scheduled duties & just like the ultimate two choices, use “Find orphan tasks” & get started cleansing up.

Once the whole thing is finished, you’ll be able to merely deactivate the plugin.

You will have to stay optimizing your database as soon as a month & do a deep cleansing as soon as each and every quarter.

Download Advanced WordPress Database Cleaner

Here is a chart that compares function of all widespread WordPress database optimization & cleanup plugins:

Comparing WordPress database cleanup plugin

Do let me know which WordPress database optimization plugin you’re the usage of.

If you’re additionally a consumer of the Advanced WordPress Database Cleaner plugin, let me know your enjoy.

You will have to additionally take a look at our WordPress plugin archive to seek out many different helpful WordPress plugins.

Harsh Agrawal from wpsutra.com

Changer.com - Instant Exchanger

LEAVE A REPLY

Please enter your comment!
Please enter your name here