Druid参数配置

application.yml

    druid:
      initial-size: 5
      min-idle: 10
      max-active: 100
      max-wait: 60000
      # 链接重用
      keep-alive: true
      # 默认time-between-eviction-runs-millis * 2 (120s)
      keep-alive-between-time-millis: 100000
      # 每个链接使用1000次，达到后，该连接将被标记为不可用，并从连接池中移除。新的请求将会获取一个新的物理连接。
      phy-max-use-count: 1000
      # 添加回收机制
      remove-abandoned: true
      remove-abandoned-timeout: 300
      log-abandoned: false
      validation-query-timeout: 300
      validation-query: SELECT 'x'
      time-between-eviction-runs-millis: 60000
      min-evictable-idle-time-millis: 300000
      test-on-borrow: true
      test-on-return: true
      test-while-idle: true
      filter:
        # 开启druiddatasource的状态监控
        stat:
          # 关闭sql监控，防止内存泄露
          enabled: false
          db-type: mysql
          # 开启慢sql监控，超过500ms 就认为是慢sql，记录到日志中
          log-slow-sql: true
          slow-sql-millis: 3000
        # 日志监控，使用slf4j 进行日志输出
        slf4j:
          enabled: true
          statement-log-error-enabled: true
          statement-create-after-log-enabled: false
          statement-close-after-log-enabled: false
          result-set-open-after-log-enabled: false
          result-set-close-after-log-enabled: false
#        log4j2:
#          enabled: true
#          statement-log-enabled: false
#          statement-log-error-enabled: true
#          statement-executable-sql-log-enable: true # 打印可执行的sql
        wall:
          enabled: true #如果用P6Spy，则禁用
          config:
            multi-statement-allow: true
        config:
          enabled: true #启用druid 数据库密码加密
      connection-properties: config.decrypt=false;config.decrypt.key=${publickey}
      stat-view-servlet:
        enabled: true
        url-pattern: /druid/*
        reset-enable: false
        login-username: druid
        login-password: xxxxxx
        #允许访问的ip，不设置表示全部允许，例如：128.242.127.1/24。注：24表示，前面24位是子网掩码，比对的时候，前面24位相同就匹配。
        allow:
      web-stat-filter:
        enabled: true
        session-stat-enable: true
        url-pattern: /*
        exclusions: /static/*,*.ico,/druid/*

application-prod.yml

  datasource:
    url: jdbc:mysql://xxx.mysql.rds.aliyuncs.com:3306/xxx?allowMultiQueries=true&useSSL=false&useUnicode=true&characterEncoding=UTF-8&autoReconnect=true&zeroDateTimeBehavior=convertToNull&useJDBCCompliantTimezoneShift=true&useLegacyDatetimeCode=false&serverTimezone=GMT%2B8&nullCatalogMeansCurrent=true
    username: sa
    password: xxxxx
    druid:
      initial-size: 10
      min-idle: 20
      max-active: 100