spring boot druid 配置

最新推荐文章于 2022-11-11 11:39:48 发布

weixin_33859504

最新推荐文章于 2022-11-11 11:39:48 发布

阅读量108

点赞数

文章标签：数据库 java python

原文链接：https://my.oschina.net/u/2490316/blog/1594540

版权

2019独角兽企业重金招聘Python工程师标准>>>

参考文档：

https://github.com/alibaba/druid/wiki/%E5%B8%B8%E8%A7%81%E9%97%AE%E9%A2%98

https://github.com/alibaba/druid/tree/master/druid-spring-boot-starter

maven:

<dependency>
   <groupId>com.alibaba</groupId>
   <artifactId>druid-spring-boot-starter</artifactId>
   <version>1.1.6</version>
</dependency>

application.properties 配置

spring.datasource.druid.initial-size=10
spring.datasource.druid.max-active=150
spring.datasource.druid.min-idle=10
spring.datasource.druid.max-wait=30000
#如果用Oracle,则把poolPreparedStatements配置为true,mysql可以配置为false
spring.datasource.druid.pool-prepared-statements=false
spring.datasource.druid.max-pool-prepared-statement-per-connection-size=10
#和上面的等价
#spring.datasource.druid.max-open-prepared-statements=
#oracle : SELECT 1 FROM DUAL      MYSQL :
spring.datasource.druid.validation-query=SELECT 'X'
#spring.datasource.druid.validation-query-timeout=
#是否在获得连接后检测其可用性
spring.datasource.druid.test-on-borrow=false
#是否在连接放回连接池后检测其可用性
spring.datasource.druid.test-on-return=false
#是否在连接空闲一段时间后检测其可用性
spring.datasource.druid.test-while-idle=true
#配置间隔多久才进行一次检测，检测需要关闭的空闲连接，单位是毫秒
spring.datasource.druid.time-between-eviction-runs-millis=60000
#配置一个连接在池中最小生存的时间，单位是毫秒
spring.datasource.druid.min-evictable-idle-time-millis=300000
#spring.datasource.druid.max-evictable-idle-time-millis=
spring.datasource.druid.filters=stat,wall,slf4j

# WebStatFilter配置，说明请参考Druid Wiki，配置_配置WebStatFilter
#是否启用StatFilter默认值true
spring.datasource.druid.web-stat-filter.enabled=true
spring.datasource.druid.web-stat-filter.url-pattern=/*
spring.datasource.druid.web-stat-filter.exclusions=*.js,*.gif,*.jpg,*.png,*.css,*.ico,/druid/*
#spring.datasource.druid.web-stat-filter.session-stat-enable=
#spring.datasource.druid.web-stat-filter.session-stat-max-count=
#spring.datasource.druid.web-stat-filter.principal-session-name=
#spring.datasource.druid.web-stat-filter.principal-cookie-name=
#spring.datasource.druid.web-stat-filter.profile-enable=

# StatViewServlet配置，说明请参考Druid Wiki，配置_StatViewServlet配置
#是否启用StatViewServlet默认值true
spring.datasource.druid.stat-view-servlet.enabled=true
spring.datasource.druid.stat-view-servlet.url-pattern=/druid/*
spring.datasource.druid.stat-view-servlet.reset-enable=
spring.datasource.druid.stat-view-servlet.login-username=root
spring.datasource.druid.stat-view-servlet.login-password=root
#spring.datasource.druid.stat-view-servlet.allow=
#spring.datasource.druid.stat-view-servlet.deny=

#慢SQL记录
spring.datasource.druid.filter.stat.slow-sql-millis=30000
spring.datasource.druid.filter.stat.log-slow-sql=true

#连接泄露  开启影响性能
spring.datasource.druid.remove-abandoned=true
#如果连接超过10分钟未关闭，就会被强行回收 单位秒
spring.datasource.druid.remove-abandoned-timeout=600
spring.datasource.druid.log-abandoned=true

#输出到日志
spring.datasource.druid.time-between-log-stats-millis=300000

转载于:https://my.oschina.net/u/2490316/blog/1594540