默认配置 HikariCP , druid

#HikariCP
spring.datasource.name = ts spring.datasource.url = jdbc:mysql://test.db.***.com:3306/forge?useUnicode=true
&autoReconnect=true&rewriteBatchedStatements=TRUE spring.datasource.username = *** spring.datasource.password = **** spring.datasource.type = com.zaxxer.hikari.HikariDataSource spring.datasource.driverClassName = com.mysql.jdbc.Driver spring.datasource.maximum-pool-size = 100 spring.datasource.minimum-idle = 1 spring.datasource.idle-timeout = 180000 spring.datasource.connection-timeout = 30000 spring.datasource.max-lifetime = 1800000 spring.datasource.connection-test-query = SELECT 1 spring.datasource.auto-commit = true
#druid spring.seconddatasource.type = com.alibaba.druid.pool.DruidDataSource spring.seconddatasource.driverClassName = com.mysql.jdbc.Driver spring.seconddatasource.url = jdbc:mysql://test.db.****.com:3306/teacher?useUnicode=true
&autoReconnect=true&rewriteBatchedStatements=TRUE spring.seconddatasource.username = *** spring.seconddatasource.password = **** spring.seconddatasource.initialSize = 5 spring.seconddatasource.minIdle = 5 spring.seconddatasource.maxActive = 100 spring.seconddatasource.maxWait = 60000 spring.seconddatasource.timeBetweenEvictionRunsMillis = 60000 spring.seconddatasource.minEvictableIdleTimeMillis = 300000 spring.seconddatasource.validationQuery = SELECT 1 FROM DUAL spring.seconddatasource.testWhileIdle = true spring.seconddatasource.testOnBorrow = true spring.seconddatasource.testOnConnect = true spring.seconddatasource.testOnReturn = true spring.seconddatasource.poolPreparedStatements = true spring.seconddatasource.maxPoolPreparedStatementPerConnectionSize = 20

 

posted @ 2020-06-30 16:20  隔壁w王叔叔  阅读(274)  评论(0)    收藏  举报