ID: 41906 Updated by: [EMAIL PROTECTED] Reported By: kkr at mit dot de -Status: Open +Status: Bogus Bug Type: MySQL related Operating System: Windows 2000 PHP Version: 5.2.3 New Comment:
The connect is done by MySQL client library, not PHP. PHP just provides an interface to it and cannot make your connection faster if it's slow. Previous Comments: ------------------------------------------------------------------------ [2007-07-06 06:52:36] kkr at mit dot de Using todays CVS snapshot the problem still exists. Very slow mysql connection still takes 5-6 seconds. ------------------------------------------------------------------------ [2007-07-05 21:59:01] [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 ------------------------------------------------------------------------ [2007-07-05 15:56:22] kkr at mit dot de Description: ------------ Between 5.2.1 and 5.2.2 the PHP connects much slower to a local mysql5 installation running under apache/windows 2000. It now takes 5 seconds more to a simple connect which at least does work after that time. In the changelog I've seen a new mysql client lib used starting from 5.2.2 upwards, anyone else has these problems too? The 5.2.3 still has the same behavior. A connect is either via TCP or via named pipe/socket possible but slow. Local graphical frontends to the database are as fast as always. MySQL version is the latest released one 5.0.41. Reproduce code: --------------- the usual mysql_connect() Expected result: ---------------- I expect a connect time from 200ms and experience 5500ms now. ------------------------------------------------------------------------ -- Edit this bug report at http://bugs.php.net/?id=41906&edit=1