WordPress is a wonderful blessing to you if you are running your website using it. It is not just a content management system but does a lot more to your website.
WordPress has your website data in its database. All the posts, post revisions, user information, the comments, the data of the plugins you use, and much more form the WordPress database. In short, the WordPress database is your website.
However as your website continues to exist, the database can become bloated over the time. The comments, the post revisions, signatures left by the plugins you use and the ones you used, etc. build up over the time.
A bloated database directly affects the loading speed of a website because as the size of the database increases, your server struggles a lot to find the information every time.
Every time a user accesses your website a lot of information is accessed. And if your website is light, it will be easier for the server to access and present that information to your reader.
If it is bloated, the server has to go through a lot of unwanted information to access the necessary information; and this is certainly going to take longer!Optimize your WordPress database with WP-Optimize pluginClick To Tweet
Introducing WP-Opmitize plugin
When it comes to cleaning up or optimizing database, PhpMyAdmin can be a big set back for many users. Not all are familiar with the stuff one sees at PhpMyAdmin.
With WP-Optimize you don’t have to worry about going through tough things to optimize your database. You can do that right within your WordPress dashboard, with a very few clicks in fact.
Much of the stuff is already done for you. You just have to remember to optimize your database by running the WP-Optimize plugin (just pressing the button) once in a while.
I do it once in a fortnight. Sometimes, I just forget and do it once a month. If you are forgetful like me, you can set up the plugin to do auto cleaning (scheduled cleaning).
It depends on how busy your website is. If you publish a lot of blog posts and/or if you get a lot of comments, chances are that your database gets bloated very soon.
So you might have to increase the frequency of cleaning accordingly.
Let’s see how to use WP-Optimize plugin to optimize your database
Inside your WordPress dashboard, go to Plugins > Add New. And then search for WP-Optimize.
And then, click on Install Now as shown below.
Activate the plugin.
Now, the plugin is installed on your website. In your WordPress dashboard, on the left, look for WP-Optimize and click it.
You will now see the options on what to clean up. You should let the default ticks as such, unless you really know what you are doing.
Whenever you click on the big blue “Process” button, the plugin will do the clean up for you. Of course, what the plugin cleans depends on what options you have selected.
In general WP-Optimize can do the following stuff:
- Clean up trackbacks (can also enable/disable them)
- Clean up post revisions
- Clean up post drafts
- Remove trashed comments
- Remove unapproved comments
- Clean up auto drafts (I don’t have this enabled)
- Clean up all ping backs
- Clean up transient options
And much more (you can even enable/disable comments and trackbacks in this plugin’s settings page). For your convenience, in the plugin settings page, you will see certain items in red.
There is a notification on the page saying that you should NOT select the items marked in Red unless you know what you are doing.
And in general, you have to make sure you take a backup of your database before optimizing.
In the settings page there are 4 tabs. Let’s go through them one by one.
In this tab you can choose to do the following stuff:
- Clean all post revisions
- Clean all auto drafts and posts in trash
- Remove spam comments and comments in trash
- Remove unapproved comments
- Remove transient options
- Remove ping backs
- Remove trackbacks
- Optimize database tables.
This page lists all the tables in your WordPress database. You can also see their overhead space consumption in this page.
On this page you can do quite a bit of stuff.
You could enable auto cleanups; that is, schedule cleanups periodically. It could be daily, weekly, fortnightly, or monthly – however you want it to be.
You could choose to keep last “X” weeks’ data when doing the cleanup (both auto and manual).
You could enable/disable comments and trackbacks.
For the scheduled cleanup you could fine tune options like removing auto revisions, auto drafts, spam comments, unapproved comments, transient options and general database cleanup – all on autopilot.
You could also choose to be notified once an auto cleanup is done. How cool!
Don’t forget to optimize your WordPress database
As I said already, a bloated database will slow down your site and will also cause poor user experience. And, over the time, your database WILL get bloated as you add information to the site and as people visit and leave comments.A bloated database will slow down your site. Optimize your WP database regularlyClick To Tweet
So don’t take this lightly. You have the scheduled optimization option with the WP-Optimize plugin. Use it.
Let me know how it goes with database optimization.