什么是HIkariCP

https://www.jianshu.com/p/15b846107a7c

使用HikariCP数据源pom.xml

<dependency> <groupId>com.zaxxer</groupId> <artifactId>HikariCP</artifactId> <version>3.3.1</version></dependency>Spring-mvc.xml

<bean id="dataSource" class="com.zaxxer.hikari.HikariDataSource" destroy-method="shutdown"> <property name="driverClassName" value="${jdbc.driver}" /> <property name="jdbcUrl" value="${jdbc.url}" /> <property name="username" value="${jdbc.username}" /> <property name="password" value="${jdbc.password}" /> <property name="connectionTestQuery" value="SELECT 1" /> <!-- 生效超时 --> <property name="validationTimeout" value="3000" /> <!-- 连接只读数据库时配置为true， 保证安全 --> <property name="readOnly" value="false" /> <!-- 等待连接池分配连接的最大时长（毫秒），超过这个时长还没可用的连接则发生SQLException， 缺省:30秒 --> <property name="connectionTimeout" value="60000" /> <!-- 一个连接idle状态的最大时长（毫秒），超时则被释放（retired），缺省:10分钟 --> <property name="idleTimeout" value="60000" /> <!-- 一个连接的生命时长（毫秒），超时而且没被使用则被释放（retired），缺省:30分钟，建议设置比数据库超时时长少30秒，参考MySQL wait_timeout参数（show variables like '%timeout%';） --> <property name="maxLifetime" value="60000" /> <!-- 连接池中允许的最大连接数。缺省值：10；推荐的公式：((core_count * 2) + effective_spindle_count) --> <property name="maximumPoolSize" value="10" /> </bean>启动成功日志

17:36:50.838 [main] WARN com.zaxxer.hikari.HikariConfig - HikariPool-1 - idleTimeout has been set but has no effect because the pool is operating as a fixed size pool.17:36:50.838 [main] DEBUG com.zaxxer.hikari.HikariConfig - HikariPool-1 - configuration:17:36:50.841 [main] DEBUG com.zaxxer.hikari.HikariConfig - allowPoolSuspension.............false17:36:50.841 [main] DEBUG com.zaxxer.hikari.HikariConfig - autoCommit......................true17:36:50.841 [main] DEBUG com.zaxxer.hikari.HikariConfig - catalog.........................none17:36:50.841 [main] DEBUG com.zaxxer.hikari.HikariConfig - connectionInitSql...............none17:36:50.841 [main] DEBUG com.zaxxer.hikari.HikariConfig - connectionTestQuery............."SELECT 1"17:36:50.841 [main] DEBUG com.zaxxer.hikari.HikariConfig - connectionTimeout...............6000017:36:50.841 [main] DEBUG com.zaxxer.hikari.HikariConfig - dataSource......................none17:36:50.841 [main] DEBUG com.zaxxer.hikari.HikariConfig - dataSourceClassName.............none17:36:50.841 [main] DEBUG com.zaxxer.hikari.HikariConfig - dataSourceJNDI..................none17:36:50.843 [main] DEBUG com.zaxxer.hikari.HikariConfig - dataSourceProperties............{password=<masked>}17:36:50.843 [main] DEBUG com.zaxxer.hikari.HikariConfig - driverClassName................."com.mysql.jdbc.Driver"17:36:50.843 [main] DEBUG com.zaxxer.hikari.HikariConfig - healthCheckProperties...........{}17:36:50.843 [main] DEBUG com.zaxxer.hikari.HikariConfig - healthCheckRegistry.............none17:36:50.843 [main] DEBUG com.zaxxer.hikari.HikariConfig - idleTimeout.....................6000017:36:50.843 [main] DEBUG com.zaxxer.hikari.HikariConfig - initializationFailTimeout.......117:36:50.843 [main] DEBUG com.zaxxer.hikari.HikariConfig - isolateInternalQueries..........false17:36:50.843 [main] DEBUG com.zaxxer.hikari.HikariConfig - jdbcUrl.........................jdbc:mysql://ykx.uerp.net:3306/ykx?useUnicode=true&characterEncoding=utf817:36:50.843 [main] DEBUG com.zaxxer.hikari.HikariConfig - leakDetectionThreshold..........017:36:50.843 [main] DEBUG com.zaxxer.hikari.HikariConfig - maxLifetime.....................6000017:36:50.843 [main] DEBUG com.zaxxer.hikari.HikariConfig - maximumPoolSize.................1017:36:50.843 [main] DEBUG com.zaxxer.hikari.HikariConfig - metricRegistry..................none17:36:50.843 [main] DEBUG com.zaxxer.hikari.HikariConfig - metricsTrackerFactory...........none17:36:50.843 [main] DEBUG com.zaxxer.hikari.HikariConfig - minimumIdle.....................1017:36:50.843 [main] DEBUG com.zaxxer.hikari.HikariConfig - password........................<masked>17:36:50.843 [main] DEBUG com.zaxxer.hikari.HikariConfig - poolName........................"HikariPool-1"17:36:50.843 [main] DEBUG com.zaxxer.hikari.HikariConfig - readOnly........................false17:36:50.843 [main] DEBUG com.zaxxer.hikari.HikariConfig - registerMbeans..................false17:36:50.844 [main] DEBUG com.zaxxer.hikari.HikariConfig - scheduledExecutor...............none17:36:50.844 [main] DEBUG com.zaxxer.hikari.HikariConfig - schema..........................none17:36:50.844 [main] DEBUG com.zaxxer.hikari.HikariConfig - threadFactory...................internal17:36:50.844 [main] DEBUG com.zaxxer.hikari.HikariConfig - transactionIsolation............default17:36:50.844 [main] DEBUG com.zaxxer.hikari.HikariConfig - username........................"ykx"17:36:50.844 [main] DEBUG com.zaxxer.hikari.HikariConfig - validationTimeout...............300017:36:50.844 [main] INFO com.zaxxer.hikari.HikariDataSource - HikariPool-1 - Starting...17:36:51.257 [main] DEBUG com.zaxxer.hikari.pool.HikariPool - HikariPool-1 - Added connection com.mysql.jdbc.JDBC4Connection@1d77a31d17:36:51.260 [main] INFO com.zaxxer.hikari.HikariDataSource - HikariPool-1 - Start completed.