natehuangting commented on PR #21000: URL: https://github.com/apache/shardingsphere/pull/21000#issuecomment-1248892049
> This pr will show the proxy front sleep connection? But curent show processlist logic show the backend execution. It will show all the connection status, including the background sleep in execution. ``` mysql> show processlist; +--------------------------------------+------+-----------+-------------+---------+------+-------+------+ | Id | User | Host | db | Command | Time | State | Info | +--------------------------------------+------+-----------+-------------+---------+------+-------+------+ | cb9e262f-2833-4925-2d8b-f905237c58c6 | root | 127.0.0.1 | sharding_XA | Sleep | 14 | | | +--------------------------------------+------+-----------+-------------+---------+------+-------+------+ 1 row in set (0.02 sec) mysql> show processlist; +--------------------------------------+------+-----------+-------------+---------+------+---------------+-----------------------+ | Id | User | Host | db | Command | Time | State | Info | +--------------------------------------+------+-----------+-------------+---------+------+---------------+-----------------------+ | cb9e262f-2833-4925-2d8b-f905237c58c6 | root | 127.0.0.1 | sharding_XA | Sleep | 40 | | | | fc646062-99fc-2556-d42e-257dc7c9c621 | root | 127.0.0.1 | sharding_xa | Execute | 2 | Executing 0/2 | select * from t_order | +--------------------------------------+------+-----------+-------------+---------+------+---------------+-----------------------+ 2 rows in set (0.03 sec) ``` -- 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]
