Checking HikariCP Option Values | /var/log/dongdorrong

Along with the datasource settings in application.yaml, set the log level as shown below and run the application to inspect the HikariCP option values.

Code

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

If connection pool issues occur frequently between the backend and the database, adjust the connection pool options to suit your application.

Code

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