git-chenhao opened a new issue #14299:
URL: https://github.com/apache/shardingsphere/issues/14299


   ShardingSphere-Proxy 5.0.0-Alpha
   
   HikariCP 4.0.4-SNAPSHOT
   
   ### Expected behavior
   Application -> Proxy
   HikariCP HikariDataSource.getConnection() Less than 1s
   metrics hikaricp_connections_acquire_seconds_max < 1s
   
   Proxy-DB 
   metrics hikaricp_connections_acquire_seconds_max < 1s
   
   
   ### Actual behavior
   Application -> Proxy
   many times hikaricp_connections_acquire_seconds_max 3s around
   
![image](https://user-images.githubusercontent.com/20919316/147340452-856d1474-8ed0-4f7c-8fbe-c9991d1ea909.png)
   
   Proxy-DB hikaricp_connections_acquire_seconds_max < 1s
   
   
   ### Supplement
   
   Application HikariCP config
   `spring.datasource.hikari.max-lifetime=300000
   spring.datasource.hikari.leak-detection-threshold=30000
   spring.datasource.hikari.minimum-idle=32
   spring.datasource.hikari.maximum-pool-size=64
   spring.datasource.driver-class-name=com.mysql.jdbc.Driver
   spring.datasource.hikari.idle-timeout=30000
   spring.datasource.hikari.connection-test-query=SELECT 'x'
   `
   
   Application -> Proxy  Network  is normal


-- 
This is an automated message from the Apache Git Service.
To respond to the message, please log on to GitHub and use the
URL above to go to the specific comment.

To unsubscribe, e-mail: [email protected]

For queries about this service, please contact Infrastructure at:
[email protected]


Reply via email to