r2dbc-pool icon indicating copy to clipboard operation
r2dbc-pool copied to clipboard

Could r2dbc pool provide a method/function to query connection infos in current pool?

Open CennyMo opened this issue 7 months ago • 0 comments

Feature Request

hopes to provide a method named getConnectionInfos() in ConnectionPool.class or PoolMetrics.class, which could return all connection info in current pool, and the connection info includes ip, port, and status(such as idle, close or running).

Is your feature request related to a problem? Please describe

When we performing pressure test (about 10tps) at r2dbc-mysql client, the database server shutdown and switches master to slave, and all the requests timeout after database has recovered. The exception throws by r2dbc-pool is "Connection acquisition timed out". We guess the connections may stuck in query when database shut down, and fail to be released. However, we have no means to check the status of these connections, which makes it difficult to locate the bugs.

CennyMo avatar Jul 09 '24 02:07 CennyMo