How to solve the problem of occasional slow response of phpmyadmin

This article introduces that in the actual production environment, phpmyadmin occasionally responds very quickly, resulting in a large number of edge connections in the wait state. This article gives a solution for your reference.

I installed the latest version of phpmyadmin, but found that the response was occasionally very slow. Check the nginx log and find that the fastcgi connection timeout is reported.

Then open the slow log of fastcgi and find the following error:

[10-May-2013 11:15:16] [pool www] pid 10992 script_filename = /usr/share/nginx/html/phpmyadmin-1688/version_check.php [0x0000000002902e78] file_get_contents() /usr/share/nginx/html/phpmyadmin-1688/version_check.php:24

As can be seen from the above code, the reason is: phpmyadmin continuously checks and updates the version, and the domestic server is extremely slow to connect to the phpmyadmin server, and may not be able to connect, which leads to a timeout.

Solution: Edit the version_check.php file, in

Don’t let it detect version updates, so that it won’t always be in a waiting state for connection, and the problem will be solved naturally. For friends who encounter similar problems, it is recommended to read more nginx or fastcgi logs and quickly find solutions. Articles you may be interested in: How to import and restore large sql files with phpMyAdmin wampThe solution when opening phpmyadmin prompts "The mysqli extension is missing. Please check the PHP configuration." phpmyadmin installation error, several solutions for missing mysqli extension phpMyAdmin cannot load the mysqli extension, please check the PHP configuration for solutions Solution: phpmyadmin is missing the mysqli extension. Please check the PHP configuration problem Solution to Chinese garbled characters in MySQL and phpMyAdmin Solve the problem of Chinese garbled characters when importing and exporting with Phpmyadmin implementation code for php to import sql exported by phpmyadmin Solution to phpmyadmin not being able to import large SQL files Solution to the problem when phpmyadmin imports large database files