Hikaricp 替换现有的数据库连接池也是很方便的 没有时间去测试 现贴出简单的配置
如果使用spring，只需要简单的替换
1<bean id="hikariDataSource" 2 class="com.zaxxer.hikari.HikariDataSource" destroy-method="shutdown"> 3 <constructor-arg> 4 <bean class="com.zaxxer.hikari.HikariConfig"> 5 <property name="driverClassName" value="${hikaricp.jdbc.driverClassName}"/> 6 <property name="jdbcUrl" value="${hikaricp.url}"/> 7 <property name="username" value="${hikaricp.username}"/> 8 <property name="password" value="${hikaricp.password}"/> 9 <property name="connectionTestQuery" value="${hikaricp.connectionTestQuery}"/> 10 <property name="connectionTimeout" value="${hikaricp.connectionTimeout}"/> 11 <property name="idleTimeout" value="${hikaricp.idleTimeout}"/> 12 <property name="maxLifetime" value="${hikaricp.maxLifetime}"/> 13 <property name="maximumPoolSize" value="${hikaricp.maximumPoolSize}"/> 14 <property name="minimumIdle" value="${hikaricp.minimumIdle}"/> 15 </bean> 16 </constructor-arg> 17 </bean>
引入的properties文件：
1#HikariDataSource config 2hikaricp.jdbc.driverClassName=com.mysql.jdbc.Driver 3hikaricp.url= jdbc:mysql://127.0.0.1:3306/dcserver38?useUnicode=true&characterEncoding=UTF-8 4hikaricp.quratz_jdbc.url=jdbc:mysql://127.0.0.1:3306/quartz?useUnicode=true&characterEncoding=UTF-8 5hikaricp.username=root 6hikaricp.password=123456 7hikaricp.connectionTestQuery= SELECT 1 8hikaricp.connectionTimeout = 30000 9#This property controls the maximum amount of time (in milliseconds)\ 10# that a connection is allowed to sit idle in the pool. Whether a connection is retired \ 11# as idle or not is subject to a maximum variation of +30 seconds, and average variation of +15 seconds.\ 12# A connection will never be retired as idle before this timeout. A value of 0 means that idle connections \ 13# are never removed from the pool. Default: 600000 (10 minutes) 14hikaricp.idleTimeout = 600000 15#This property controls the maximum lifetime of a connection in the pool. When a connection reaches this timeout, \ 16# even if recently used, it will be retired from the pool. An in-use connection will never be retired, \ 17# only when it is idle will it be removed. We strongly recommend setting this value, and using something \ 18# reasonable like 30 minutes or 1 hour. A value of 0 indicates no maximum lifetime (infinite lifetime), s\ 19# ubject of course to the idleTimeout setting. Default: 1800000 (30 minutes) 20hikaricp.maxLifetime = 1800000 21#池连接数量 22hikaricp.maximumPoolSize =100 23hikaricp.minimumIdle =100
是否真正好用 为开发者带来便利还有带长期的测试 本身这个项目年限也没有多久更多信息 ：