Meaning of InUseConnectionCount

[marcusdidiusfalco]

What is the exact Meaning of
of the MBean Attribute InUseConnectionCount on
jboss.jca:service: ManagedConnectionPool ?
Is it as the name might suggest the number of used connections at a given moment (what exactly determines if a connection is used?)

I am courious because I am monitoring an application which has under considerable load a InUseConnectionCount between 0 and 2 (max 8). The colleagues who configured it expected up to 800 concurrent connections (max-pool-size).
Might this hint at a bug in the BMP implemenation?

Thanks,

Hans

[peterj]

Yes, it it the number of connections that are in use at that exact instant. "In Use" means that some thread is currently using that connection to communicate with the database.

Seeing the connections in use being only 0-2, even when a large number of users are using the app, is not unusual. First, not all users will submit requests concurrently (most are "thinking" and thus there are no requests from those users), and of the users who have active requests, not all of those will be actively using the database. And if you add in Hibernate or JPA, which cache some of the database data, you might have even fewer connections.

The best way to set the max connection is to observe the max in use connection count and set the max connection to that plus 10-20%.