Max Connections to MySQL

[Doug Gentry-3]

Hi -

One of my more active sites is sometimes triggering a max user  
connections limit, requiring a Lasso site restart. I'm in a shared  
hosting arrangement with Lasso 8.5.6. Specifically Lasso Site admin  
reports this:

Message: MySQLDS failed connecting to MySQL. errno=1203 "User ND_L has  
already more than 'max_user_connections' active connections"

This doesn't happen all the time, but has occurred with some more  
frequency recently.

With a look at the list archives I find a thread earlier this year,  
that included this advice from Bil Corry:

> Kevin Bice wrote on 9/14/2009 11:46 AM:
> > You might look at the my.cnf file to control timeouts, etc.
>
> Yes, I think that's about all you can do until it's fixed:
>
> increase max_connections:
> http://dev.mysql.com/doc/refman/5.1/en/server-system-variables.html#sysvar_max_connections
> http://dev.mysql.com/doc/refman/5.1/en/too-many-connections.html
>
> shorten interactive_timeout:
> http://dev.mysql.com/doc/refman/5.1/en/server-system-variables.html#sysvar_interactive_timeout
>
> shorten wait_timeout:
> http://dev.mysql.com/doc/refman/5.1/en/server-system-variables.html#sysvar_wait_timeout
>
>
> - Bil

And then Mason Miller just posted a question, to which I haven't seen  
a response, about Lasso not releasing connections.

I'm wondering if I'm treading in the same waters, and whether anyone  
has found a way to either debug the problem or at least understand it  
better.

.....Doug Gentry




---
Doug Gentry
Dynapolis & Southern Oregon University
p:  541-261-8501 / Toll Free: 866-890-6013
doug@...
www.dynapolis.com - blog: www.plain-sense.com



--
This list is a free service of LassoSoft: http://www.LassoSoft.com/
Search the list archives: http://www.ListSearch.com/Lasso/Browse/
Manage your subscription: http://www.ListSearch.com/Lasso/