[support] too many connections

[Mohammed al-shar']

hello richard and all,
yes, actually, it appeared to me that the problem was on my shared server. 
my site is running on a shared server, and so the whole sql database was 
down. I can't afford dedicated hosting plan. hope it never happens again.
thanks for the help.
regards
mohammed al-shar'
www.mystop.net
----- Original Message ----- 
From: "Richard Archer" <drupal.org at juggernaut.com.au>
To: <support at drupal.org>
Sent: Wednesday, December 28, 2005 1:42 AM
Subject: Re: [support] too many connections


> 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.
>
> ...R.
> -- 
> [ Drupal support list | http://lists.drupal.org/ ]
>
>