java - Set maximumPoolSize and minimumIdle based on processor and memory server

Question

i have a 4 JVM applications running into 4 servers. (one instance/server)

My Oracle DB opens only for 300 process (max).

the default pool connection size is 10 (since i didn't changed before); du to many requests to my Oracle DB, i got exceptions like

"Unable to aquire JDBC connection"

HikariPool-1 - Connection is not available, request timed out after 30000ms

IO Error: Got minus one from a read call

I could see this notice but i couldn't find the best configuration for my params : Thread pools need to be sized with the total number of hardware processor cores in mind

My servers are based on this configuration (same configuration *4) :

memoire size : grep MemTotal /proc/meminfo 24Go

processor number : cat /proc/cpuinfo 6

i want to increase those two params in my Spring boot application to avoid exceptions and do not explose the memory.

# HikariCP settings
     spring.datasource.hikari.minimumIdle= **
     spring.datasource.hikari.maximumPoolSize= **

what will be those params ?

question from:https://stackoverflow.com/questions/65915302/set-maximumpoolsize-and-minimumidle-based-on-processor-and-memory-server

Answer 1

Waitting for answers