[GitHub] [shardingsphere] taojintianxia edited a comment on issue #9568: [New Feature] Support to show execution process for running SQLs by RQL

Mon, 07 Jun 2021 04:34:40 -0700 


taojintianxia edited a comment on issue #9568:
URL: https://github.com/apache/shardingsphere/issues/9568#issuecomment-855846139


   Preconditions :
     - luanch up 2 mysql instance by docker
     - luanch up zk by docker
     - compiled by up to date shardingsphere and luanch up the proxy 
distribution
     - data shard by database rule ds_{ user_id % 2}
     - insert 1.5m records
   
   execute a sql last a little bit more time `alter table t_order drop status;` 
, it last about (6.07 sec) 
   at the same time, open up a new window to connect to proxy and execute `show 
processlist;`
   
   
![image](https://user-images.githubusercontent.com/4112856/121009854-3960da00-c7c7-11eb-8d6d-0f66dd209591.png)
   
   after serveral times of executing `show processlist;`, the alter table sql 
finished , `show processlist` returns empty set.


-- 
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.

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

Reply via email to