Re: JOnAS Pool Configuration

Hi Ziad,

Some tips here (but quite difficult without having a detailed context of 
your application),
the number of concurrent users is related :

a) to the application uses and to the behavior of the users (connection 
time, think time, ...). Anyway, the
number of concurrent users is different from the number of users. In 
your case, you have 10000 users and
i suppose that all users don't send a request at the same time to the 
application.

b) to the configuration of the tomcat connector (maxThreads parameter). 
The default value is 200 which
    means that 200 requests can be processed simultaneously. To be note 
that you can define the queue length for
    waiter threads (acceptCount) .

The JDBC pool configuration must take into account both the number of 
concurrent users and the RDB capabilities (it
might have some restrictions due to license ....).

With 200 requests in parallel and without restrictions at the  RDB side, 
the jdbc.maxconpool can be set to 200 to avoid
any contention.
Also, i would recommend :
- to set the jdbc.minconpool=jdbc.maxconpool
- to increase the jdbc.maxwaiters to '1000' to deal with any requests 
burst.
- to adapt the jdbc.pstmtmax with the number of different requests sent 
to the DB

Regards;

PS : maybe we can exchange in a separate email about your context ?
> Dear All
>
> we are using JOnAS 4.8.4 and we have about 10,000 users that login to 
> the (web Application),
>
> if we have 10,000 user what's the formula to calculate the possible 
> number of concurrent users? in addition we have the following data 
> source configuration:
>
> jdbc.maxconpool=100
> jdbc.connmaxage=30
> jdbc.samplingperiod=30
> jdbc.maxwaittime=10
> jdbc.pstmtmax=60
>
> jdbc.minconpool=0
> jdbc.maxwaiters=100
> jdbc.connchecklevel=1
> jdbc.maxopentime=10
>
> the above is effective or it should be adjusted for better performance? 
> knowing the number of maximum users around 10,000 and the calculated 
> number of concurrent users
>
> Thanks in advance
>
> Regards
>


-- 

----------------------------------------------------------------
Benoit Pelletier
http://jonas.ow2.org
Bull, Architect of an Open World TM
http://www.bull.com