Hi,
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
Regards,
Pradeep Chandru.
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 <[EMAIL PROTECTED]> wrote:
You have to use mysql 64bits on S.O. 64bits
------Mensaje original------
De: Martin Gainty
Para: Kinney, Gail
Para: 'mysql@lists.mysql.com'
Enviado: 19 Sep 2008 10:51
Asunto: RE: too many connections
in my.cnf configuration file try upping the number of connections
max_connections=3072
to
max_connections=6144
Martin
______________________________________________
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: [EMAIL PROTECTED]
To: mysql@lists.mysql.com
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
[EMAIL PROTECTED]<mailto:[EMAIL PROTECTED]>
_________________________________________________________________
Want to do more with Windows Live? Learn "10 hidden secrets" from Jamie.
http://windowslive.com/connect/post/jamiethomson.spaces.live.com-Blog-cns!550F681DAD532637!5295.entry?ocid=TXT_TAGLM_WL_domore_092008
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 [EMAIL PROTECTED]
--
MySQL General Mailing List
For list archives: http://lists.mysql.com/mysql
To unsubscribe: http://lists.mysql.com/[EMAIL PROTECTED]
