I have been setting up a connection pool for Tomcat 5.0.16 with MySQL 4.0.17. I
am using the connection pooling Tomcat offers. I'm trying to find a way to see
how many connections there are in the pool I'm creating - I have seen, thru use
of a simple .jsp, that yes, I *am* creating a connection pool and getting data
back from it. But - how can I tell how many "connections" there are in the pool?
And how does this relate to the MySQL variables I can view with a "SHOW STATUS"
or "SHOW VARIABLES"?
If anyone is familiar with the "maxActive" parameter for a Tomcat connection
pool, how does that correspond with the value of max_connections? From the
Tomcat docs, I read that "maxActive" is the maximum # of db connections in a
connection pool; from what I read on the MySQL site, "max_connections" is the
max number of simultaneous client connections allowed - so should these be the
same? Are these looking at the same thing?
Thanks!
--
Lynn Hollerman.
