#41906 [Bgs]: slow local mysql_connect

ID: 41906 User updated by: kkr at mit dot de Reported By: kkr at mit dot de Status: Bogus Bug Type: MySQL related Operating System: Windows 2000 PHP Version: 5.2.3 New Comment: It's difficult to clearly seperate the php and mysql client part looking at this behaviour. All normal local applications connect fast enough to the local server, only the php takes loads of time. Can the php extension for mysql make any errors calling the mysql client lib? Is this lib statically compiled into the extension? Until now we stick with 5.2.1 version which is fine for the moment. I will try the same combination on a different windows PC just to be shure. Previous Comments: ------------------------------------------------------------------------ [2007-07-06 09:09:17] tony2001@php.net 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. ------------------------------------------------------------------------ [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] sniper@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 ------------------------------------------------------------------------ [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