ID: 26117 Updated by: [EMAIL PROTECTED] Reported By: spam at vrana dot cz -Status: Open +Status: Bogus Bug Type: MySQL related Operating System: Linux PHP Version: 4.3.3 New Comment:
Thank you for taking the time to write to us, but this is not a bug. Please double-check the documentation available at http://www.php.net/manual/ and the instructions on how to report a bug at http://bugs.php.net/how-to-report.php If you go mysql_select_db() then the persistent connection you've created becomes specific to that particular database. Which may explain why those connections are not re-used. Also, persistent connections are per-child, meaning that if 1 Apache child opens connections only that child has a pre-existing connection avaliable. If a subsequent request is handled by another child, which does not yet have a MySQL connection, it'll create a new connection. Previous Comments: ------------------------------------------------------------------------ [2003-11-04 11:00:20] spam at vrana dot cz Description: ------------ Configuration: Apache 1.3.28 MySQL 4.0.15a With Apache configuration directive MaxClients set to 150, the number of database connection raised up to 466 (until MySQL denied connections with Too many connections error). In all scripts I use the same mysql_pconnect("localhost", "user", "pwd"). MySQL command SHOW PROCESSLIST showed that all 466 connections were made with the same connection parameters. All connections were in state Sleep. I am connecting to MySQL only from PHP module in Apache so I think this behavior is caused by some bug in handling with connection pool in PHP. ------------------------------------------------------------------------ -- Edit this bug report at http://bugs.php.net/?id=26117&edit=1