Too many connections MySQL error from PHP

[Angelos]

I get this error mysql_pconnect Too many connections ... every now and
then.
Does anyone knows where it comes from ?
There are a lot of sites running on the server and all of them use the
Database frequently.
Is there any configuration that I will have to do to my server in order to
handle the load ?

Thank you...
I would appreciate answers from someone that already experienced that
problem.

[thedude]

On 2005-08-01 07:01:04 -0500, "Angelos" <an*****@redcatmedia.net> said:

I get this error mysql_pconnect Too many connections ... every now and then.
Does anyone knows where it comes from ?
There are a lot of sites running on the server and all of them use the
Database frequently.
Is there any configuration that I will have to do to my server in order
to handle the load ?

Thank you...
I would appreciate answers from someone that already experienced that problem.

Could try adding this to your my.cnf:

set-variable=max_connections=250

and restart MySQL, you can raise the number to something higher if needed.

[Good Man]

"Angelos" <an*****@redcatmedia.net> wrote in
news:dc**********@nwrdmz02.dmz.ncs.ea.ibs-infra.bt.com:

I get this error mysql_pconnect Too many connections ... every now
and then.
Does anyone knows where it comes from ?

why are you using mysql_pconnect instead of mysql_connect? that's my big
question.

[Angelos]

"Good Man" <he***@letsgo.com> wrote in message
news:Xn************************@216.196.97.131...

"Angelos" <an*****@redcatmedia.net> wrote in
news:dc**********@nwrdmz02.dmz.ncs.ea.ibs-infra.bt.com:

I get this error mysql_pconnect Too many connections ... every now
and then.
Does anyone knows where it comes from ?

why are you using mysql_pconnect instead of mysql_connect? that's my big
question.

Yeah thats a good question...
I have just changed that to myqsl_connect
But I still don't understand when to use mysql_pconnect

Thanks anyway

[Aggro]

Angelos wrote:

But I still don't understand when to use mysql_pconnect

Read the comments from php-website:
http://www.php.net/manual/fi/functio...l-pconnect.php

"In general use mysql_connect() for connecting to MySQL unless that
connection takes a long time to establish."

So basicly you might need this only if your database is on remote
computer. And when you are forced to use it, you will have to work
around with the problems it might give you.