|  |  | 
 |  |  |       #name: sp | 
 |  |  |       type: com.alibaba.druid.pool.DruidDataSource | 
 |  |  |       driverClassName: com.mysql.cj.jdbc.Driver | 
 |  |  | #      url: jdbc:mysql://192.168.40.166:3306/pipIrr_sp?useUnicode=true&characterEncoding=utf-8&autoReconnect=true&useSSL=false&serverTimezone=GMT%2B8&zeroDateTimeBehavior=convertToNull | 
 |  |  |       url: jdbc:mysql://127.0.0.1:3306/pipIrr_sp?useUnicode=true&characterEncoding=utf-8&autoReconnect=true&useSSL=false&serverTimezone=GMT%2B8&zeroDateTimeBehavior=convertToNull | 
 |  |  |       url: jdbc:mysql://192.168.40.166:3306/pipIrr_sp?useUnicode=true&characterEncoding=utf-8&autoReconnect=true&useSSL=false&serverTimezone=GMT%2B8&zeroDateTimeBehavior=convertToNull | 
 |  |  | #      url: jdbc:mysql://127.0.0.1:3306/pipIrr_sp?useUnicode=true&characterEncoding=utf-8&autoReconnect=true&useSSL=false&serverTimezone=GMT%2B8&zeroDateTimeBehavior=convertToNull | 
 |  |  | #      url: jdbc:mysql://8.140.179.55:3306/pipIrr_sp?useUnicode=true&characterEncoding=utf-8&autoReconnect=true&useSSL=false&serverTimezone=GMT%2B8&zeroDateTimeBehavior=convertToNull | 
 |  |  |       username: root | 
 |  |  |       password: dysql,;.abc!@# | 
 |  |  |       druid: | 
 |  |  | 
 |  |  |         #配置初始化大小、最小、最大 | 
 |  |  |         initialSize: 10 | 
 |  |  |         minIdle: 10 | 
 |  |  |         maxActive: 200 | 
 |  |  |         maxActive: 100 | 
 |  |  |         # 获取连接时最大等待时间,单位毫秒。配置了maxWait之后,缺省启用公平锁,并发效率会有所下降,如果需要可以通过配置useUnfairLock属性为true使用非公平锁 | 
 |  |  |         maxWait: 60000 | 
 |  |  |         #配置间隔多久进行一次检测,检测需要关闭的空闲连接,单位毫秒。 默认是60s,太长可能会导致无法及时检测到连接中断 |