One thing a lot of people miss is that web server KeepAliveTimeout
setting has an effect on pconnect. Apache will keep the thread
handling that client open for the KeepAliveTimeout duration, which
will keep the database connection open for reuse.
You can lower your KeepAliveTimeout or not use pconnect.
On Fri, Sep 19, 2008 at 3:51 PM, Jaime Fuentes <jfuentes@stripped> wrote:
> You have to use mysql 64bits on S.O. 64bits
> ------Mensaje original------
> De: Martin Gainty
> Para: Kinney, Gail
> Para: 'mysql@stripped'
> Enviado: 19 Sep 2008 10:51
> Asunto: RE: too many connections
> in my.cnf configuration file try upping the number of connections
> Disclaimer and confidentiality note
> Everything in this e-mail and any attachments relates to the official business of
> Sender. This transmission is of a confidential nature and Sender does not endorse
> distribution to any party other than intended recipient. Sender does not necessarily
> endorse content contained within this transmission.
>> From: Gail.Kinney@stripped
>> To: mysql@stripped
>> Date: Fri, 19 Sep 2008 09:33:58 -0600
>> Subject: too many connections
>> Hello, We have MySQL 4.0.14 and have just gotten an error: too many
> connections. we can't connect to our site using MySQL admin. Please help.
>> Gail Kinney
>> Webmaster UC Denver
> Want to do more with Windows Live? Learn "10 hidden secrets" from Jamie.
> Enviado desde mi BlackBerry de Claro.