How to configure the property mode of hikari connection pool in spring boot
Editor to share with you how to configure hikari connection pool properties in spring boot, I believe most people do not know much about it, so share this article for your reference, I hope you can learn a lot after reading this article, let's go to know it!
Spring boot configure hikari connection Pool Properties
The cause of the event is that Young GC often occurs in a simple application, and GC (Allocation Failure) often occurs even when there is no number of requests. Later, using mat tool to analyze, it is found that the class related to mysql connection actually accounts for 40% + in-heap space.
Only to find that the connection pool size of spring boot is not configured, and the default is 10 connections, but in fact, the application does not need so many.
The class "com.mysql.cj.jdbc.AbandonedConnectionCleanupThread", loaded by "org.apache.catalina.loader.ParallelWebappClassLoader @ 0xf8dfdf30", occupies 19279792 (41.23%) bytes. The memory is accumulated in one instance of "java.util.concurrent.ConcurrentHashMap$Node []" loaded by ".spring-boot default connection pool
In spring-boot, load the connection pool according to the following three priorities
1) if there is HikariCP in classpath, it is preferred.
2) if the Tomcat pooling connection pool is available, it will be selected
3) if there is none of the above, Commons DBCP2 connection pool will be selected.
Hikari configuration
Here we do a very low configuration (this is just a very low-traffic system), if the default server, it is recommended that the default configuration is sufficient.
Spring.datasource.hikari.maximum-pool-size=2spring.datasource.hikari.minimum-idle=1spring.datasource.hikari.idle-timeout=600000spring.datasource.hikari.max-lifetime=1800000spring.datasource.hikari.connection-timeout=500spring.datasource.hikari.login-timeout=500spring.datasource.hikari.validation-timeout=1000spring.datasource.hikari.initialization-fail-timeout=1000
Reference link
Hikari connection Pool configuration instructions # # Database configuration spring.datasource.type=com.zaxxer.hikari.HikariDataSourcespring.datasource.driverClassName = com.mysql.jdbc.Driverspring.datasource.url = jdbc:mysql://localhost:3306/ssm?useUnicode=true&characterEncoding=utf-8&useSSL=falsespring.datasource.username = rootspring.datasource.password = root## Hikari connection Pool configuration-for more configuration, please visit: https://github.com/brettwooldridge/HikariCP## minimum idle connection Number of spring.datasource.hikari.minimum-idle=5## idle connections maximum survival time Default is 600000 (10 minutes) maximum number of connections in the spring.datasource.hikari.idle-timeout=180000## connection pool. Default is 10spring.datasource.hikari.maximum-pool-size=10##. This attribute controls the default autocommit behavior of connections returned from the pool. Default: truespring.datasource.hikari.auto-commit=true## connection pool name spring.datasource.hikari.pool-name=MyHikariCP## this attribute controls the maximum life cycle of connections in the pool, with a value of 0 indicating unlimited life cycle. Default 1800000 is 30 minutes spring.datasource.hikari.max-lifetime=1800000## database connection timeout, default 30 seconds, that is, above 30000spring.datasource.hikari.connection-timeout=30000spring.datasource.hikari.connection-test-query=SELECT 1 is "how to configure hikari connection pool properties in spring boot" all the content of this article, thank you for reading! I believe we all have a certain understanding, hope to share the content to help you, if you want to learn more knowledge, welcome to follow the industry information channel!
