_pconnect in multi-host environment

From: Date: Wed, 21 Nov 2001 16:33:25 +0000
Subject: _pconnect in multi-host environment
Groups: php.general 
Request: Send a blank email to php-general+get-75922@lists.php.net to get a copy of this message
So, I was thinking about _pconnect and friends last night in a multi-host ISP-type environment. Assume there are 100 Apache children, and that each of 20 clients with db access has a different MySQL username/password for login. Does that mean that under worst-case analysis, there should be 20 X 100 == 2000 MySQL connections available, so each Apache child could end up holding on to a connection for each username/password? Otherwise, it seems to me that you'd have a fair amount of thrashing as connections were destroyed to be re-created. Of course, that's just worst-case. In reality, there are usually two or three sites with heavy traffic that would each need 100 connections available, and a bunch of others that need maybe 5 or 6 concurrent connections. Am I (A) understanding connection pooling correctly and (B) doing the math right? -- Like Music? http://l-i-e.com/artists.htm

« previous php.general (#75922) next »