users@glassfish.java.net

Re: connection pool monitoring on a cluster

From: Jagadish Prasath Ramu <Jagadish.Ramu_at_Sun.COM>
Date: Fri, 29 Aug 2008 16:41:28 +0530

On Thu, 2008-08-28 at 14:41 +0100, Dick Davies wrote:
> On Thu, Aug 28, 2008 at 2:11 PM, Dick Davies
> <rasputnik_at_hellooperator.net> wrote:
>
> > So my first question is : can I see these values via the admin webapp?
>
> To answer my own question : yes, under
>
> clusters -> <cluster-name> - > instances -> <pick an instance> -> monitor
>
> would still like to know why the values below don't seem to add up, though.
Yes, this can be done though showing the added/avg values for a cluster
will be a bit tricky, IMO. eg: avg-connection-wait-time : One instance
may serve better than the other (though the configuration remains the
same) as the load on it is affected by various parameters. We can not
take avg (or sum) for these values as they won't provide a realistic
view for the administrator.

Please raise an RFE (ENHANCEMENT) for "monitoring" subcomponent, if
there isn't one already.

You can use AMX to collect monitoring information from both the
instances and add them.
>
> > Also, it looks like each server instance has its own copy of the pool,
> > that's right isn't it
Yes. each instance maintains its own pool.
> > (in my mental model, they were sharing a global pool and checking out
> > their own connections)?
> >
> > If I browse around under those entries I can find stats on the
> > pool(s?) themselves, but they don't seem to add up:
> >
> > gfish$ asadmin get --monitor=true inst*.resources.prod-pool.numconn*-current
> >
> > inst01.resources.prod-pool.numconnfree-current = 7
> > inst01.resources.prod-pool.numconnused-current = 0
> > inst02.resources.prod-pool.numconnfree-current = 6
> > inst02.resources.prod-pool.numconnused-current = 0
> >
> > I expect the database to be failry quiet (I memcache the hell out of
> > this app) but
> > both the pools have an initial size of 8 (the default), so I can't
> > figure out where the other connections are?
Can you check the no. of connections (session) from the db ?
> >
> > Have I missed an entry, or am I just not understanding the values?
> >
> > Tried the same thing on my desktop
> > (same version of GFv2 but in developer profile, so everything is under
> > 'server') and it behaved as expected.
> >
> > --
> > Rasputnik :: Jack of All Trades - Master of Nuns
> > http://number9.hellooperator.net/
> >
>
>
>