I think you need to take into consideration the following thins:
1. The number of connections that can come at any point of time
(depending up on the statisics) set global max_connections=1000
2.decrease the wait time out variable wait_timeout=30 or even lower
value depending upon connections.
3. Also check if the queries are getting locked or do you have any slow
queries during that time.
please let me know what are your current values for the above parameters
what is the value of
`netstat -an |grep -i est |wc -l` during the time of the error
Brent Baisley wrote:
> 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.
> Brent Baisley
> 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.
********** DISCLAIMER **********
Information contained and transmitted by this E-MAIL is proprietary to
Sify Limited and is intended for use only by the individual or entity to
which it is addressed, and may contain information that is privileged,
confidential or exempt from disclosure under applicable law. If this is a
forwarded message, the content of this E-MAIL may not have been sent with
the authority of the Company. If you are not the intended recipient, an
agent of the intended recipient or a person responsible for delivering the
information to the named recipient, you are notified that any use,
distribution, transmission, printing, copying or dissemination of this
information in any way or in any manner is strictly prohibited. If you have
received this communication in error, please delete this mail & notify us
immediately at admin@stripped