[prev in list] [next in list] [prev in thread] [next in thread] 

List:       jakarta-commons-dev
Subject:    [jira] [Created] (POOL-410) EHN Max Concurrent Connections in Stats
From:       "Thomas Freller (Jira)" <jira () apache ! org>
Date:       2022-09-30 21:21:00
Message-ID: JIRA.13484060.1664572853000.354525.1664572860047 () Atlassian ! JIRA
[Download RAW message or body]

Thomas Freller created POOL-410:
-----------------------------------

             Summary: 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


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)


[prev in list] [next in list] [prev in thread] [next in thread]