假设 mysql设置60秒
wait_timeout=60
springboot 配置文件:
spring.datasource.connection-test-query=select 1 from dual
spring.datasource.validation-query=select 1 from dual
spring.datasource.idle-timeout=30000
spring.datasource.max-lifetime=35000
spring.datasource.pool-name=MySqlHikariCP
spring.datasource.maximum-pool-size=50
spring.datasource.minimum-idle=5
spring.datasource.test-on-borrow=true
spring.datasource.test-while-idle=true
spring.datasource.remove-abandoned-timeout=30
spring.datasource.remove-abandoned=true