Re: [PHP] "Too many connections" fix?

2003-10-02 Thread Alister
On Wed, 1 Oct 2003 21:17:09 -0700 (PDT) Chris Shiflett <[EMAIL PROTECTED]> wrote: > --- Nicole <[EMAIL PROTECTED]> wrote: > > So I switched to connect, with no luck in fixing the "too many > > connections" problem. > > Now that's some helpful information. The first thing you need to do is > forge

Re: [PHP] "Too many connections" fix?

2003-10-02 Thread Raditha Dissanayake
Hi, Pardon me, looks like i haven't answered the original question after all. Need coffee. Here is another attempt. Have you considered mysql replication? this is an easy way of building both a fail safe system as well as to balance the load. the drawback is that you need to pay for an extra s

Re: [PHP] "Too many connections" fix?

2003-10-02 Thread Raditha Dissanayake
pconnect vs connect: Isn't it what the apache project calls the 'stampeding herd' problem? original question: Nicole one of the simplest, cheapest and best solutions is to put your log files on a separate hard disk. you will be amazed by the result. You would ofcouse get even better results

Re: [PHP] "Too many connections" fix?

2003-10-01 Thread Chris Shiflett
--- Nicole <[EMAIL PROTECTED]> wrote: > So I switched to connect, with no luck in fixing the "too many > connections" problem. Now that's some helpful information. The first thing you need to do is forget about persistent connections being the problem. I don't claim to be an expert at debugging M

Re: [PHP] "Too many connections" fix?

2003-10-01 Thread Chris Shiflett
--- Nicole <[EMAIL PROTECTED]> wrote: > I don't see a MaxConnections in Apache conf, or maybe I overlooked > it. I do see: > > MaxClients 150 Maximum connections is the MySQL configuration option. MaxClients is the Apache directive I mentioned. Ultimately, all you have to do to use persistent c

Re: [PHP] "Too many connections" fix?

2003-10-01 Thread Nicole
t; > > > > > >- Original Message - > >From: "Chris Shiflett" <[EMAIL PROTECTED]> > >To: "Curt Zirzow" <[EMAIL PROTECTED]>; <[EMAIL PROTECTED]> > >Sent: Wednesday, 01 October, 2003 22:53 > >Subject: Re: [PHP] "Too

Re: [PHP] "Too many connections" fix?

2003-10-01 Thread Jason Sheets
"Chris Shiflett" <[EMAIL PROTECTED]> To: "Curt Zirzow" <[EMAIL PROTECTED]>; <[EMAIL PROTECTED]> Sent: Wednesday, 01 October, 2003 22:53 Subject: Re: [PHP] "Too many connections" fix? --- Curt Zirzow <[EMAIL PROTECTED]> wrote: This may be deb

Re: [PHP] "Too many connections" fix?

2003-10-01 Thread Nicole
Pardon me, I misread a pervious comment. I meant MaxClients. Sigh. too much sleep. -- Nicole aeontrek.com "Nicole" <[EMAIL PROTECTED]> wrote in message news:[EMAIL PROTECTED] > I don't see a MaxConnections in Apache conf, or maybe I overlooked it. I do > see: > > MaxClients 150 > > MaxKeepAli

Re: [PHP] "Too many connections" fix?

2003-10-01 Thread Nicole
I don't see a MaxConnections in Apache conf, or maybe I overlooked it. I do see: MaxClients 150 MaxKeepAliveRequests 100 It seems the latter var there relates more. Any ideas which or if both should be bumped up? I did read -- in various places -- that it was better to use connect, including P

Re: [PHP] "Too many connections" fix?

2003-10-01 Thread Becoming Digital
ng Digital www.becomingdigital.com - Original Message - From: "Chris Shiflett" <[EMAIL PROTECTED]> To: "Curt Zirzow" <[EMAIL PROTECTED]>; <[EMAIL PROTECTED]> Sent: Wednesday, 01 October, 2003 22:53 Subject: Re: [PHP] "Too many connections" fix? --- Curt Zirzow

Re: [PHP] "Too many connections" fix?

2003-10-01 Thread Chris Shiflett
--- Curt Zirzow <[EMAIL PROTECTED]> wrote: > This may be debatable, which is better? php searching through a > pool of 1000 connections for a free one or the overhead of opening > a new resource to the database each request. I suppose people can debate just about anything, but I doubt anyone can c

Re: [PHP] "Too many connections" fix?

2003-10-01 Thread Curt Zirzow
* Thus wrote Chris Shiflett ([EMAIL PROTECTED]): > --- Nicole <[EMAIL PROTECTED]> wrote: > > Originally, I used pconnect for a while. Then I learned that with > > high traffic site, that's not the best idea. > > Where did you learn this? I disagree with that notion. This may be debatable, which i

Re: [PHP] "Too many connections" fix?

2003-10-01 Thread Chris Shiflett
--- Nicole <[EMAIL PROTECTED]> wrote: > Originally, I used pconnect for a while. Then I learned that with > high traffic site, that's not the best idea. Where did you learn this? I disagree with that notion. I manage a Web site that serves 10 million hits a day, and if I didn't use persistent con

Re: [PHP] "Too many connections" fix?

2003-10-01 Thread Chris Shiflett
--- Nicole <[EMAIL PROTECTED]> wrote: > I run Apache with PHP and MySQL [snip] > > I last increased my max connections to 500. That seemed to fix things > for a while. Now I am getting the problems (database freezing up > because too many connections) again. The site I run is pretty high > traffic

Re: [PHP] "Too many connections" fix?

2003-10-01 Thread Nicole
Originally, I used pconnect for a while. Then I learned that with high traffic site, that's not the best idea. So I changed to 'connect.' But I still get the problems. Nicole aeontrek.com "Brad Pauly" <[EMAIL PROTECTED]> wrote in message news:[EMAIL PROTECTED] > Nicole wrote: > > > I last increa

Re: [PHP] "Too many connections" fix?

2003-10-01 Thread Brad Pauly
Brad Pauly wrote: Nicole wrote: I last increased my max connections to 500. That seemed to fix things for a while. Now I am getting the problems (database freezing up because too many connections) again. The site I run is pretty high traffic. I wondered if anyone encountered a solution to handl

Re: [PHP] "Too many connections" fix?

2003-10-01 Thread Brad Pauly
Nicole wrote: I last increased my max connections to 500. That seemed to fix things for a while. Now I am getting the problems (database freezing up because too many connections) again. The site I run is pretty high traffic. I wondered if anyone encountered a solution to handle this sort of proble

[PHP] "Too many connections" fix?

2003-10-01 Thread Nicole
Hello, I run Apache with PHP and MySQL on a RedHat 7.2 box with 1GB Ram @ 2GHZ (p4). I last increased my max connections to 500. That seemed to fix things for a while. Now I am getting the problems (database freezing up because too many connections) again. The site I run is pretty high traffic.