90yangkang opened a new issue, #37745:
URL: https://github.com/apache/shardingsphere/issues/37745
shardingsphereJDBC ：
<dependency>
<groupId>org.apache.shardingsphere</groupId>
<artifactId>shardingsphere-jdbc-core</artifactId>
<version>5.3.2</version>
</dependency>
My configuration is as follows:
sharding.yaml: |
databaseName: mall_db
dataSources:
haval:
dataSourceClassName: com.zaxxer.hikari.HikariDataSource
driverClassName: com.mysql.cj.jdbc.Driver
url:
jdbc:mysql://xxxx.cn:3306/xxx_db?useUnicode=true&characterEncoding=utf-8&useSSL=false&allowPublicKeyRetrieval=true&serverTimezone=Asia/Shanghai
username: root
password: root
connectionTimeoutMilliseconds: 60000
idleTimeoutMilliseconds: 60000
maxLifetimeMilliseconds: 300000
maximumPoolSize: 40
minimumIdle: 5
When the service started running, I used JMeter tool to call the API. The
SQL query (select * from information_schema.processlist where user='xxx' and
db='xxxx') showed a database connection count of 38. After I closed the JMeter
tool, the connection count dropped to below 5, which is lower than my
configured value (minimumIdle=5). Did I misspell the name of my configuration
item?
Thanks.
--
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]
