From: damien at zaide dot org Operating system: Windows 2003 Server PHP version: 5.2.5 PHP Bug Type: MySQL related Bug description: Php is very slow to make a MySQL connection
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 bug report at http://bugs.php.net/?id=44497&edit=1 -- Try a CVS snapshot (PHP 5.2): http://bugs.php.net/fix.php?id=44497&r=trysnapshot52 Try a CVS snapshot (PHP 5.3): http://bugs.php.net/fix.php?id=44497&r=trysnapshot53 Try a CVS snapshot (PHP 6.0): http://bugs.php.net/fix.php?id=44497&r=trysnapshot60 Fixed in CVS: http://bugs.php.net/fix.php?id=44497&r=fixedcvs Fixed in release: http://bugs.php.net/fix.php?id=44497&r=alreadyfixed Need backtrace: http://bugs.php.net/fix.php?id=44497&r=needtrace Need Reproduce Script: http://bugs.php.net/fix.php?id=44497&r=needscript Try newer version: http://bugs.php.net/fix.php?id=44497&r=oldversion Not developer issue: http://bugs.php.net/fix.php?id=44497&r=support Expected behavior: http://bugs.php.net/fix.php?id=44497&r=notwrong Not enough info: http://bugs.php.net/fix.php?id=44497&r=notenoughinfo Submitted twice: http://bugs.php.net/fix.php?id=44497&r=submittedtwice register_globals: http://bugs.php.net/fix.php?id=44497&r=globals PHP 4 support discontinued: http://bugs.php.net/fix.php?id=44497&r=php4 Daylight Savings: http://bugs.php.net/fix.php?id=44497&r=dst IIS Stability: http://bugs.php.net/fix.php?id=44497&r=isapi Install GNU Sed: http://bugs.php.net/fix.php?id=44497&r=gnused Floating point limitations: http://bugs.php.net/fix.php?id=44497&r=float No Zend Extensions: http://bugs.php.net/fix.php?id=44497&r=nozend MySQL Configuration Error: http://bugs.php.net/fix.php?id=44497&r=mysqlcfg
