Edit report at http://bugs.php.net/bug.php?id=54212&edit=1
ID: 54212
Updated by: kriscr...@php.net
Reported by: kriscr...@php.net
Summary: Localhost resolves much more slowly than 127.0.0.1
on mysql_connect()
Status: Feedback
Type: Bug
Package: MySQL related
Operating System: Windows
PHP Version: 5.3.5
Block user comment: N
Private report: N
New Comment:
I'd be happy to take a look over the weekend. I'll run the test script and
post the results when I get a spare moment.
Previous Comments:
------------------------------------------------------------------------
[2011-06-03 19:39:12] paj...@php.net
Please try using this snapshot:
http://snaps.php.net/php5.3-latest.tar.gz
For Windows:
http://windows.php.net/snapshots/
------------------------------------------------------------------------
[2011-03-10 11:06:33] kriscr...@php.net
I'm sorry guys, I realize this report is very scant on details. Please keep in
mind I'm reporting it on someone else's behalf at their request. I posted all
the details I've been given and have requested further information, which I
will post here as soon as I get it.
I possibly should've waited, but I'd already promised to have it posted by EOD
today.
------------------------------------------------------------------------
[2011-03-10 10:53:46] paj...@php.net
We need:
- windows version
- Whether IPv6 is enabled or not
Please try using simple socket as well, or using
fopen('http://localhost/foo.php'); while being sure that localhost is actually
IPv6 or Ipv4, to compare both. That will let us diagnose the issue without
having to rely on mysql.
------------------------------------------------------------------------
[2011-03-10 10:53:14] u...@php.net
If there is anything, its not MySQL specific. mysqlnd is using PHP Streams. PHP
Streams should be the source. Only other cause I can think of is MySQL server.
------------------------------------------------------------------------
[2011-03-10 10:45:51] kriscr...@php.net
Description:
------------
I'm told that a number of people have been reporting this issue. The reports
I'm hearing state that people are finding it to be about 3-4 times slower when
done by hostname.
My guess would be this is another IPv6-related issue. It's also worth noting
that I have not yet been able to independently verify these numbers, though I
am working on doing so and will post the data if/when I have it.
It was requested that I post this bug so that we have a record of it. If
you've experienced any hostname vs. IP performance issues (good or bad), please
post a comment here so we have the reports in one central place. Thanks!
Test script:
---------------
<?php
if ( !isset( $_GET["host"] ) )
{
die( "You must specify ?host= in the URL string. Example:
mysql_connect_test.php?host=localhost" );
}
$start = microtime( TRUE );
$link = mysql_connect( $_GET["host"], "root", "(your-password-here)" ) or die(
"Function mysql_connect() failed." );
$end = microtime( TRUE );
$duration = $end - $start;
print "<b>Execution Time:</b> $duration sec<br />\r\n";
------------------------------------------------------------------------
--
Edit this bug report at http://bugs.php.net/bug.php?id=54212&edit=1
