WP Optimize plug-in installation tutorial WordPress database optimization effect is obvious

Everyone who plays WordPress knows that, Wp itself is a relatively large php program, especially in terms of database, When writing an article, the wp article editor will automatically save it as a revised version on a regular basis in case of accidents. When your article is finished, the saved article fragments will always be saved in the database, which will become a burden on wp's work efficiency. The cleanable parts in the wp database include but are not limited to the following: revision, draft, automatic draft, pending comments, garbage comments, recycle bin comments, isolated article meta information, isolated comment meta information, isolated relationship information, and dashboard subscription cache. In order to improve the efficiency of the database, we must use a wp database optimization plug-in. After many choices, Weieis Blog uses the WP Optimize plug-in to complete this work. Let's talk about it today WP Optimize plug-in Install the tutorial.

Explanation of related terms found on the Internet:

Revision: After the article is modified, there will be an unmodified version. In addition, a revised version will be generated at regular intervals during the article writing process.
Draft: when writing an article, click Save Draft to save it. In addition, customized menus may also generate drafts.
Auto draft: It is generated when you click "Write Article" and "Create Page". Each click will generate one.
Orphan Postmeta: information left in the wp_postmeta table after an article is deleted.
Orphan Commentmeta: the information left in the wp_commentmeta table after a comment is deleted.
Orphan Relationships: information left in the wp_term_relationships table after deleting articles, comments, etc.
Dashboard Transient Feed: The subscription cache displayed on the homepage of the dashboard is saved in the wp_options table, which is large in number and volume. It is recommended to remove those subscriptions from the "Display Options" on the top of the homepage of the dashboard.

WP Optimize is currently free to use. If it works well, you can also donate to the author. At present, this plug-in is partly Chinese, not complicated operation mode, and the control panel combining Chinese and English can also be fully understood.

In Plug in - Install Plug in in the wp management background, enter WP Optimize and search. The result is as shown in the following figure. Click Install Now and enable the plug-in.

After the installation is completed, WP Optimize will appear under the background settings of wp. Now let's see that this plug-in is mainly divided into two parts: manual optimization and periodic optimization.

2.1 To manually optimize the database, click the blue button Run all selected priorities in the figure below, where you can optimize all tables in the database. This function is the same as the "Optimize Table" function in phpMyAdmin, which saves phpMyAdmin.

The optimization effect can be found in the Current database size: 1.6 MB You can save around: 32 bytes can be seen here.

The details of plug-ins are very good. You can also manually optimize each project one by one.

There are still some screenshots below that I don't have. The part shown in red text is frequently used for database operations. During the cleaning process, the database may be damaged due to various unexpected circumstances. The plug-in prompts that you need to do a good job of database backup before cleaning. By default, the part that is not checked needs to be checked and cleaned by yourself.

The WP Optimize plug-in also provides details of all tables in the website database, as shown in the following figure. You still remember this article MySQL database type is converted from InnoDB to MyISAM No, it was from here that Lao Wei found that the type of the website database table did not match, which was also a windfall.

2.2 Regular optimization of WP Optimize plug-in

Set the plan scheme. You can set how long to keep the data ， How often is the automatic cleaning performed? The default is weekly. The optional time is daily, weekly, fortnightly, and monthly. If the comments are cleaned up too frequently, they will be cleaned up before they can be reviewed, or they can be set to automatically clean up fortnightly.

Then check the content to be cleared below. By default, Optimize Database, Delete Revision Record, Auto Draft and Garbage Comments have been checked. Do not check "Delete Uncleared and Unapproved Comments" to prevent accidental deletion.

Finally, saving the settings can automatically optimize the database and delete garbage data on a regular basis.

How to optimize and improve the speed of WordPress is an eternal task. To make the website load faster, the key to optimization is to find a balance point, Click me to open The online course starts to learn, comprehensively analyze the reasons and provide a corresponding set of solutions.

To sum up, the function of the WP Optimize plug-in is quite practical. If you haven't cleaned up the wp database for a long time, the cleaning effect of this plug-in is still significant once, which can significantly reduce the size of the database and improve the efficiency of the database. And it is simple to set up. To save some worry, use the regular cleaning function; If you want to save wp resources, you should first disable this plug-in. Open it before use, run manual cleaning, and then stop it after completion. This does not occupy wp resources and server resources.