Default maximumPoolSize for HikariCP

Question

What is the default connection pool size that spring boot HikariCP provides when the container loads?

of course, I am using below properties to setup max cp size, but I was wondering what is the default CP size if we don't give any number in the application.properties file.

spring.datasource.hikari.minimumIdle=5
spring.datasource.hikari.maximumPoolSize=20
spring.datasource.hikari.idleTimeout=30000
spring.datasource.hikari.poolName=SpringBootJPAHikariCP
spring.datasource.hikari.maxLifetime=2000000
spring.datasource.hikari.connectionTimeout=30000

And if I give a max pool size in application.properties as 100 and I use only 20, will that affect my application performance?

Solution

maximumPoolSize

Default: 10

HicariCP Documentation contains default properties: https://github.com/brettwooldridge/HikariCP

Read about Pool Size here: Maximum Connection Pool Size

Comments

[Wim Deblauwe]

See baeldung.com/spring-boot-hikari for some details

[ka3ak]

It would be also great to know why actuator doesn't show the defaults under actuator/env. Asked here stackoverflow.com/questions/63358741/…

[Hari]

Thank you, and what is the maximum number of connection pools that HikariCP handles? is it based on JVM memory ?