note 93312 added to mysqli.mysqlnd

From: 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

« previous php.notes (#160164) next »