You are viewing a plain text version of this content. The canonical link for it is here.
Posted to notifications@shardingsphere.apache.org by GitBox <gi...@apache.org> on 2022/10/10 06:37:32 UTC
[GitHub] [shardingsphere] wingkingbobo opened a new issue, #19085: Is there any way to monitor the connection pool
wingkingbobo opened a new issue, #19085:
URL: https://github.com/apache/shardingsphere/issues/19085
## Question
Is there any way to monitor the connection pool like druid monitor？
Recently, I have encountered several times in the online environment that the sharding proxy database connection is unavailable, which will occur one day to one month after the server is started.
At this time, I try to use Navicat to test the direct connection to MySQL. It can connect, but it can't connect to sharding proxy.
The log is as follows:
```
### Error querying database. Cause: org.springframework.jdbc.CannotGetJdbcConne
ctionException: Failed to obtain JDBC Connection; nested exception is java.sql.S
QLTransientConnectionException: HikariPool-1 - Connection is not available, requ
est timed out after 30001ms.
### The error may exist in com/xxx/dao/XXDao.java (b
est guess)
### The error may involve com.xxx.dao.XXDao.selectXXByID
### The error occurred while executing a query
### Cause: org.springframework.jdbc.CannotGetJdbcConnectionException: Failed to
obtain JDBC Connection; nested exception is java.sql.SQLTransientConnectionExcep
tion: HikariPool-1 - Connection is not available, request timed out after 30001m
s.
```
I hope there is a way to monitor the status of sharding proxy connection pool. Can you give me some suggestions.
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: notifications-unsubscribe@shardingsphere.apache.org.apache.org
For queries about this service, please contact Infrastructure at:
users@infra.apache.org
[GitHub] [shardingsphere] terrymanu commented on issue #19085: Is there any way to monitor the connection pool
Posted by GitBox <gi...@apache.org>.
terrymanu commented on issue #19085:
URL: https://github.com/apache/shardingsphere/issues/19085#issuecomment-1185712265
Did you mean database connection pool monitor?
--
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: notifications-unsubscribe@shardingsphere.apache.org
For queries about this service, please contact Infrastructure at:
users@infra.apache.org
[GitHub] [shardingsphere] TeslaCN commented on issue #19085: Is there any way to monitor the connection pool
Posted by GitBox <gi...@apache.org>.
TeslaCN commented on issue #19085:
URL: https://github.com/apache/shardingsphere/issues/19085#issuecomment-1204950947
There is a related issue https://github.com/apache/shardingsphere/issues/15695
--
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: notifications-unsubscribe@shardingsphere.apache.org
For queries about this service, please contact Infrastructure at:
users@infra.apache.org
[GitHub] [shardingsphere] TeslaCN commented on issue #19085: Is there any way to monitor the connection pool
Posted by GitBox <gi...@apache.org>.
TeslaCN commented on issue #19085:
URL: https://github.com/apache/shardingsphere/issues/19085#issuecomment-1204930727
Hikari metrics could be exported by JMX.
--
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: notifications-unsubscribe@shardingsphere.apache.org
For queries about this service, please contact Infrastructure at:
users@infra.apache.org
[GitHub] [shardingsphere] linghengqian commented on issue #19085: Is there any way to monitor the connection pool
Posted by GitBox <gi...@apache.org>.
linghengqian commented on issue #19085:
URL: https://github.com/apache/shardingsphere/issues/19085#issuecomment-1367148745
@wingkingbobo
- - Druid Monitor seems to have been a Servlet application that lacked maintenance. Isn't APM a better choice if you're just thinking about monitoring SQL and execution? I'm assuming you're using Apache Skywalking.
- For JDBC pool properties, do you not know how to wrap DistSQL results into a visual platform like Apache SuperSet?
--
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: notifications-unsubscribe@shardingsphere.apache.org
For queries about this service, please contact Infrastructure at:
users@infra.apache.org
[GitHub] [shardingsphere] terrymanu commented on issue #19085: Is there any way to monitor the connection pool
Posted by GitBox <gi...@apache.org>.
terrymanu commented on issue #19085:
URL: https://github.com/apache/shardingsphere/issues/19085#issuecomment-1193578603
HikariCP can export the monitor data to Prometheus, but the codes do not implement in ShardingSphere yet. Do you interest to finish the feature?
--
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: notifications-unsubscribe@shardingsphere.apache.org
For queries about this service, please contact Infrastructure at:
users@infra.apache.org
[GitHub] [shardingsphere] susongyan commented on issue #19085: Is there any way to monitor the connection pool
Posted by GitBox <gi...@apache.org>.
susongyan commented on issue #19085:
URL: https://github.com/apache/shardingsphere/issues/19085#issuecomment-1379849919
follow open-telemetry
report by gauges for active/total/waiting/idle numbers ?
--
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: notifications-unsubscribe@shardingsphere.apache.org
For queries about this service, please contact Infrastructure at:
users@infra.apache.org
[GitHub] [shardingsphere] github-actions[bot] closed issue #19085: Is there any way to monitor the connection pool
Posted by GitBox <gi...@apache.org>.
github-actions[bot] closed issue #19085: Is there any way to monitor the connection pool
URL: https://github.com/apache/shardingsphere/issues/19085
--
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: notifications-unsubscribe@shardingsphere.apache.org
For queries about this service, please contact Infrastructure at:
users@infra.apache.org
[GitHub] [shardingsphere] sunkai-cai commented on issue #19085: Is there any way to monitor the connection pool
Posted by GitBox <gi...@apache.org>.
sunkai-cai commented on issue #19085:
URL: https://github.com/apache/shardingsphere/issues/19085#issuecomment-1201948407
Let me try it.
--
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: notifications-unsubscribe@shardingsphere.apache.org
For queries about this service, please contact Infrastructure at:
users@infra.apache.org
[GitHub] [shardingsphere] huang714669 commented on issue #19085: Is there any way to monitor the connection pool
Posted by "huang714669 (via GitHub)" <gi...@apache.org>.
huang714669 commented on issue #19085:
URL: https://github.com/apache/shardingsphere/issues/19085#issuecomment-1489929985
now, can ShardingSphere get monitor data of HikariCP and export it to Prometheus, which version? and how to configure this.
--
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: notifications-unsubscribe@shardingsphere.apache.org
For queries about this service, please contact Infrastructure at:
users@infra.apache.org
[GitHub] [shardingsphere] wingkingbobo commented on issue #19085: Is there any way to monitor the connection pool
Posted by GitBox <gi...@apache.org>.
wingkingbobo commented on issue #19085:
URL: https://github.com/apache/shardingsphere/issues/19085#issuecomment-1186682142
@terrymanu
Yes, I want to monitor the connection pool used by sharding proxy when connecting to the real database.
I tried to change the configuration to Druid, but sharding proxy doesn't seem to support it.
`org.apache. shardingsphere.proxy. backend.config.yaml.Yamlproxydatasourceconfiguration` does not provide a similar `spring.datasource. type=com. alibaba. druid. pool. Druiddatasource` configuration. It uses Hikari by default.
Then I used jconsole to check the MBean and found no information related to the database connection pool.
--
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: notifications-unsubscribe@shardingsphere.apache.org
For queries about this service, please contact Infrastructure at:
users@infra.apache.org
[GitHub] [shardingsphere] github-actions[bot] commented on issue #19085: Is there any way to monitor the connection pool
Posted by GitBox <gi...@apache.org>.
github-actions[bot] commented on issue #19085:
URL: https://github.com/apache/shardingsphere/issues/19085#issuecomment-1272349394
Hello , this issue has not received a reply for several days.
This issue is supposed to be closed.
--
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: notifications-unsubscribe@shardingsphere.apache.org
For queries about this service, please contact Infrastructure at:
users@infra.apache.org