PHP 5 and later can work with a MySQL database using: MySQLi extension (the 'i' stands for improved) PDO (PHP Data Objects) Earlier versions of PHP used the MySQL extension. When you Google this problem, the recommended solution is running a daemon or cronjob that monitors the processlist and just kills the long running queries. This means your PHP scripts and MySQL connections can be blocked as long as a query runs, worst case for several minutes or hours. nnect_timeout '60' PHP_INI_ALL : For further details and definitions of the PHP_INI_* modes, see the Where a configuration setting may be set. The MySQL connection part is coded by others and seems copy from phpBB. And they blame us why don't set timeout in the program. In reality, we've such server hang many times and everytime, the hosting company claim that the reason is the MySQL has too many queues jam in there. Today the server (PHP, MySQL) no response. In fact, with persistent database connections, the database connections are shared between requests, and can therefore be rather long lived. Turns out that connection timeout only times out the phase where PHP establishes connection to MySQL server and it doesn’t affect the queries at all. If the application is not handling connection management optimally and not closing connections it is no longer using, MySQL Server will be closing those connections due to idle-timeout (Fatal error: Uncaught exception ‘PDOException’ with message ‘SQLSTATE Connection timed out), Most often connection timeout error happens because of an application bug, a network timeout issue (on a router, firewall, switch etc.) or may be due to MySQL restarting. The unit of the parameter value is seconds. Once PHP has enabled MYSQLND extensions, just set _read_timeout in the php.ini file. The first way to set the MySQL query timeout is to use MYSQLND. This setting is applicable only for idle sessions and your running queries will never be interrupted. Wait_timeout: If you notice most of the clients connected to MySQL are doing nothing but just stay connected, We strongly recommend to reduce wait_timeout variable for avoiding situations causing bottleneck for other client connection requests.

Increase connection timeout sequel pro