springBoot:
sql速度慢的解決方法团南,在springboot.yml 加上:
# Hikari will use the above plus the following to setup connection pooling
spring.datasource.type=com.zaxxer.hikari.HikariDataSource
spring.datasource.hikari.minimum-idle=5
spring.datasource.hikari.maximum-pool-size=15
spring.datasource.hikari.auto-commit=true
spring.datasource.hikari.idle-timeout=30000
spring.datasource.hikari.pool-name=HikariCP
spring.datasource.hikari.max-lifetime=1800000
spring.datasource.hikari.connection-timeout=30000
spring.datasource.hikari.connection-test-query=SELECT 1
springboot2.0之后亡脑,自帶了一個(gè)號(hào)稱全世界最快的連接池hikari叮盘,直接在配置文件里加上以上配置即可
原創(chuàng):https://www.cnblogs.com/blog5277/p/10660689.html厢汹,還有關(guān)于監(jiān)聽(tīng)器的配置