Top 6 killing ways To Reduce WordPress Database Size To Improve Blog Performance

Hello friends welcome To helprobo as a newbie blogger you always want to improve your WordPress Blog performance so

There are two important components of a typical WordPress installation:

1-WordPress files stored on your server

2-WordPress database

It’s very essential for you to timely cleanup WordPress database and reduce the size. This is a must-have process for every WordPress user to keep the size of their database at minimum and

keep their WordPress blog fast. Over the time your WordPress database have many redundant table, unused records and many entries which you can remove without affecting your website.

This will help you a lot to reduce load on your server and your WordPress performance will

improve. In this tutorial I will take example of helprobo WordPress database which is of size 286.3 MB before cleaning up, and will share exact steps I took to drastically reduce the size of my blog database. You can follow this guide step by step and work on your blog. 

Only few of the points might require technical know-how, and if you find yourself questioning there; feel free to ask

question or skip that step. So, let’s get on with this simple DIY tutorial.

Tutorial: How to Reduce WordPress Database Size

I’m mentioning steps in the series I followed to reduce the database size, and I suggest you to follow the exact methods.

Step 1: Take WordPress database backup

This is most essential step which you need to take before you work on your blog database. In my case I have used my hosting company backup feature (WPEngine backup feature) to take

complete backup of the database and all files. You can use WP-db manager plugin to take

backup of your database file. You can find tutorial over here to learn taking WordPress backup.

My recommendation here is WP-db manager plugin as we will be needing to run few SQL query, empty and drop database tables with this one useful plugin.

Step: 2 Disabled and delete unused WordPress plugin:

Now go through theactive plugin list of your WordPress blog and first disable those plugins which you are not using anymore.

There might be plugins that you use once in a while, So I suggest you can disable them too and install when you need it again.

Our goal for today is to completely optimise the database size. Only disabling will not be of much help here, so make you

also delete those unused plugins.

The reason being is to clean out the database table that are created using those unused plugins. Need some useful plugins?

Basic WordPress plugins for every blog
Must have SEO WordPress plugins

List of plugins that I use here at ShoutMeLoud 

Step : 3Delete all spam comments, trash posts and post revisions:

What ever comments you have in spam folder and trash folder, empty them. Similarly delete all posts from trash folder and delete post revisions. You can use WP-optimize plugin to get this done with one click.

Step : 4 Find and clean orphan table:

Now follow this tutorial and install and use Clean options WordPress plugin to find orphan and unused tables in your database. Using this plugin you can clean all such tables.

This is quite critical step and use it when you are sure of the table names which you are not using. If you are in confusion, I would recommend skip this step.

Note: Deactivate and uninstall the plugin after using it

Step: 5 Remove unused Meta value from Database (Caution: For tech people only)

This is one step which I use once in a year and suggest you to do it only if you are accustomed with PhpmyAdmin. If you have earlier worked on PHPmyadmin, you can simply follow this easy

tutorial and get rid of all unused meta value from database.

This won’t be decreasing down your database size significantly but again this is useful if you are highly determined to clean up your

WordPress database.

Step : 6 MySql Queries to reduce database size

One of the table which is a major cause of increased database size is wp_commentmeta due to Akismet plugin. Before running below mentioned query, my commentmeta size was 146 MB and after that I reduce its size. 

so how was the article If this article is touching your heart so I think you should must share this on social meadia and if you're feeling any problem let me know by commenting and subscribe us for a newsletter.