How to Optimize Your WordPress Site's Database
In this post we will see how to optimize the WordPress database from our hosting, we must take into account that this process can help the site lighter. We must create a backup before each update and files. It is important to optimize the database, since every day it grows without us realizing it. The lighter the database, the higher the speed we will have on our site.
WordPress works mainly with MySQL database , so sometimes it is necessary to purge unnecessary data, most of the active pages on the internet are made with WordPress, one of the main languages it uses are php and html5.
To start optimizing our database, we must go to our hosting and then to MySQL's phpMyAdmin. Which is the database management system, but we must know the name of our database since we can have several.
We are going to go to our public_htm l of our hosted site and look for the file wp-config.php this file contains the configuration of the connection of our database with WordPress.
If we open it we will see php code, but when we open it we must look for something similar to this; where several methods declared with functions appear, but the one that interests us is the DB_NAME. There our database name will appear.
Knowing what the name of our database is, now if we enter our hosting.
And now a list of our database appears, we only look for the one that corresponds to our site. (This panel is from Hostinger, it should look like any other hosting.)
We access the database in MySQL's phpMyAdmin and then we should see the tables of the WordPress installation:
To optimize the tables we can select all and then select the option to repair tables and optimize tables. If we also want to remove the comments, we look for the wp_comments table and click empty. Ready this process you can do it once a month. It is important to optimize a database since it grows considerably within our hosting, we can also help eliminate unnecessary records.
We recommend: How You Can Completely Repair WordPress Website (Opens in a new browser tab)
Leave a Reply