MySQL server is disconnected after 60 seconds

The background of the problem An error encountered an error during a good SQL query before, and the error was overtime after 60 seconds and a error was thrown. Although the query is very slow, it runs as part of the night mission, so this is not a problem in itself (so do not recommend that I optimize it). Questions details

I reproduce the error by running the error from PHP's running "Select Sleep (120); (see below). The statements will be successful (returned 0). I think it is likely to be a problem, not the problem of resource restrictions. 36-COMMUNITY

PHP 5.3

test code, output and Show variables

[test code, output and Show Variables results in the result. Omitted here]

pHP option mysql.connect_timeout_timeout is the root cause of this problem. A response, you can add it like this:

ini_Set ('mysql.connect_timeout', 300);

ini_Set ('default_socket_timeout', 300);