#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] [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=41906edit=1
#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] [EMAIL PROTECTED] 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] [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=41906edit=1
#41906 [NEW]: slow local mysql_connect
From: kkr at mit dot de Operating system: Windows 2000 PHP version: 5.2.3 PHP Bug Type: Performance problem Bug description: slow local mysql_connect 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 bug report at http://bugs.php.net/?id=41906edit=1 -- Try a CVS snapshot (PHP 4.4): http://bugs.php.net/fix.php?id=41906r=trysnapshot44 Try a CVS snapshot (PHP 5.2): http://bugs.php.net/fix.php?id=41906r=trysnapshot52 Try a CVS snapshot (PHP 6.0): http://bugs.php.net/fix.php?id=41906r=trysnapshot60 Fixed in CVS: http://bugs.php.net/fix.php?id=41906r=fixedcvs Fixed in release: http://bugs.php.net/fix.php?id=41906r=alreadyfixed Need backtrace: http://bugs.php.net/fix.php?id=41906r=needtrace Need Reproduce Script:http://bugs.php.net/fix.php?id=41906r=needscript Try newer version:http://bugs.php.net/fix.php?id=41906r=oldversion Not developer issue: http://bugs.php.net/fix.php?id=41906r=support Expected behavior:http://bugs.php.net/fix.php?id=41906r=notwrong Not enough info: http://bugs.php.net/fix.php?id=41906r=notenoughinfo Submitted twice: http://bugs.php.net/fix.php?id=41906r=submittedtwice register_globals: http://bugs.php.net/fix.php?id=41906r=globals PHP 3 support discontinued: http://bugs.php.net/fix.php?id=41906r=php3 Daylight Savings: http://bugs.php.net/fix.php?id=41906r=dst IIS Stability:http://bugs.php.net/fix.php?id=41906r=isapi Install GNU Sed: http://bugs.php.net/fix.php?id=41906r=gnused Floating point limitations: http://bugs.php.net/fix.php?id=41906r=float No Zend Extensions: http://bugs.php.net/fix.php?id=41906r=nozend MySQL Configuration Error:http://bugs.php.net/fix.php?id=41906r=mysqlcfg