tomcat-users mailing list archives

Site index · List index
Message view « Date » · « Thread »
Top « Date » · « Thread »
From "Hampson, Christopher (EXP)" <christopher.hamp...@lmco.com>
Subject MySQL JNDI resource
Date Tue, 16 Jan 2007 15:47:25 GMT

Hi,
I have a JNDI connection to a MySQL database, a new thread is started
every n seconds which queries a web service and then returns with the
response time or a timeout. Each of these threads has a connection to
the database. If the server is responding very slowly or indeed not
responding at all then the number of threads which are running obviously
grows. 

If I watch the SQLManager there are only ever 8 connection maximum from
the java application when technically more should exist. The maximum in
both the tomcat JNDI declaration and in MySQL are set to 100. Max Idle
is also set to 100. Thread concurrency is set to 100 in MySQL
properties.

I'm not sure but have an idea that the thread concurrency setting for a
JNDI may be the problem, the default for mysql is 8 as well so could be
set to 8 in JNDI but I have no idea to change it.

Anybody know how to or have any other ideas?

I am using Tomcat 5.0 and the mysql connector version 3.0.14.

Help appreciated,
Thanks,

Christopher Hampson

Mime
  • Unnamed multipart/alternative (inline, None, 0 bytes)
View raw message