note 93312 modified in mysqli.mysqlnd by danbrown
| From: | danbrown@php.net | Date: | Sat, 07 Nov 2009 19:00:48 +0000 |
| Subject: | note 93312 modified in mysqli.mysqlnd by danbrown | ||
| References: | 1 | Groups: | php.notes |
| Request: | Send a blank email to php-notes+get-162544@lists.php.net to get a copy of this message | ||
One important part of the MySQL Native Driver, which is overlooked, is that when connecting to MySQL
via a socket, the connection is subject to the "default_socket_timeout" value.
This means that if you have the default_socket_timeout set to 60 (default value), and you have a
query that takes longer than 60 seconds to respond, the connection will be severed and getting the
query results will fail.
The solution (as of PHP 5.3.0) is to change default_socket_timeout to -1 in php.ini, or with
ini_set.
--was--
One important part of the MySQL Native Driver, which is overlooked, is that when connecting to MySQL
via a socket, the connection is subject to the "default_socket_timeout" value.
This means that if you have the default_socket_timeout set to 60 (default value), and you have a
query that takes longer than 60 seconds to respond, the connection will be severed and getting the
query results will fail.
The solution (as of PHP 5.3.0) is to change default_socket_timeout to -1 in php.ini, or with
ini_set.
http://php.net/manual/en/mysqli.mysqlnd.php