ID: 44497 User updated by: damien at zaide dot org Reported By: damien at zaide dot org -Status: Feedback +Status: Open Bug Type: MySQL related Operating System: Windows 2003 Server PHP Version: 5.2.5 New Comment:
I have setting up the cvs version and the problem occurs again. Previous Comments: ------------------------------------------------------------------------ [2008-03-25 13:34:41] [EMAIL PROTECTED] 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