Have you ever done the optimization and cleaning of the Database of your WordPress site? Optimizing the database clears tables of unnecessary garbage, which as a result reduces the volume of the database and improves its performance.
In this lesson we will show you how to easily and quickly optimize your WordPress site’s database with the free WP-Optimize plugin.
Why do I need to optimize the site’s database on WordPress?
If you use WordPress for a long time, then for sure there are a lot of extra garbage in your database, for example: old versions and post revisions, spam comments, deleted comments and posts, irrelevant meta-data, etc.
All this increases the size of the database, which leads to an increase in the time it takes to create backups and restore them from backup copies.
See also :
Clearing the database of excess garbage significantly reduces its size, which means that backups are done faster and the performance of the database itself increases.
A simple example: the revision of posts only increases the database size by more than 2 times. If you have already deducted and published the post, why should you store all of its previous revisions in the database?
Since we will carry out operations on the Database, it would not be a bad idea to first make a backup as a precaution.
Now we will install the free plug-in WP-Optimize :
This is a popular and free plug-in from the same developers that created the famous backup plugin UpdraftPlus .
After installation and activation, go to the new section in the WordPress admin panel, which is called WP-Optimize:
You will see a list of operations that the plug-in will produce from your database. You can, at your discretion, put on or take off the tick marks from operations that you do not want to perform.
Be extremely careful with the items marked in red. These are operations that create an intensive load on the database, and if the process is interrupted during the execution of such an operation, this can damage the data. Therefore, these operations are not marked by default.
After selecting all the necessary operations, just click the button Run on all selected items at the top, and the optimization process starts.
When all operations are completed, you can see the statistics in the box on the right:
That’s it, you’ve successfully optimized your WordPress database!
Note: : If your MySQL database uses InnoDB format tables, such tables will not be optimized. WP-Optimize will simply skip them when performing operations. But you can optimize such tables manually using phpMyAdmin.