Edit report at http://bugs.php.net/bug.php?id=54212&edit=1
ID: 54212
Comment 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'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.
Previous Comments:
------------------------------------------------------------------------
[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
