users@glassfish.java.net

Re: jdbc-connection-pool settings

From: <glassfish_at_javadesktop.org>
Date: Tue, 17 Jun 2008 19:37:29 PDT

Hi,

Please find below, the statics collected from Pool
Monitor.

The things worrying are:
maxConnectionRequestWait = 4654
and
maxNumConnUsed = 1

Had there been an increase in maxNumConnUsed, I guess,
the maxConnectionRequestWait will reduce considerably!??

Monitoring Statistics :
PoolCounters:
 maxNumConnUsed = 1
 minNumConnUsed = 0
 currNumConnUsed = -77
 maxNumConnFree = = 102
 minNumConnFree = 24
 currNumConnFree = 102
 numConnCreated = 45
 numConnDestroyed = 0
 numConnFailedValidation = 0
 numConnTimedOut = 0
 numConnAcquired = 120
 numConnReleased = 110
 currConnectionRequestWait = 1
 minConnectionRequestWait = 0
 maxConnectionRequestWait = 4654
 totalConnectionRequestWait = 15410
 numConnSuccessfullyMatched = 118
 numConnNotSuccessfullyMatched = 0
 numPotentialConnLeak = 0|#]

Hope, someone has some clue of how to optimize these.

Kind Regards,
Sanjeev
[Message sent by forum member 'sanjeev_any' (sanjeev_any)]

http://forums.java.net/jive/thread.jspa?messageID=280906