Solution to phpmyadmin timeout or slow response_PHP Tutorial

I analyzed that there are two reasons why phpmyadmin times out or responds slowly. The timeout means that the setting time is not enough. The default is 1800 seconds. The slow response is probably caused by phpmyadmin automatically checking for updates. Let me solve the operation method in detail.

I installed the latest version of phpmyadmin today. After installing it and testing it, I found that the response was occasionally very slow. I checked the nginx log and found that the fastcgi connection timed out. 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:240

The problem is obvious. phpmyadmin is constantly checking and updating 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

The code is as follows

代码如下	复制代码
下面添加 exit;

Copy code

Add

below
exit;

Save the test and the slow response problem is solved.

Let’s look at the second problem, which is the phpmyadmin timeout problem

The default timeout of phpMyAdmin is 1800 seconds, which is too short

During the development process, I wrote a few lines of code and when I came back and looked at the database, it timed out. Logging in repeatedly is annoying.

Modification method:

Open phpMyAdmin/libraries/config.default.php

Find $cfg['LoginCookieValidity'] = 1440; line Turn up the 1440 and it will be ok http://www.bkjia.com/PHPjc/633194.html

www.bkjia.comtrue

http: //www.bkjia.com/PHPjc/633194.htmlTechArticleI analyzed that there are two reasons why phpmyadmin times out or responds slowly. The timeout means that the setting time is not enough. The default is 1800 seconds. , and the slow response is probably caused by phpmyadmin automatically checking for updates. Below I...