spring:
datasource:
driver-class-name: com.mysql.cj.jdbc.Driver
druid:
# MySql、PostgreSQL、SqlServer、DaMeng校验
validation-query: select 1
# Oracle校验
#validation-query: select 1 from dual
validation-query-timeout: 2000
initial-size: 5
max-active: 20
min-idle: 5
max-wait: 60000
test-on-borrow: false
test-on-return: false
test-while-idle: true
time-between-eviction-runs-millis: 60000
min-evictable-idle-time-millis: 300000
stat-view-servlet:
enabled: true
login-username: 账号
login-password: 密码
allow: localhost,127.0.0.1,xxx.xxx.xxx.xxx
web-stat-filter:
enabled: true
url-pattern: /*
exclusions: '*.js,*.gif,*.jpg,*.bmp,*.png,*.css,*.ico,/druid/*'
session-stat-enable: true
session-stat-max-count: 10
filter: # Druid过滤器配置
stat: # SQL统计过滤器配置
enabled: true # 启用SQL统计过滤器
log-slow-sql: true # 启用慢SQL日志记录
slow-sql-millis: 1000 # 慢SQL的执行时间阈值(单位:毫秒)
访问url:
http://IP:PORT/druid/login.html