users@glassfish.java.net

connection pool monitoring, take 2

From: Dick Davies <rasputnik_at_hellooperator.net>
Date: Wed, 3 Sep 2008 12:26:15 +0100

Right, I've now enabled connection leak tracing and want to see if I understand
the figures asadmin get is showing me.

I've got a connection pool setup like

gfish$ asadmin get instance.resources.jdbc-connection-pool.poolname.*pool*
instance.resources.jdbc-connection-pool.poolname.max-pool-size = 32
instance.resources.jdbc-connection-pool.poolname.pool-resize-quantity = 2
instance.resources.jdbc-connection-pool.poolname.steady-pool-size = 8

and I want to see how full it is. Is the current size of the pool equal
( numconnfree-current + numconnfree-used) below?

Are there any other useful stats I should be watching?

gfish_at_mporrlr01 ~ $ asadmin get -m instance.resources.poolname.*count
instance.resources.poolname.*current
instance.resources.poolname.averageconnwaittime-count = 0
instance.resources.poolname.connrequestwaittime-current = 1
instance.resources.poolname.numconnacquired-count = 254878
instance.resources.poolname.numconncreated-count = 8
instance.resources.poolname.numconndestroyed-count = 0
instance.resources.poolname.numconnfailedvalidation-count = 0
instance.resources.poolname.numconnfree-current = 8
instance.resources.poolname.numconnnotsuccessfullymatched-count = 0
instance.resources.poolname.numconnreleased-count = 254878
instance.resources.poolname.numconnsuccessfullymatched-count = 0
instance.resources.poolname.numconntimedout-count = 0
instance.resources.poolname.numconnused-current = 0
instance.resources.poolname.numpotentialconnleak-count = 0
instance.resources.poolname.waitqueuelength-count = 0

-- 
Rasputnik :: Jack of All Trades - Master of Nuns
http://number9.hellooperator.net/