In case you're using PHP, in theory all database connections should be closed when script stops execution. I'm not sure if it's always like that in practice.
Persistent connections can be a quick fix to your problem, but as was mentioned in the previous mail, it's better to find out why there's so many of them. On 9/19/08, Gary W. Smith <[EMAIL PROTECTED]> wrote: > > Gail, > > I know the list has already recommended allowing more connections but the > bigger question is what is sucking them all up. Even with 1000 connections > things like apache can only use the number of connections that there are > processes (* the number of connections used within each process). > > As a fast workaround, increase the connections but for a long term solution > you really need to find out what the problem is, now how to work around it. > > Gary > > > > ________________________________ > > From: Kinney, Gail [mailto:[EMAIL PROTECTED] > Sent: Fri 9/19/2008 8:33 AM > To: 'mysql@lists.mysql.com' > 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]> > > > > -- Sincerely yours, Olexandr Melnyk http://omelnyk.net/
