How to Optimize your WordPress Database with WP-Optimize

In this article, we will teach you how to use the WP-Optimize plugin to fully optimize your WordPress database quickly and easily.

Installing the WP-Optimize plugin

1. First, you will need to log into your WordPress dashboard.
2. 

   Now that you are now inside your WordPress dashboard, you will need to locate the WP-Optimize plugin. To do so, look to the left side menu bar and click on Plugins then on Add New. Here you will see a search box. Enter “WP-Optimize” here to search for it within the WordPress plugin database. The plugin you are looking for should be the first result.

3. 

   Now that you have located the WP-Optimize plugin, click on Install Now. WordPress will now take care of the download and installation process for you. Once complete, click on Activate Plugin to ensure that it is running on your WordPress site.

Optimizing your WordPress database with WP-Optimize

1. Before making any changes, you will want to back up your database just to be sure that if anything goes wrong, that you have a fully working copy already available.
2. 

   Now, take a look to the left side of your dashboard and click on WP-Optimize. Here, you will see the full optimization panel with various database optimization options. The ones listed in red can potentially break things so you may use these at your own risk. Of course, as you have made a backup of your database in the previous step, you can always restore it if anything goes wrong. Once you have selected your preferred options, click Process.

Automatically optimizing your WordPress database with WP-Optimize

Within the WP-Optimizer plugin, you may also set it to automatically optimize your WordPress database. To do so, click on WP-Optimize to the left side of your WordPress dashboard, then click on the top Settings tab. Here, you will see a column labeled Auto Clean-up Settings. To enable automatic cleanup, click the checkbox labeled Enable scheduled clean-up and optimization, select your options for what you want automatically cleaned up, then click on Save auto clean-up settings. Your WordPress database will now be optimized according to your schedule that you have set.