Edit report at https://bugs.php.net/bug.php?id=51085&edit=1
ID: 51085
Comment by: mikegrey28 at hotmail dot com
Reported by: djokodonev at gmail dot com
Summary: Mysql Connect takews too long
Status: Not a bug
Type: Bug
Package: Performance problem
Operating System: windows 7
PHP Version: 5.3.1
Block user comment: N
Private report: N
New Comment:
I had WinXP 32 bits running EasyPHP.
My script connected to MySql in milliseconds.
Now I migrated to Win 7 64bit and the some code is now taking 1 second to connect
to mySQL (with firewall ON or OFF, it's the same).
Maybe I should get an EasyPHP build for 64bit but I can't find it :S
Cheers.
Previous Comments:
------------------------------------------------------------------------
[2012-08-21 05:16:14] m dot mihailko at gmail dot com
I have the similar problem. Do you find a solution?
------------------------------------------------------------------------
[2010-02-18 23:59:47] djokodonev at gmail dot com
Yes,
Well there isn't any load on the Machine, neither queries slow or any.
Already tried disabling the Firewall it gave no result.
Tried entering "localhost", 127.0.0.1, "localhost:3306", etc. They all gave the
same result. So it is not a DNS issue? as far as i can tell.
But just in case i have the localhost added in the win/system32/drivers/etc/hosts file mapping to
127.0.0.1
I've tried opening MYSQL from the command line(cmd) and it seems instantaneous connection
compared to the 0.5 sec that takes php (mysql_connect) to connect.
NOTE that the Delay is always 0.5 sec. (+- 0.02) sec.
I simple doesn't makes sense but a lot of things don't i guess =).
And the configuration I am running is exactly thee same one as before. I triple or checked at least
10 times. I've been playing with this for at least 4 days now.
Now I don't think that i can find a book or go to seminar or anything that i offered on the php
support page.
Anyways it is not bogus... Maybe it is MYSQL related not php related but you'll be getting such
requests a lot in the coming months with people going over to WIN 7.
I've tried all the Google Related pages to look up a solution to this problem and tried
installing a few versions of php and mysql to test out whether there is any difference if one would
work compared to other WITHOUT ANY RESULTS.
And it would have been great if I could actually see where the delay is.. If it in the computer or
something needs to be tweaked.. et. but i have no idea on how to do that.
------------------------------------------------------------------------
[2010-02-18 17:42:09] aharvey@php.net
-Status: Open
+Status: Bogus
This looks broadly similar (albeit on a different OS) to bug #48051, which wasn't a PHP issue
as such either. Try disabling any firewalls you have enabled, check that MySQL isn't under
undue load, see if connections from other applications (such as the MySQL command line client) also
have a similar delay, et cetera.
At any rate, your problem does not imply a bug in PHP itself. For a list of more appropriate places
to ask for help using PHP, please visit http://www.php.net/support.php as this bug system is not
the appropriate forum for asking support questions.
Thank you for your interest in PHP.
------------------------------------------------------------------------
[2010-02-18 16:52:28] djokodonev at gmail dot com
-Bug Type: Documentation problem
+Bug Type: Performance problem
It's a Performance problem...
------------------------------------------------------------------------
[2010-02-18 16:45:09] djokodonev at gmail dot com
Description:
------------
The mysql_connect function takes too long to connect to the host.
As shown below, the example code I've written, makes a connection to the local database(mysql)
running on port 3306.
It worked just fine before i upgraded to windows 7.. It is quite possible that this is OS related
than php related but still.
I would surely appreciate any feedback.
Regards
Reproduce code:
---------------
---
From manual page: http://www.php.net/function.mysql-connect#Parameters
---
// Test Code
$start = microtime(true);
$conect = mysql_connect("127.0.0.1:3306", "root", "myPassword");
$end = microtime(true);
echo $end - $start;// 0.500825881958 sec.
// results is -> 0.500825881958 sec...??? it is taking too long to connect for some reason??? Is
it PHP related or?
------------------------------------------------------------------------
--
Edit this bug report at https://bugs.php.net/bug.php?id=51085&edit=1