Monitor Wildfly datasource connection pool?

[mahendrakawde]

I am working on a project where there is need to monitor connection pool.

My application is running on wildlfy-9.0.1.Final. I want to determine min_pool_size and max_pool_size, right now I have set only max_pool_size = 30.

I am using -ds.xml file to configure datasource.

And whenever I find user can not login due to all the connections in pool size are acquired then I go ahead and increase pool size to some higher number like 60.

But I am not sure what will be safe number. So I want to monitor datasource connection pool.

Can anyone tell me how can I do this ?

[ctomc]

mahendra kawde wrote:

I am using -ds.xml file to configure datasource.

step 1) Stop using -ds.xml files for configuring datasources

step 2) enable statistics in datasource subsystem

step 3) read datasource runtime date via mgmt api, either CLI, rest, or even custom api.