HikariCP 옵션값 확인하기

application.yaml에 datasource는 물론이고 아래와 같이 로그 레벨을 설정해 주고 앱을 실행해 주면 HikariCP 옵션값을 확인할 수 있습니다.

logging:
  level:
    com.zaxxer.hikari.HikariConfig: DEBUG
    com.zaxxer.hikari: TRACE

백엔드와 데이터베이스 간의 커넥션풀 문제가 자주 발생한다면 애플리케이션 상황에 맞게 커넥션풀 옵션을 수정해 주면 됩니다.

com.zaxxer.hikari.HikariConfig           : Driver class com.p6spy.engine.spy.P6SpyDriver found in Thread context class loader org.springframework  cnb in /workspace)           
com.zaxxer.hikari.HikariConfig           : allowPoolSuspension.............false 
com.zaxxer.hikari.HikariConfig           : autoCommit......................true
com.zaxxer.hikari.HikariConfig           : catalog.........................none
com.zaxxer.hikari.HikariConfig           : connectionInitSql...............none
com.zaxxer.hikari.HikariConfig           : connectionTestQuery.............none
com.zaxxer.hikari.HikariConfig           : connectionTimeout...............30000
com.zaxxer.hikari.HikariConfig           : dataSource......................none
com.zaxxer.hikari.HikariConfig           : dataSourceClassName.............none
com.zaxxer.hikari.HikariConfig           : dataSourceJNDI..................none
com.zaxxer.hikari.HikariConfig           : dataSourceProperties............{password=<masked>}
com.zaxxer.hikari.HikariConfig           : driverClassName................."com.p6spy.engine.spy.P6SpyDriver"
com.zaxxer.hikari.HikariConfig           : exceptionOverrideClassName......none             
com.zaxxer.hikari.HikariConfig           : healthCheckProperties...........{}
com.zaxxer.hikari.HikariConfig           : healthCheckRegistry.............none
com.zaxxer.hikari.HikariConfig           : idleTimeout.....................600000
com.zaxxer.hikari.HikariConfig           : initializationFailTimeout.......1
com.zaxxer.hikari.HikariConfig           : isolateInternalQueries..........false
com.zaxxer.hikari.HikariConfig           : jdbcUrl.........................jdbc:p6spy:mysql://mysql-cluster.database.svc.cluster.local:3306/dongdorrong
com.zaxxer.hikari.HikariConfig           : keepaliveTime...................0
com.zaxxer.hikari.HikariConfig           : leakDetectionThreshold..........0
com.zaxxer.hikari.HikariConfig           : maxLifetime.....................1800000
com.zaxxer.hikari.HikariConfig           : maximumPoolSize.................10
com.zaxxer.hikari.HikariConfig           : metricRegistry..................none
com.zaxxer.hikari.HikariConfig           : metricsTrackerFactory...........none
com.zaxxer.hikari.HikariConfig           : minimumIdle.....................10
com.zaxxer.hikari.HikariConfig           : password........................<masked>
com.zaxxer.hikari.HikariConfig           : poolName........................"HikariPool-1"
com.zaxxer.hikari.HikariConfig           : readOnly........................false
com.zaxxer.hikari.HikariConfig           : registerMbeans..................false
com.zaxxer.hikari.HikariConfig           : scheduledExecutor...............none
com.zaxxer.hikari.HikariConfig           : schema..........................none
com.zaxxer.hikari.HikariConfig           : threadFactory...................internal
com.zaxxer.hikari.HikariConfig           : transactionIsolation............default
com.zaxxer.hikari.HikariConfig           : username........................"dongdorrong"
com.zaxxer.hikari.HikariConfig           : validationTimeout...............5000