WordPress Optimize Database

WordPress Optimize Database

July 10, 2019 By Jake

Do Something Great – Optimize your WordPress Database

This is the first post in a planned series called “Do Something Great”.  This series is designed to assist the “Do It Yourself” WordPress users. We will cover a series of topics that will assist you in optimizing your WordPress site.

As with anything you do, it is advised you make a backup of your site before starting any optimization task, just in case.

This is the first post in the series because you will need to optimize your database after every one of the tasks we will cover in this series.

The Database is the Engine to your WordPress site

WordPress, like any other CMS (Content Management System), is highly dependent on the database. Your posts, pages, categories, settings and much more are stored in the database. It is the engine that runs your site.

Just like the engine in your car, this engine requires maintenance, tune-ups, and oil changes.  This will keep the engine running smoothly.  If maintenance is not done on a regular basis, it is more likely the engine will fail at some point in time. And when it fails, it will be costly.

In future posts, we will cover “trimming the fact” in the database by removing obsolete items.  In this post, we are going to just cover the optimization routine. There are a few different ways to do this.  We are going to cover the method using phpMyAdmin and also using a plugin called “WP-DBManager“.

Optimize your WordPress Database using phpMyAdmin

This is a method that anyone who has a WordPress site should learn.  Using a plugin is easy, but if the site does not load, you will need to know how to do this from phpMyAdmin.

Depending on the server configuration you are on, there will be different ways to access phpMyAdmin.  For most, it will be through cPanel.  You can always check with your host if you have problems finding the access point.

Once you are in phpMyAdmin, you need to select on the left-hand side the database you want to optimize.  Then “Check All” and choose “Optimize Table” as shown in the image below.

We do recommend that you check with your host, they should have a Knowledge Base article on this procedure.

Optimize your WordPress Database using “WP-DBManager” plugin

We will install and configure this plugin for you when you use the Timber-Boot theme. If you need to install it yourself, you can download it from here. The nice part of this plugin is that you can schedule the optimization to be automatic and/or do it on demand.  The plugin also has excellent documentation also.

When you have finished, make sure to clear any cache you have installed.

So do something great and optimize your WordPress database.

As always, if you have any questions or comments, use the “Contact Us” button in the footer of this website.