users@glassfish.java.net

Re: RE: Connection Pool monitoring data - spooky math?

From: John Lister <john.lister_at_kickstone.com>
Date: Tue, 06 Nov 2012 11:16:39 +0000

You're not going mad, I've noticed the same problems, I've currently got
-180 free connections. The created and freed counts look to be accurate,
so I'd use those in the mean time and take the difference

John


On 05/11/2012 14:11, Bryan Varner wrote:
> So I'm not reading this wrong, and the numbers I'm seeing do not make sense?
> ________________________________________
> From: Shalini [shalini.muthukrishnan_at_oracle.com]
> Sent: Sunday, November 04, 2012 11:30 PM
> To: users_at_glassfish.java.net
> Subject: Re: Connection Pool monitoring data - spooky math?
>
> Please file an issue with all the steps and the connection pool
> configuration.
>
> On Thursday 01 November 2012 07:41 PM, Bryan Varner wrote:
>> I'm in the process of migrating an existing system to glassfish 3.1.2.2
>>
>> At this point, we're trying to get the bean pool's & connection pools tuned appropriately for our apps.
>>
>> I've enabled high monitoring server-wide, and started running some normal usage pattern test cases on our servers.
>>
>> I'm accustomed to C3P0 connection pools, which are really easy to instrument and gauge your pool resource usage.
>> With C3P0 the most pertinent data points we monitor when tuning the app are:
>> numConnections (current pool size)
>> numBusyConnections (number of connections currently in use)
>> maxPoolSize (maximum size of pool)
>> minPoolSize (min / steady pool size)
>>
>> It looks like the analogous values in GF monitoring would be:
>> NumConnCreated - NumConnDestroyed =urrent pool size
>> NumConnUsed =umber of connections currently in use
>>
>> And then I could read the min / max off the pool's config.
>>
>> The problem that I have, is that the numbers I'm seeing in the GF monitoring data don't make sense!
>>
>> For instance, right now I have NumConnFree =3989, and NumConnUsed = 4000, on a pool that's configured with a maximum connection size of 75.
>>
>> How can the number of free connections in the pool be a _negative_ number, and how can NumConnUsed be so high?
>>
>> Am I reading the intent of these metrics incorrectly because I'm expecting to be able to see the current state of the pool rather than just hit counters?
>>
>> Help!?
>>
>> Regards,
>> - Bryan Varner

-- 
Get the PriceGoblin Browser Addon
www.pricegoblin.co.uk