techhero-component-task-anhui-dev-mysql.yml 1.28 KB
Newer Older
1 2 3 4 5 6 7 8 9 10 11 12 13 14 15 16 17 18 19 20 21 22
spring:
  datasource:
    type: com.alibaba.druid.pool.DruidDataSource
    url: jdbc:mysql://192.168.50.248:3306/task_ah?useUnicode=true&characterEncoding=utf-8&useSSL=false&serverTimezone=GMT%2B8
    username: root
    password: umBm*7gYm3AB
    driverClassName: com.mysql.cj.jdbc.Driver
    druid:
      initialSize: 5                                  #初始化提供的连接数
      minIdle: 5                                      #数据库连接池的最小维持连接数
      maxActive: 20                                   #最大的连接数
      maxWait: 60000
      timeBetweenEvictionRunsMillis: 60000            #空闲时间超过minEvictableIdleTimeMillis的连接则释放
      minEvictableIdleTimeMillis: 300000              #等待连接获取的最大超时时间
      validationQuery: SELECT 1 FROM DUAL             #启动开启检查连接性
      filters: stat,slf4j                             #监控配置
      connectionProperties: druid.stat.mergeSql=true;druid.stat.slowSqlMillis=5000  # 通过connectProperties属性来打开mergeSql功能;慢SQL记录
      useGlobalDataSourceStat: true                   # 合并多个DruidDataSource的监控数据
    filter:
      commons-log:
        statement-log-enabled: true
        statement-executable-sql-log-enable: true