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. -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe: http://lists.mysql.com/[EMAIL PROTECTED]
