WordPress Database Ko CleanUp Karke Performance Better Banaye

 

Share

When someone creates their blog for the first time on wordpress, then they delete / upload new plugin and themes every day. Do you know that when we install the plugin in our site, it adds its data to our site database. This causes the performance of our site to be down. We are going to talk in this post how to clean the database in wordpress?

It is very important to mainten the performance of our site. Because if the performance of our site is poor, then the speed of the site will be down, and this also reduces the search ranking. All the big bloggers are not only writing posts in their blogs, but they are very serious about the security and performance of their site.

When it comes to the performance of a WordPress site, we have some plugins, themes and great hosting in our mind. Normally, in the present time every hosting company is engaged in making itself better, that is, the performance of the hosting is better and everyone wants that the look of his blog is good, then they use the best theme for him. . Now talking about the plugin, today we are going to tell you about a very good plugin so that you can increase the performance of your site by cleaning your site's database.

We have already told you that when we install or uninstall a plugin or theme in our site, its data remains saved in our database. When the size of our database increases, then gradually the speed of our site starts decreasing and the site down. So we should keep the database clean up.

We will tell you a small example of this that when we run a new software in PC, then many new files come there automatically. Similarly, when our blog runs in our hosting, new files are created in the database.

We are telling you below what types of files are created in the database and why.

Post Revisions: When we edit or update the post in our blog, it adds revisions to the database. If you continuously edit posts, more revisions will be added to your database and this will increase the size of your site database. Cleanup it and reduce the DB size.

Auto Drafts: When we save a post or page in a draft in our wordpress site, it gets added to the database.

Deleted, Unapproved and Spammed Comments: When we write a post in our blog, users comment on it and tell their thoughts. When a spam comment comes and you delete, you think that it has been completely deleted, then you are wrong. Because if we spam or trash a comment, it is added to our database. It is also necessary to clean it.

Trashed Posts and pages: If we do a post or page, it is saved in our database. It is also very important to clean it.

Deleted Plugins and Theme: If you have uninstalled again by installing Plugin in your blog, then tell me one thing that its data will still be saved in your database. For better performance of your site, it is very important to clean it.

Database Table: There are many types of data in our site database and all these are devided into tables. When you install many plugins, it creates its own custom table and sometimes if you uninstall the plugin, its data is not deleted. Therefore, it is also necessary to cleanup it.

It is very important to cleanup / optimize all the database files we told you about above. Because all this data is of no use and this increases the size of the database, due to which the performance of our site starts to decline.

We are going to tell you about optimizing the database here. It is difficult to manually optimize it and only the developer can manually optimize it. Mostly, Bloggers only use the plugin for this. You will get many database cleaner plugin. We are going to tell you about a great plugin in this post that can improve performance by cleaning your database.

When we talk about database cleaner plugin, many plugins are named. In this post, we will tell you about how to clean database with WP sweep plugin. I also use this plugin personally and many people use this plugin only.

Before optimizing the database, we would like to give you an important information that you should backup your database before following the steps below. For this you can use WP DB Backup plugin. Read this for backup manually. Manually WordPress Database Ka Backup Kaise Lete Hai.

Step 1: First install and activate the WP Sweep plugin in your WordPress.

Step 2: Now Dashboard »Tools» Sweep Go to Now we are telling below what to do.
Post Sweep:

From here you can find Revisions, Auto Draft, Deleted Posts, Duplicate Meta etc. You can clean To clean it in front of Sweep Click on the button.

Comment Sweep:

Here you can cleanup Unapproved Comments, Spammed Comments, Deleted Comments, Orphaned Comment Meta, Duplicate Comment Meta. Next to clean it Sweep Click on the button.

User Sweep:

If multi user work in your blog then it is very important for you to clean it. If there is no faltu user data in the database of your blog, then there will be N / A in front of it. If there is extra data Sweep Button will show, click on it and optimize.

Term Sweep:

From here you can access your blog database like Term Taxonomy, Term Relationships etc. You can clean up the extra data. There were no term meta in my blog, so N / A is coming next. If you will be in my blog then Sweep Button will show. Clean up the term meta by clicking above.

Option Sweep:

Our wordpress site database contains meta with options. When installing the plugin in our site, many of the plugins create their own option and when delete it, the option is not deleted. Therefore it is important to clean it. Next to you Sweep You can cleanup it by clicking on the button.

Database Sweep:

You will know that there are many folders in the database also, which are called tables. There are many extra tables in our database, which is very important to optimize. To optimize it Sweep Click on the button.

The last one will have another button named Sweep all is. Through this, you can sweep or cleanup all the data in your database in one click. After clicking on Post Sweep, Comment Sweep, User Sweep, Term Sweep, Option Sweep and Table Sweep will all start running.

---

In this way you can clean up the database of your wordpress site. Apart from this, there are many plugins like WP Optimize, Advanced Database Cleaner. All this plugin is also good, but all the professional bloggers are those who use WP Sweep and also recommend it.

If you have any question, then comment. If you like the post, share it on social media.