Hi Stephen,
You are saying that we should increase the max-pool-size?
I'm saying that it should not be necessary.
We should figure out why your transactions are taking a long time and fix that.
Increasing the max-pool-size is however, a pragmatic solution if it's a production issue.
Also it might happen that increasing the max-pool-size will end in a OOM error as the concurrent long running threads might use a lot of resources.
Best is to reduce the Tx duration. Other option is to restrict the number of such long running Tx.
Yes this is a production issue.
Thanks for your advice. We'll review our transaction