一妆兑、HikariCP連接池
springboot默認(rèn)使用連接池HikariCP,不需要依賴
如果application.properties配置文件
spring.datasource.url=jdbc:mysql://localhost:3306/elm?useUnicode=true&characterEncoding=utf-8&useSSL=false&serverTimezone=UTC
spring.datasource.username=root
spring.datasource.password=root
spring.datasource.driver-class-name=com.mysql.cj.jdbc.Driver
# 等待連接池分配連接的最大時(shí)長(zhǎng)(毫秒)琅绅,超過這個(gè)時(shí)長(zhǎng)還沒可用的連接則發(fā)生SQLException季惯, 默認(rèn):30秒
spring.datasource.hikari.connection-timeout=30000
# 最小連接數(shù)
spring.datasource.hikari.minimum-idle=5
# 最大連接數(shù)
spring.datasource.hikari.maximum-pool-size=15
# 自動(dòng)提交
spring.datasource.hikari.auto-commit=true
# 一個(gè)連接idle狀態(tài)的最大時(shí)長(zhǎng)(毫秒)鼓鲁,超時(shí)則被釋放(retired),默認(rèn):10分鐘
spring.datasource.hikari.idle-timeout=600000
# 連接池名字
spring.datasource.hikari.pool-name=DatebookHikariCP
# 一個(gè)連接的生命時(shí)長(zhǎng)(毫秒)唠雕,超時(shí)而且沒被使用則被釋放(retired)贸营,默認(rèn):30分鐘 1800000ms,建議設(shè)置比數(shù)據(jù)庫(kù)超時(shí)時(shí)長(zhǎng)少60秒及塘,參考MySQL wait_timeout參數(shù)(show variables like '%timeout%';) -->
spring.datasource.hikari.max-lifetime=28740000
或者application.yml配置文件
spring:
datasource:
driver-class-name: com.mysql.cj.jdbc.Driver
url: jdbc:mysql://localhost:3306/elm?useUnicode=true&characterEncoding=utf-8&useSSL=false&serverTimezone=UTC
username: root
password: root
hikari:
#最小空閑連接數(shù)量
minimum-idle: 5
#從池返回的連接默認(rèn)自動(dòng)提交
auto-commit: true
#空閑連接最大時(shí)間莽使,10秒
idle-timeout: 10000
#池中連接的最長(zhǎng)生命周期
max-lifetime: 1800000
#數(shù)據(jù)庫(kù)連接的超時(shí)時(shí)間
connection-timeout: 30000
二、druid連接池
如果application.properties配置文件
spring.datasource.druid.url=jdbc:mysql://localhost:3306/elm?useUnicode=true&characterEncoding=utf-8&useSSL=false&serverTimezone=UTC
spring.datasource.druid.username=root
spring.datasource.druid.password=root
spring.datasource.druid.driver-class-name=com.mysql.cj.jdbc.Driver
spring.datasource.druid.initial-size=1
spring.datasource.druid.max-active=20
spring.datasource.druid.min-idle=3
spring.datasource.druid.max-wait=60000
spring.datasource.druid.pool-prepared-statements=true
spring.datasource.druid.max-pool-prepared-statement-per-connection-size=20
spring.datasource.druid.filters=stat,wall,slf4j
spring.datasource.druid.connection-properties=druid.stat.mergeSql=true;druid.stat.slowSqlMillis=5000
或者application.yml配置文件
spring:
datasource:
druid:
driver-class-name: com.mysql.cj.jdbc.Driver
url: jdbc:mysql://localhost:3306/elm?useUnicode=true&characterEncoding=utf-8&useSSL=false&serverTimezone=UTC
username: root
password: root
# 初始化大小笙僚,最小芳肌,最大
initial-size: 5
max-active: 20
min-idle: 3
# 配置獲取連接等待超時(shí)的時(shí)間
max-wait: 60000
# 配置間隔多久才進(jìn)行一次檢測(cè),檢測(cè)需要關(guān)閉的空閑連接肋层,單位是毫秒
time-between-eviction-runs-millis: 60000
# 配置一個(gè)連接在池中最小生存的時(shí)間亿笤,單位是毫秒
min-evictable-idle-time-millis: 300000
# 打開PSCache,并且指定每個(gè)連接上PSCache的大小
pool-prepared-statements: true
max-pool-prepared-statement-per-connection-size: 20
# 配置監(jiān)控統(tǒng)計(jì)攔截的 Filter栋猖,去掉后監(jiān)控界面 SQL 無法統(tǒng)計(jì)净薛,wall 用于防火墻 日志 log4j
filters: stat,wall,slf4j
# 通過connectProperties屬性來打開mergeSql功能;慢SQL記錄
connection-properties: druid.stat.mergeSql=true;druid.stat.slowSqlMillis=5000
1蒲拉、利用starter方式
引入依賴
<dependency>
<groupId>com.alibaba</groupId>
<artifactId>druid-spring-boot-starter</artifactId>
<version>1.1.20</version>
</dependency>
2肃拜、利用配置類方式
引入依賴
<dependency>
<groupId>com.alibaba</groupId>
<artifactId>druid</artifactId>
<version>1.1.9</version>
</dependency>
創(chuàng)建配置類
import javax.sql.DataSource;
import org.springframework.boot.context.properties.ConfigurationProperties;
import org.springframework.context.annotation.Bean;
import org.springframework.context.annotation.Configuration;
import com.alibaba.druid.pool.DruidDataSource;
@Configuration
public class DataSourceConfig {
@Bean
@ConfigurationProperties(prefix = "spring.datasource.druid")
public DataSource dataSource() {
return new DruidDataSource();
}
}