spring:
|
datasource:
|
name: mdc-plugin
|
type: com.alibaba.druid.pool.DruidDataSource
|
#druid相关配置
|
druid:
|
#监控统计拦截的filters
|
filters: stat
|
driver-class-name: com.mysql.cj.jdbc.Driver
|
#基本属性
|
url: jdbc:mysql://192.168.240.22:3306/hx_mdc?useUnicode=true&characterEncoding=utf8&useSSL=false&serverTimezone=UTC&allowPublicKeyRetrieval=true
|
username: mdc
|
password: Kknd_1234
|
#配置初始化大小/最小/最大
|
initial-size: 10
|
min-idle: 5
|
max-active: 250
|
#获取连接等待超时时间
|
max-wait: 30000
|
#间隔多久进行一次检测,检测需要关闭的空闲连接
|
time-between-eviction-runs-millis: 30000
|
#一个连接在池中最小生存的时间
|
min-evictable-idle-time-millis: 1800000
|
validation-query: SELECT 'x'
|
test-while-idle: true
|
test-on-borrow: true
|
test-on-return: false
|
#打开PSCache,并指定每个连接上PSCache的大小。oracle设为true,mysql设为false。分库分表较多推荐设置为false
|
# pool-prepared-statements: false
|
# max-pool-prepared-statement-per-connection-size: 20
|
task:
|
execution:
|
thread-name-prefix: mdc-
|
pool:
|
core-size: 150
|
max-size: 1000
|
keep-alive: 60
|
queue-capacity: 200
|
redis:
|
database: 0
|
host: 192.168.240.22
|
port: 6379
|
password: root
|
timeout: 3000
|
thymeleaf:
|
cache: false
|
|
collect:
|
interval: 10000
|