druid 配置

spring:
  application:
    name: singon-iot
  datasource:
    druid:
      url: jdbc:mysql://localhost:3306/test_collect_siyang?useSSl=ture&serverTimezone=UTC&useUnicode=true&characterEncoding=UTF-8
      username: root
      password: root
      driver-class-name: com.mysql.cj.jdbc.Driver
      # 连接池属性
      # 初始化连接数
      initial-size: 5
      # 最大连接数
      max-active: 20
      min-idle: 5
      # 最大等待时间
      max-wait: 60000
      time-between-eviction-runs-millis: 60000
      min-evictable-idle-time-millis: 300000
      # 设置从连接池获取连接时是否检查连接有效性
      test-on-borrow: false
      test-on-return: false
      test-while-idle: true
      validation-query: SELECT 1
      validation-query-timeout: 1000
      keep-alive: true
      remove-abandoned: true
      remove-abandoned-timeout: 180
      log-abandoned: true
      max-pool-prepared-statement-per-connection-size: 20
      filters: stat,wall,slf4j
      use-global-data-source-stat: true
      maxOpenPreparedStatements: 100
      connect-properties.mergeSql: true
      connect-properties.slowSqlMillis: 5000


版权声明:本文为weixin_44990255原创文章,遵循CC 4.0 BY-SA版权协议,转载请附上原文出处链接和本声明。