java HikariPool - ghdrako/doc_snipets GitHub Wiki

• https://github.com/brettwooldridge/HikariCP
• https://github.com/brettwooldridge/HikariCP/wiki/MySQL-Configuration
• https://examples.javacodegeeks.com/java-development/enterprise-java/hikaricp/hikaricp-connection-pooling-example/

Parameters

• connectionTimeout Default: 30000 (30 seconds)
• maximumPoolSize Default: 10
• autoCommit Default: true
• idleTimeout This setting only applies when minimumIdle is defined to be less than maximumPoolSize. Idle connections will not be retired once the pool reaches minimumIdle connections. Default: 600000 (10 minutes)

Example properties

spring.datasource.hikari.maximum-pool-size=50
spring.datasource.hikari.minimum-idle=10
spring.datasource.hikari.idle-timeout=300000
spring.datasource.hikari.connection-timeout=30000
spring.datasource.hikari.max-lifetime=1800000

Enable Leak Detection:

Detect and log unreturned connections:

spring.datasource.hikari.leak-detection-threshold=2000

Setting the Pool Size

Optimal Pool Size = (Number of Cores × 2) + Effective Disk Throughput