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:
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.
Previous Comments:
------------------------------------------------------------------------
[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