server:
|
port: 9090
|
servlet:
|
context-path: /api
|
|
mybatis:
|
configuration:
|
map-underscore-to-camel-case: true
|
mapper-locations: classpath*:/mapper/*.xml
|
|
|
spring:
|
datasource:
|
url: jdbc:mysql://47.106.172.9:2512/machine?serverTimezone=UTC&useUnicode=true&characterEncoding=utf8&useSSL=false
|
username: root
|
password: Zhxm2512209
|
driver-class-name: com.mysql.jdbc.Driver
|
type: com.alibaba.druid.pool.DruidDataSource
|
druid:
|
#初始化大小
|
initialSize: 5
|
#最小值
|
minIdle: 5
|
#最大值
|
maxActive: 20
|
#最大等待时间，配置获取连接等待超时，时间单位都是毫秒ms
|
maxWait: 60000
|
#配置间隔多久才进行一次检测，检测需要关闭的空闲连接
|
timeBetweenEvictionRunsMillis: 60000
|
#配置一个连接在池中最小生存的时间
|
minEvictableIdleTimeMillis: 300000
|
validationQuery: SELECT 1 FROM DUAL
|
testWhileIdle: true
|
testOnBorrow: false
|
testOnReturn: false
|
poolPreparedStatements: true
|
# 配置监控统计拦截的filters，去掉后监控界面sql无法统计，
|
#'wall'用于防火墙，SpringBoot中没有log4j，我改成了log4j2
|
filters: stat,wall,log4j2
|
#最大PSCache连接
|
maxPoolPreparedStatementPerConnectionSize: 20
|
useGlobalDataSourceStat: true
|
# 通过connectProperties属性来打开mergeSql功能；慢SQL记录
|
connectionProperties: druid.stat.mergeSql=true;druid.stat.slowSqlMillis=500
|
# 配置StatFilter
|
web-stat-filter:
|
#默认为false，设置为true启动
|
enabled: true
|
url-pattern: "/*"
|
exclusions: "*.js,*.gif,*.jpg,*.bmp,*.png,*.css,*.ico,/druid/*"
|
#配置StatViewServlet
|
stat-view-servlet:
|
url-pattern: "/druid/*"
|
#是否可以重置
|
reset-enable: true
|
#启用
|
enabled: true
|
