ID: 10841 Updated by: sniper Reported By: [EMAIL PROTECTED] Old-Status: Feedback Status: Closed Bug Type: MySQL related Operating system: PHP Version: 4.0.4 Assigned To: Comments: Reopen if this happens with PHP 4.0.6RC3: http://www.php.net/~andi/php-4.0.6RC3.tar.gz --Jani Previous Comments: --------------------------------------------------------------------------- [2001-05-23 01:46:46] [EMAIL PROTECTED] Still waiting for the test results... --------------------------------------------------------------------------- [2001-05-14 07:54:17] [EMAIL PROTECTED] Ok, hang on 'till weekend (production site update neccessary :-/) Thomas --------------------------------------------------------------------------- [2001-05-14 07:18:41] [EMAIL PROTECTED] Please try PHP 4.0.5 --Jani --------------------------------------------------------------------------- [2001-05-13 18:50:59] [EMAIL PROTECTED] After doing multiple (say 3) mysql_pconnect() from within one page, as suspected the number of mysql threads increases, but only the last connection made is being reused by subsequent calls to mysql_pconnect from other pages/requests. This is a bit unconfirmed, since I don't have the time and resources right now, but tests on a production site (which has crashed very often the last time) showed that the following code cut down the number of mysql threads at least tenfold: if (!@mysql_select_db ("test")) { mysql_pconnect("db","user","pass") or die ("No DB:".mysql_error()); mysql_select_db ("test") or die ("database does not exist: ".mysql_error()); } --------------------------------------------------------------------------- ATTENTION! Do NOT reply to this email! To reply, use the web interface found at http://bugs.php.net/?id=10841&edit=2 -- PHP Development Mailing List <http://www.php.net/> To unsubscribe, e-mail: [EMAIL PROTECTED] For additional commands, e-mail: [EMAIL PROTECTED] To contact the list administrators, e-mail: [EMAIL PROTECTED]
