#41906 [Fbk->Opn]: slow local mysql_connect

ID: 41906 User updated by: kkr at mit dot de Reported By: kkr at mit dot de -Status: Feedback +Status: Open Bug Type: MySQL related Operating System: Windows 2000 PHP Version: 5.2.3 New Comment: Using todays CVS snapshot the problem still exists. Very slow mysql connection still takes 5-6 seconds. Previous Comments: ------------------------------------------------------------------------ [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