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
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
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
--- 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
--- 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
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
"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
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
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
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
--- 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
* 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
--- 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
--- 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
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
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
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
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.
18 matches
Mail list logo