From: bouddhagod at hotmail dot com Operating system: Gentoo PHP version: 5.2.9 PHP Bug Type: Performance problem Bug description: mysql_connect slow
Description: ------------ I made a connection to a mysql server. The first time i load the page all look fine. It take about 3500 - 400 ms to do the jog. The second time I load the page ( it's a login screen ) the same mysql_connect take about 5-6 sec. Thoses 2 servers is located on the same computer ( dual xeon 2.4 with 1.5 gig of ram ). So I'm sure it's not a hardware problem. Any suggestion ? Reproduce code: --------------- mysql_connect( "192.168.1.100", "username", "password"); Expected result: ---------------- not 5 SEC to responde... Actual result: -------------- first loading : 300 ms second loading : 5 SEC third loading : 300ms fourth loading : 5 SEC Etc ... -- Edit bug report at http://bugs.php.net/?id=48051&edit=1 -- Try a CVS snapshot (PHP 5.2): http://bugs.php.net/fix.php?id=48051&r=trysnapshot52 Try a CVS snapshot (PHP 5.3): http://bugs.php.net/fix.php?id=48051&r=trysnapshot53 Try a CVS snapshot (PHP 6.0): http://bugs.php.net/fix.php?id=48051&r=trysnapshot60 Fixed in CVS: http://bugs.php.net/fix.php?id=48051&r=fixedcvs Fixed in CVS and need be documented: http://bugs.php.net/fix.php?id=48051&r=needdocs Fixed in release: http://bugs.php.net/fix.php?id=48051&r=alreadyfixed Need backtrace: http://bugs.php.net/fix.php?id=48051&r=needtrace Need Reproduce Script: http://bugs.php.net/fix.php?id=48051&r=needscript Try newer version: http://bugs.php.net/fix.php?id=48051&r=oldversion Not developer issue: http://bugs.php.net/fix.php?id=48051&r=support Expected behavior: http://bugs.php.net/fix.php?id=48051&r=notwrong Not enough info: http://bugs.php.net/fix.php?id=48051&r=notenoughinfo Submitted twice: http://bugs.php.net/fix.php?id=48051&r=submittedtwice register_globals: http://bugs.php.net/fix.php?id=48051&r=globals PHP 4 support discontinued: http://bugs.php.net/fix.php?id=48051&r=php4 Daylight Savings: http://bugs.php.net/fix.php?id=48051&r=dst IIS Stability: http://bugs.php.net/fix.php?id=48051&r=isapi Install GNU Sed: http://bugs.php.net/fix.php?id=48051&r=gnused Floating point limitations: http://bugs.php.net/fix.php?id=48051&r=float No Zend Extensions: http://bugs.php.net/fix.php?id=48051&r=nozend MySQL Configuration Error: http://bugs.php.net/fix.php?id=48051&r=mysqlcfg