note 93312 added to mysqli.mysqlnd
| From: | eric dot caron at gmail dot com | Date: | Wed, 02 Sep 2009 16:59:39 +0000 |
| Subject: | note 93312 added to mysqli.mysqlnd | ||
| Groups: | php.notes | ||
| Request: | Send a blank email to php-notes+get-160164@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.
----
Server IP: 64.71.164.2
Probable Submitter: 209.23.129.248
----
Manual Page -- http://www.php.net/manual/en/mysqli.mysqlnd.php
Edit -- https://master.php.net/note/edit/93312
Del: integrated -- https://master.php.net/note/delete/93312/integrated
Del: useless -- https://master.php.net/note/delete/93312/useless
Del: bad code -- https://master.php.net/note/delete/93312/bad+code
Del: spam -- https://master.php.net/note/delete/93312/spam
Del: non-english -- https://master.php.net/note/delete/93312/non-english
Del: in docs -- https://master.php.net/note/delete/93312/in+docs
Del: other reasons-- https://master.php.net/note/delete/93312
Reject -- https://master.php.net/note/reject/93312
Search -- https://master.php.net/manage/user-notes.php