From: Olexandr Melnyk (omelnykgmail.com)
Date: Fri Sep 19 2008 - 11:07:58 CDT

• Messages sorted by: [ date ] [ thread ] [ subject ] [ author ]

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 <garyprimeexalia.com> 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:Gail.Kinneyucdenver.edu]
> Sent: Fri 9/19/2008 8:33 AM
> To: 'mysqllists.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
> gail.kinneyucdenver.edu<mailto:gail.kinneyucdenver.edu>
>
>
>
>

--
Sincerely yours,
Olexandr Melnyk
http://omelnyk.net/

• Messages sorted by: [ date ] [ thread ] [ subject ] [ author ]