senthi

Tips: To check connection pool

Discussion created by senthi on Sep 25, 2009
Latest reply on Sep 29, 2009 by pkrystosiak
Hi,         The below url is very useful to check the connection pool  on Clarity Application and NSA. http:// name>: /niku/proxool     niku --> It's showing the thread connection for Clarity Application.
 system --> It's showing the thread connection for NSA.Proxool atributes descriptions:alias=\
The name used to uniquely identify the pool to Proxool.  driver-url=\
The delegate JDBC driver class.  driver-properties=\
A set of comma separated propeties that are passed to the delegate driver. \
Example: user=foo, password=bar.  fatal-sql-exception=\
All SQLExceptions are caught and tested for containing this text fragment. \
If it matches than this connection is considered useless and it is discarded. \
Regardless of what happens the exception is always thrown again. This property behaves like a collection; \
you can set it more than once and each value is checked.  fatal-sql-exception-wrapper-class=\
If this is not-null then any fatal SQLException is wrapped up inside \
an instance of this class. If null, then the original exception is \
thrown. Range: any valid class name that is a subclass of SQLException or \
RuntimeException. Default: null (original exception is thrown) \
Examples: 'org.logicalcobwebs.proxool.FatalSQLException' or \
org.logicalcobwebs.proxool.FatalRuntimeException'  house-keeping-sleep-time=\
How long the house keeping thread sleeps for (milliseconds). \
The house keeper is responsible for checking the state of all the connections and tests whether any need to be \
destroyed or created. Default is 30 seconds.  house-keeping-test-sql=\
If the house keeping thread finds and idle connections it will test them \
with this SQL statement. It should be very quick to execute. Something like checking the current date or something. \
If not defined then this test is omitted.  maximum-active-time=\
If the housekeeper comes across a thread that has been active for longer than \
this then it will kill it. So make sure you set this to a number bigger than your slowest expected response! \
Default is 5 minutes.  maximum-connection-count=\
The maximum number of connections to the database. Default is 15.  maximum-connection-lifetime=\
The maximum amount of time that a connection exists for before it is \
killed (milliseconds). Default is 4 hours.  maximum-new-connections=\
This is the maximum number of connections we can be building at any \
one time. That is, the number of new connections that have been requested but aren't yet available for use. \
Because connections can be built using more than one thread (for instance, when they are built on demand) and it \
takes a finite time between deciding to build the connection and it becoming available we need some way of ensuring \
that a lot of threads don't all decide to build a connection at once. (We could solve this in a smarter way - and \
indeed we will one day) Default is 10.  simultaneous-build-throttle=\
This is the maximum number of connections we can be building at any \
one time. That is, the number of new connections that have been requested but aren't yet available for use. \
Because connections can be built using more than one thread (for instance, when they are built on demand) and it \
takes a finite time between deciding to build the connection and it becoming available we need some way of ensuring \
that a lot of threads don't all decide to build a connection at once. (We could solve this in a smarter way - and \
indeed we will one day) Default is 10.  minimum-connection-count=\
The minimum number of connections we will keep open, regardless of \
whether anyone needs them or not. Default is 5.  overload-without-refusal-lifetime=\
This helps us determine the pool status. If we have refused a \
connection within this threshold (milliseconds) then we are overloaded. Default is 60 seconds.  recently-started-threshold=\
This helps us determine whether the pool status is up, down or \
overloaded. As long as at least one connection was started within this threshold (milliseconds) or there are some \
spare connections available then we assume the pool is up. Default is 60 seconds.prototype-count=\
If there are fewer than this number of connections available then we will \
build some more (assuming the maximum-connection-count is not exceeded). For example. Of we have 3 active \
connections and 2 available, but our prototype-count is 4 then it will attempt to build another 2. \
This differs from minimum-connection-count because it takes into account the number of active connections. \
minimum-connection-count is absolute and doesn't care how many are in use. prototype-count is the number of \
spare connections it strives to keep over and above the ones that are currently active. Default is 0.  ThanksSenthil

Outcomes