123456789101112131415161718192021222324252627282930313233343536373839404142434445464748495051525354555657585960616263646566676869707172737475767778798081828384858687888990919293949596979899100101102 |
- # 数据源配置
- spring:
- datasource:
- dynamic:
- primary: mysql #设置默认的数据源或者数据源组,默认值即为master
- datasource:
- mysql:
- # url: jdbc:mysql://192.168.1.205:3306/nerp-test?useUnicode=true&characterEncoding=utf8&zeroDateTimeBehavior=convertToNull&useSSL=true&serverTimezone=GMT%2B8&autoReconnect=true&rewriteBatchedStatements=true
- url: jdbc:mysql://49.4.78.194:17136/nerp-test?useUnicode=true&characterEncoding=utf8&zeroDateTimeBehavior=convertToNull&useSSL=true&serverTimezone=GMT%2B8&autoReconnect=true&rewriteBatchedStatements=true
- username: root
- password: '!QAZ2root'
- driver-class-name: com.mysql.cj.jdbc.Driver
- type: com.alibaba.druid.pool.DruidDataSource
- druid:
- # 初始连接数
- initial-size: 5
- # 最小连接池数量
- min-idle: 10
- # 最大连接池数量
- max-active: 20
- # 配置获取连接等待超时的时间
- max-wait: 60000
- # 配置一个连接在池中最小生存的时间,单位是毫秒
- min-evictable-idle-time-millis: 300000
- # 配置一个连接在池中最大生存的时间,单位是毫秒
- max-evictable-idle-time-millis: 900000
- # 配置间隔多久才进行一次检测,检测需要关闭的空闲连接,单位是毫秒
- time-between-eviction-runs-millis: 60000
- # 配置检测连接是否有效
- test-while-idle: true
- test-on-borrow: false
- test-on-return: false
- validation-query: select 1
- validation-query-timeout: -1
- webStatFilter:
- enabled: true
- statViewServlet:
- enabled: true
- # 设置白名单,不填则允许所有访问
- allow:
- url-pattern: /druid/*
- # 控制台管理用户名和密码
- login-username: nerp
- login-password: nerp
- filter:
- stat:
- enabled: true
- # 慢SQL记录
- log-slow-sql: true
- slow-sql-millis: 1000
- merge-sql: true
- wall:
- config:
- multi-statement-allow: true
- tdengine:
- url: jdbc:TAOS://192.168.1.208:6030/nerp_db
- username: root
- password: 123456
- driver-class-name: com.taosdata.jdbc.TSDBDriver
- type: com.alibaba.druid.pool.DruidDataSource
- druid:
- initial-size: 5
- min-idle: 5
- max-active: 5
- # redis 配置
- redis:
- # 地址
- # host: 192.168.1.205
- host: 49.4.78.194
- # 端口,默认为6379
- # port: 6379
- port: 17137
- # 数据库索引
- database: 0
- # 密码
- password: jiayue
- # 连接超时时间
- timeout: 10s
- lettuce:
- pool:
- # 连接池中的最小空闲连接
- min-idle: 0
- # 连接池中的最大空闲连接
- max-idle: 8
- # 连接池的最大数据库连接数
- max-active: 8
- # #连接池最大阻塞等待时间(使用负值表示没有限制)
- max-wait: -1ms
- #mybatis-plus:
- # configuration:
- # log-impl: org.apache.ibatis.logging.stdout.StdOutImpl #开启sql日志
- file:
- outPutDir: "D:\\out\\new\\"
- excelDir: "D:\\analysisData\\new\\"
- outPutBackDir: "D:\\out\\backUps\\"
- excelBackDir: "D:\\analysisData\\backUps\\"
- email:
- user: "wanghongchen942"
- password: "LXQDEOCRCSXWBIAO"
- host: "imap.126.com"
- path: "d:\\in\\"
|