#44555 [Com]: mysql.connect_timeout ignored
| From: | tstarling at wikimedia dot org | Date: | Tue, 15 Jul 2008 15:27:20 +0000 |
| Subject: | #44555 [Com]: mysql.connect_timeout ignored | ||
| References: | 1 | Groups: | php.bugs |
| Request: | Send a blank email to php-bugs+get-126773@lists.php.net to get a copy of this message | ||
ID: 44555
Comment by: tstarling at wikimedia dot org
Reported By: tstarling at wikimedia dot org
Status: Feedback
Bug Type: MySQL related
Operating System: Windows XP
PHP Version: 5.2.5
Assigned To: uw
New Comment:
No of course the host "1.2.3.4" doesn't exist, it's an IP address in
the unused 1.0.0.0/8 block reserved by ARIN, that's the point.
If I instead use a hostname for a host which responds to DNS rapidly,
but drops ignores SYN packets on the port in question (such as
www.google.com), the result is the same.
Are you asking me this question because you've tried it and can't
reproduce it? If so, maybe I can help to isolate the configuration.
Previous Comments:
------------------------------------------------------------------------
[2008-07-14 16:57:08] uw@php.net
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
------------------------------------------------------------------------
[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