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, because every day it grows without us realizing it. The lighter the database is, the more speed we will have in our site.

To start optimizing our database, we must go to our hosting and then to phpMyAdmin of MySQL. That is the database management system, but we must know the name of our database because we can have several.

What is WordPress, what is it for and how does it work?(Opens in a new browser tab)

So we're going to go to our public_html of our hosted site and we 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 one of DB_NAME. There will appear our database name.

Knowing which is the name of our database, now we enter our hosting.

And now we get a list of our database, just 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 phpMyAdmin of MySQL and then we should see the tables of the WordPress installation:

To optimize the tables we can select all of them and then select the option of repair boards y optimize tables. If we also want to remove the comments we look for the table wp_comments and click on empty. This process can be done once a month.

Buy Hosting and Domain To Create Web Pages TOP(Opens in a new browser tab)