#51085 [Opn->Bgs]: Mysql Connect takews too long
| From: | aharvey@php.net | Date: | Thu, 18 Feb 2010 17:42:10 +0000 |
| Subject: | #51085 [Opn->Bgs]: Mysql Connect takews too long | ||
| References: | 1 | Groups: | php.bugs |
| Request: | Send a blank email to php-bugs+get-147832@lists.php.net to get a copy of this message | ||
ID: 51085
Updated by: aharvey@php.net
Reported By: djokodonev at gmail dot com
-Status: Open
+Status: Bogus
Bug Type: Performance problem
Operating System: windows 7
PHP Version: 5.3.1
New Comment:
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.
Previous Comments:
------------------------------------------------------------------------
[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 http://bugs.php.net/?id=51085&edit=1