[support] too many connections

[puregin]

This is good to know.  We should include this in the
documentation somewhere....

     Richard, could you write a paragraph for one
of the existing handbook pages, or create a new one
if necessary?

      Djun

On 27-Dec-2005, at 6:42 PM, Richard Archer wrote:

> At 5:29 PM -0500 27/12/05, puregin wrote:
>
>> 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.
>
> If your server is dedicated to hosting Drupal and there is
> only one or two databases in use then persistent connections
> may be useful.
>
> I have 100 databases on my server and if I enable persistent
> connections mysql starts throwing "too many connections"
> errors after about 8 hours of operation.
>
> I profiled performance before disabling pconnect and the
> peformance hit was about 0.001 seconds per connect. And
> that's on a 6 year old server... on modern hardware you
> would hardly notice it.
>