[ 
https://issues.apache.org/jira/browse/POOL-410?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanel&focusedCommentId=17743460#comment-17743460
 ] 

Phil Steitz commented on POOL-410:
----------------------------------

This looks more like a question for the user list.  For monitoring, you already 
have numActive (number checked out) and numIdle (number idle in the pool) 
exposed.  And you can set maxIdle.  I don't understand fully what you are 
trying to do.  The maxTotal property does what I suspect your real need is - 
control the total number of provider resources that are dedicated to / under 
management of the pool.  That will bound the maximum number of concurrent 
instances checked out to clients.   One more note:  if what you are pooling are 
database connections, Commons DBCP makes that easier to setup and manage and 
exposes some more jdbc-specific properties.

> EHN Max Concurrent Connections in Stats
> ---------------------------------------
>
>                 Key: POOL-410
>                 URL: https://issues.apache.org/jira/browse/POOL-410
>             Project: Commons Pool
>          Issue Type: Improvement
>            Reporter: Thomas Freller
>            Priority: Major
>
> For tuning the Database the max concurrent used connections wold be relay 
> great.
>  
> So I could monitor the max concurrent connections of my pool and could see if 
> I have to size up/down the max database connections (that can me memory 
> intensive) or if I could downsize the Pool and also the Database i could save 
> Memory and costs.  At the Moment the only Indicator is 
> maxBorrowWaitDuration=PT3.016S,
>  
> But this can only tell me hat at the Moment the pool reached its max (because 
> I set maxTotal to 1) my normal Case is to have up to 20 Pools of different 
> Applications that connect to one instance of MariaDB and the output of 
> maxBorrowWaitDuration is 0. So I only know I would be able to downsize the 
> pool but I have no hint how to size the pool best.
> This Statistical Data should be also printed in the toString() Method.



--
This message was sent by Atlassian Jira
(v8.20.10#820010)

Reply via email to