Bug #54212 [Fbk]: Localhost resolves much more slowly than 127.0.0.1 on mysql_connect()
Edit report at http://bugs.php.net/bug.php?id=54212&edit=1
ID: 54212
Updated by: pajoye@php.net
Reported by: kriscraig@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:
Please try using this snapshot:
http://snaps.php.net/php5.3-latest.tar.gz
For Windows:
http://windows.php.net/snapshots/
Previous Comments:
------------------------------------------------------------------------
[2011-03-10 11:06:33] kriscraig@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] pajoye@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] uw@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] kriscraig@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
Thread (7 messages)