Z-Blog Application Center > PHP plug-in >Zblog MySQL database optimization plug-in

Zblog MySQL database optimization plug-in

  • ID : Amysql_ youhua
  • edition : 3.5.91
  • author : qq9836 ( Author website )  Contact author
  • Official website :
  • system requirements : Z-BlogPHP 1.6.0 Valyria
  • Update Date : 2023-04-01 15:41:22   Updated within three months
  • amount of downloads : five thousand six hundred and twenty-seven
  • Scoring : The average score of 57 people voting is 9.61/10
  • PHP version : 5.2 and higher
  • size : 69KB

Please login

Update log:

Add batch file cleaning function on March 26, 2022

Fix a minor editing bug on April 3, 2022

On June 9, 2022, a problem with the image display on the article page was fixed. The image displayed on the article page normally does not need to be updated

On October 10, 2022, the problem that few pictures of the theme picture list are not displayed will be fixed

On October 21, 2022, a small problem occurred in the modification of the article editing page (this update can be ignored if the article is not manually edited)

The final test conclusions of the plug-in are as follows:

One million data seconds without card opening

Three million data is also opened in one second, but slower than one million

Therefore, it is recommended that the number of articles be controlled within 2 million

Plug in principle:

This plug-in will convert the body field in the database Separated into documents. No longer stored in the database. The database only stores frequently called fields

When the user accesses the page or edits the body, the corresponding document is called to display

Automatically archive when a new article is published

For the speed of file indexing, this plug-in will also distribute all articles evenly to 100 folders

This plug-in is not a purely static plug-in. The page is still dynamic and will not change the original url structure

This plug-in can be compatible with most themes, but it is not guaranteed to be compatible with all themes

 QQ screenshot 20200708174241.jpg

A website with a large amount of data can save a lot of server resources According to user feedback, tens of thousands of yuan can be saved in server fees (he is a website group, and there are many websites)

Idiotic operation. It can be operated without knowing any technology

For the first time, you need to click manually, and the articles will be automatically optimized in the future

In the background core operation part, there are only two buttons. You just need to click them and do something else. The rest of the optimization work will be done by plug-ins

 QQ screenshot 20200708092004.jpg

Three million articles 18.7G data violence test process:

 QQ screenshot 20200708090717.jpg

Before optimization:

 QQ screenshot 20200707211319.jpg

Optimization principle:

Before optimization, briefly describe the principle of optimization

What is the concept of 18.7G? Let's compare the hard disk to a runway (in fact, it is the same as a runway, or a graph)


So 18.7G means that the head must run at least 18.7G of capacity. If the head runs far, it will be slow.

Then optimization is to separate the infrequently called data, and see the effect of separating the content of the article.

It is still the 3 million articles, but the size has directly changed to 349 M

The database shrinks directly 54.8x , can the query speed be slow?

After optimization

 Optimized. jpg

Opening speed after optimization: (It can't be opened before optimization, so there is no comparison chart.)

3 million data text page speed:

 QQ screenshot 20200708092402.jpg

3 million data list page speed:


The speed of the 3 million data list page when the server clears the MySQL query cache (in fact, MySQL has query cache, so the speed is faster than this)

 QQ screenshot 20200708092738.jpg

User feedback (the number of articles by this user is 280000):

Before optimization:


After optimization:


Hello, Z Blog related website has opened the real name system, please log in Bind your phone , and then make comments. Thank you for your support.

ZBLOG Application Center - Application Purchase and Use Agreement

1. Before purchasing an app, you need to confirm whether the app meets your needs. Digital products do not support trial. According to Article 25 of the Consumer Protection Law, the app is a digital product downloaded online and cannot be refunded once it is downloaded and installed after purchase.
2. The application you purchased in the application center, Only the license of the application, and the ownership of the application still belongs to the application provider.
3. An application can only be used for a single account. Without the consent of the website and the application provider, No secondary release, gift, resale, lease, piracy, etc , otherwise we will Permanently close the user account And reserves the right to continue to investigate relevant responsibilities.
4. If The website containing the application is resold or given away, leased, etc. Please purchase the application with a new account or remove the application Otherwise, it will be deemed as violating the use agreement and permanently canceling the right to use the account.
5. Unless otherwise specified, the purchased applications only include relevant use rights and free update services, and the application center and application provider do not provide additional after-sales installation and other services.
6. The risks in your use of the application are entirely borne by the user, including system damage, data loss and any other risks.
seven Users shall not use this app to engage in any behavior that violates laws, regulations and social public order and good customs in any way. Users must bear all legal responsibilities for the possible consequences of their improper use, and the website and application provider will not bear any responsibility.
eight If the application provider and the website find that the user installs the application on illegal websites such as pornography, gambling, drugs and fraud, they will stop the user's use rights and services, and report the user's illegal information to the network supervision department.
9. The website and application providers reserve the right to change, restrict, freeze or terminate your use of certain content without notifying you and assuming no responsibility for you.

Purchasing Guide

1. Please first Registered account , and Sign in Application Center.
2. Directly click "Buy App" and follow the instructions.

Download Guide

1. The buyer logs in on his Z-Blog website, enters the background, and clicks the "Application Center" menu on the left menu bar.
2. On the home page of the "Application Center", log in using the application center registration account.
3. Enter "My Application Warehouse" to see the successfully purchased applications. Click "Download" to download and install them.

Other precautions

1. If you cannot normally access the application center through the background of your own website, please purchase carefully, because this may cause the application to fail to download and install smoothly.
2. If the paid application cannot be downloaded normally, please check Z-Blog and application updates in the background of your website. If you have updated to the latest version and still cannot download, please contact us in time.
3. The local settings may be overwritten when the update is applied. Please make a backup before the update.