Interesting... I could see that happening in certain situations. I guess this would depend on the traffic profile you're seeing and your apache configuration.
Sounds like a little experimentation is in order. If you currently allow persistent connections, turn them off; otherwise, turn them on and see if the problem goes away :)
Ah, I love the scientific method ;)
Djun
On 27-Dec-2005, at 3:26 PM, Richard Archer wrote:
At 9:53 AM -0500 27/12/05, puregin wrote:
likely is a result of not allowing persistent connections for PHP (mysql.allow_persistent =On in php.ini)
In my experience allowing persistent connections causes this problem. When enabled you have each apache process holding open a connection to each database that process has accessed. This exponential growth in idle connections quickly leads to resource exhaustion.