July 14

How to Clean Up Your WordPress Database for Improved Performance

Even if you are a novice with WordPress themes you still may have heard about the necessity of cleaning your MySQL database from time to time. Your site’s database must be constantly cleaned because once one day it will swell to such an extent that our hosting it simply will not stand such mess. The database of your site is usually growing every day, with an increase in posts that you write, respectively, and increased database. Always observe and try to do so that the database is weighed as little as possible. Now you are not very clear about what it is I do write. Read on and all will understand.

Where is the garbage in MySQL database stored?

Now you will be much clearer and will understand that it is necessary to remove from the database of your WordPress theme. Why does the garbage appear in the first place?

Increased number of articles on blogs;
Increased number of backups of your posts and articles;
Increased number of comments on blogs and in the comment spam;
Due to the installed plug-ins on blogs;
Because of the large number of pingbacks.

Weight gain of the database is usually provoked by writing a large number of articles - this is normal, and so it is clear that our articles have a certain weight, and more of them, the more space they occupy in your WordPress theme’s database.

But if not disabled on blogs backups or they are not cleared, then the weight of the database becomes 2 times longer (at least). When writing an article, there are automatically saved drafts in certain intervals. And how much can be saved, these drafts? Imagine that one article remained, well, let's say 3 drafts (this is a real number). And if you have 200 articles on blogs and you never cleaned database, imagine that there is a horror to happen in your WordPress theme’s database.

WP-Cleanup plugin for database’s optimization and cleaning

The plugin WP-Cleanup does the following:

deletes all audit posts;
deletes from the database all the spam comments;
remove all unapproved comments the author of a blog;
removes all unused tags in your WordPress theme;
removes all unused meta-information blog;
optimizes MySQL database, removing unnecessary data.

Not bad, right? You just have to note a flag that requires optimization, and press the button “Cleanup the selected items!” Before cleaning, add the form of a pie chart and a table showing the number and occupies a volume (in kilobytes, and percentage) clearly show how much has accumulated in your database.

Before starting WP-Cleanup to work, create the complete backup. This can be done by means of phpMyAdmin available in the control panel of your host or using special plugin for cleaning up WordPress themes - WP-DBManager. Use our specialized team to perform all of described actions on the professional level.