application-db-mysql.yml

spring:
  datasource:
    druid:
      #监控统计拦截的filters
      filters: stat
      web-stat-filter:
        enabled: true #是否启用StatFilter默认值true
        url-pattern: /*
        exclusions: /druid/*,*.js,*.gif,*.jpg,*.bmp,*.png,*.css,*.ico
        session-stat-enable: true
        session-stat-max-count: 10
      stat-view-servlet:
        # 是否启用statViewServlet配置
        enabled: true
        # 访问监控页面
        url-pattern: "/druid/*"
        # 禁止手动重置监控数据
        reset-enable: false
        # 设置监控页面的登陆名
        login-username: root
        # 设置监控页面的登陆密码
        login-password: root
        allow:
      #慢SQL
      filter:
        stat:
          merge-sql: true
          slow-sql-millis: 10000
          log-slow-sql: true
    dynamic:
      primary: mysql
      strict: false
      druid:
        #配置初始化大小/最小/最大
        initial-size: 1
        min-idle: 1
        max-active: 20
        #获取连接等待超时时间
        max-wait: 60000
        #间隔多久进行一次检测，检测需要关闭的空闲连接
        time-between-eviction-runs-millis: 60000
        #一个连接在池中最小生存的时间
        min-evictable-idle-time-millis: 30000
        validation-query: SELECT 'x' FROM DUAL
        test-while-idle: true
        test-on-borrow: false
        test-on-return: false
        #打开PSCache，并指定每个连接上PSCache的大小。oracle设为true，mysql设为false。分库分表较多推荐设置为false
        pool-prepared-statements: false
        max-pool-prepared-statement-per-connection-size: 20
        filters: stat
      datasource:
        mysql:
          #          username: ${MYSQL_USERNAME:root}
          #          password: Q2WOs9GI65/kbak1jftbxtyRboBtXqRWSERIwDm3zHPgfqqNkeXbHVj7g+ZDwj9sx8Dbxnqv22/M8TceQsLtqQ==
          #          password: ${MYSQL_PASSWORD:qazwsx.101}
          #          url: jdbc:mysql://${MYSQL_IP:10.10.80.93}:${MYSQL_PORT:13306}/${MYSQL_DATABASE:zlmy}?tinyInt1isBit=false&useUnicode=true&autoReconnect=true&useSSL=false&characterEncoding=UTF8&allowMultiQueries=true&serverTimezone=Asia/Shanghai&nullCatalogMeansCurrent=true
          username: root
          password: ZLmy!@#$
          url: jdbc:mysql://192.168.1.5:3306/zlmy?tinyInt1isBit=false&useUnicode=true&autoReconnect=true&useSSL=false&characterEncoding=UTF8&allowMultiQueries=true&serverTimezone=Asia/Shanghai&nullCatalogMeansCurrent=true
          driver-class-name: com.mysql.cj.jdbc.Driver