ID: 44497
Updated by: [EMAIL PROTECTED]
Reported By: damien at zaide dot org
-Status: Open
+Status: Feedback
Bug Type: MySQL related
Operating System: Windows 2003 Server
PHP Version: 5.2.5
-Assigned To:
+Assigned To: fb-req-jani
New Comment:
Then you need to figure out what really is the bottleneck. It doesn't
seem to be mysql_connect(), so check the phpbb/joomla/whatever you're
experiencing with, what they're actually using to connnect to mysql. I'd
use something like Xdebug to figure out where the real problem is..
Previous Comments:
------------------------------------------------------------------------
[2008-03-27 15:25:42] damien at zaide dot org
I have make a very small script and the connection, execution is fast.
Everything is fine. Very strange.
Here the small script:
$db_link = mysql_connect("xxxxx", "user", "pass");
mysql_select_db("database");
$ret = mysql_query("SELECT * FROM zp_options");
while ($tmp = mysql_fetch_array($ret))
print_r($tmp);
mysql_close($db_link);
------------------------------------------------------------------------
[2008-03-26 21:27:09] [EMAIL PROTECTED]
Try the smallest possible script. Just "mysql_connect()" with proper
parameters..
------------------------------------------------------------------------
[2008-03-26 13:57:50] damien at zaide dot org
I have tested with the fqdn and with the IP address, result is the
same.
I have added the fqdn in my host file in windows and result is the
same.
It's big application like phpbb or joomla who get this problem ... So i
think they use mysql_connect(). I haven't tested small scripts on the
servers.
------------------------------------------------------------------------
[2008-03-26 12:02:57] [EMAIL PROTECTED]
How exactly are you connecting to Mysql? Exactly _what_ line is used?
Do you connect using the IP of the mysql server?
------------------------------------------------------------------------
[2008-03-26 10:36:26] damien at zaide dot org
More informations :
- The problem occurs since the php installation with the installation
package. So i have the problem from the beggining i start using php with
IIS.
- My customers php files is on a Samba Server and PHP is installed on 2
HTTP servers (load balancing answer) and the problem occurs for both.
- I have no problem with ODBC MySQL connector (fast connection) and ASP
run fast on these servers.
- I have set to "on" the "output_buffering" option. I have see it could
solve my problem but no finally.
- I have "C:\Program Files\PHP" in my PATH variable.
I think the progress of the execution of this script is like this:
1/ File is loaded from the samba server. Everything is OK.
2/ Php is launched and start interpreting it. Everything is OK.
3/ Php needs to use MySQL ! The slowdown occurs here. Maybe problem to
locate phpmysql.dll or anything else.
4/ Php contacts MySQL Server and sends requests. Eveything is OK.
5/ Php prints result to the browser.
------------------------------------------------------------------------
The remainder of the comments for this report are too long. To view
the rest of the comments, please view the bug report online at
http://bugs.php.net/44497
--
Edit this bug report at http://bugs.php.net/?id=44497&edit=1
