springboo2.xt中自带数据库连接池HikariCP配置

最新推荐文章于 2024-06-09 00:04:11 发布

墨渧

最新推荐文章于 2024-06-09 00:04:11 发布

阅读量405

点赞数

文章标签： SpringBoot2.x HikariCP

本文链接：https://blog.csdn.net/m0_37732829/article/details/89235400

版权

本文介绍了Spring Boot 2.x中如何配置及使用自带的高性能数据库连接池HikariCP，探讨了其优势和配置参数的设置方法。

摘要由CSDN通过智能技术生成

spring:
  datasource:
    url: jdbc:mysql://localhost:3306/houses?characterEncoding=UTF-8
    username: root
    password: 123456
    driver-class-name: com.mysql.jdbc.Driver
    type: com.zaxxer.hikari.HikariDataSource
    hikari:
      minimum-idle: 10
      idle-timeout: 600000
      maximum-pool-size: 25
      auto-commit: true
      pool-name: MyHikariCP
      max-lifetime: 1800000
      connection-timeout: 30000

#Hikari will use the above plus the following to setup connection pooling
#spring.datasource.type=com.zaxxer.hikari.HikariDataSource
#spring.datasource.hikari.minimum-idle=10
#spring.datasource.hikari.maximum-pool-size=25
#spring.datasource.hikari.auto-commit=true
#spring.datasource.hikari.idle-timeout=30000
#spring.datasource.hikari.pool-name=ExpendHikariCP
#spring.datasource.hikari.max-lifetime=1800000
#spring.datasource.hikari.connection-timeout=30000
#spring.datasource.hikari.connection-test-query=SELECT