Hollerman Geralyn M wrote:
> 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"?
Use SHOW PROCESSLIST to see connected users.
> 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?
No! Don't make them the same! This will prevent you from connecting to
your DB even from the MySQL client... set maxActive from 5-10... for
even a multithreaded app this will be sufficient.
maxActive I assume is because the "Tomcat" DB pool is using the CPDS pool...
Kevin
--
Please reply using PGP.
http://peerfear.org/pubkey.asc
NewsMonster - http://www.newsmonster.org/
Kevin A. Burton, Location - San Francisco, CA, Cell - 415.595.9965
AIM/YIM - sfburtonator, Web - http://peerfear.org/
GPG fingerprint: 5FB2 F3E2 760E 70A8 6174 D393 E84D 8D04 99F1 4412
IRC - freenode.net #infoanarchy | #p2p-hackers | #newsmonster
