#44555 [Opn->Fbk]: mysql.connect_timeout ignored

From: Date: Mon, 14 Jul 2008 16:57:09 +0000
Subject: #44555 [Opn->Fbk]: mysql.connect_timeout ignored
References: 1  Groups: php.bugs 
Request: Send a blank email to php-bugs+get-126673@lists.php.net to get a copy of this message
 ID:               44555
 Updated by:       uw@php.net
 Reported By:      tstarling at wikimedia dot org
-Status:           Open
+Status:           Feedback
 Bug Type:         MySQL related
 Operating System: Windows XP
 PHP Version:      5.2.5
-Assigned To:      
+Assigned To:      uw
 New Comment:

Does the host 1.2.3.4 exist? If not, you're probably running into the
default DNS lookup timeout of your system -> bogus, not a bug. Try
changing your system settings,
http://www.microsoft.com/technet/prodtechnol/windows2000serv/reskit/regentry/96406.mspx?mfr=true


Previous Comments:
------------------------------------------------------------------------

[2008-03-28 09:03:03] tstarling at wikimedia dot org

Description:
------------
mysql.connect_timeout is ignored, a fixed timeout of 20s is used.
Observed on PHP 5.2.5 WinXP, not observed on PHP 5.1.4 Linux.

Reproduce code:
---------------
print mysql_get_client_info() ."\n";
ini_set('mysql.connect_timeout',1);
$t = -microtime(true);
mysql_connect('1.2.3.4');
$t += microtime(true);
print "$t\n";
ini_set('mysql.connect_timeout',100);
$t = -microtime(true);
mysql_connect('1.2.3.4');
$t += microtime(true);
print "$t\n";


Expected result:
----------------
5.0.45
1.00128006935
99.9788169861

Actual result:
--------------
5.0.45
20.9900009632
21.0206007957



------------------------------------------------------------------------


-- 
Edit this bug report at http://bugs.php.net/?id=44555&edit=1



Thread (8 messages)

« previous php.bugs (#126673) next »