tomcat-users mailing list archives

Site index · List index
Message view « Date » · « Thread »
Top « Date » · « Thread »
From "Pid *" <...@pidster.com>
Subject Re: Connection pooling issue with MySQLNonTransientConnectionException and Java webapp
Date Mon, 21 Nov 2011 19:07:30 GMT
On 21 Nov 2011, at 16:25, Martin O'Shea <appy74@dsl.pipex.com> wrote:

> Thanks Terence.
>
> Yes, I have been. Increasing the number of connections in MySQL, the
> max_connections parameter, seems to have helped somewhat.

If you are leaking connections it will just delay the problem, even
make it worse.

Connect VisualVM to Tomcat and monitor the connection pool, (assuming
you have configured the pool as a Resource).

If it keeps increasing in size, outgrowing the Connector threads, you
have a leak.


p

> Is there an optimum number of connections that the 'equivalent' Tomcat
> maxActive should have?
>
> -----Original Message-----
> From: Terence M. Bandoian [mailto:terence@tmbsw.com]
> Sent: 21 Nov 2011 16 11
> To: Tomcat Users List
> Subject: Re: Connection pooling issue with
> MySQLNonTransientConnectionException and Java webapp
>
>
> On 1:59 PM, Martin O'Shea wrote:
>> Caused by:
>> com.mysql.jdbc.exceptions.jdbc4.MySQLNonTransientConnectionException:
>> Data source rejected establishment of connection,  message from
>> server: "Too many connections"
>
> I'd check into this.
>
> -Terence Bandoian
>
>
> ---------------------------------------------------------------------
> To unsubscribe, e-mail: users-unsubscribe@tomcat.apache.org
> For additional commands, e-mail: users-help@tomcat.apache.org
>
>
>
>
> ---------------------------------------------------------------------
> To unsubscribe, e-mail: users-unsubscribe@tomcat.apache.org
> For additional commands, e-mail: users-help@tomcat.apache.org
>

---------------------------------------------------------------------
To unsubscribe, e-mail: users-unsubscribe@tomcat.apache.org
For additional commands, e-mail: users-help@tomcat.apache.org


Mime
View raw message