#44497 [Opn]: Php is very slow to make a MySQL connection

ID: 44497 User updated by: damien at zaide dot org Reported By: damien at zaide dot org Status: Open Bug Type: MySQL related Operating System: Windows 2003 Server PHP Version: 5.2.5 New Comment: 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. Previous Comments: ------------------------------------------------------------------------ [2008-03-25 23:38:50] damien at zaide dot org Yes i have copied the .dll/.exe/.lib from the .zip to my C:\Program Files\PHP directory. Then restart IIS and the problem occurs again. ------------------------------------------------------------------------ [2008-03-25 19:30:53] jani@php.net And you really updated ALL dlls using the ones from the snapshot package? ------------------------------------------------------------------------ [2008-03-25 15:22:07] damien at zaide dot org I have setting up the cvs version and the problem occurs again. ------------------------------------------------------------------------ [2008-03-25 13:34:41] jani@php.net Please try using this CVS snapshot: http://snaps.php.net/php5.2-latest.tar.gz For Windows (zip): http://snaps.php.net/win32/php5.2-win32-latest.zip For Windows (installer): http://snaps.php.net/win32/php5.2-win32-installer-latest.msi ------------------------------------------------------------------------ [2008-03-21 15:10:52] damien at zaide dot org Description: ------------ Hi, I have installed php on our Windows 2003 Server from 1 or 2 year but we have a recurrent problem. The MySQL connection is very slow, Php is fast but when it use Mysql the performance fall. I have made some research to fix the bug. Firstly think it was a DNS problem because the mysql on not on the localhost but on a remote server (Debian 4.0 with MySQL 5). So i insert the resolv DNS in the host file, but it didn't solve. After this i monitor my MySQL server to check if it come from him, so i make the request to the page on my Win2k3 server and receive the MySQL connection just 5/10 seconds after my request (and 1 or 2 second after my page is printed) ... So the problem is on the Win2k3 side. I have checked if the libmysql.dll is in a directory in the PATH variables. And it was. The sames scripts (PhpBB and other) run very fast on our Linux server, on the same MySQL server asked. If you want me to trace a process, or debug something there is no problem ;) Thanks Reproduce code: --------------- Use a phpbb or a huge php/mysql script Expected result: ---------------- Run quickly Actual result: -------------- The request is very long ------------------------------------------------------------------------ -- Edit this bug report at http://bugs.php.net/?id=44497&edit=1