tristaZero opened a new issue #9568:
URL: https://github.com/apache/shardingsphere/issues/9568


   Hi, community,
   
   This is a new plan to support showing the execution process for running 
SQLs, especially for DML/DDL always needing much time to run. With my thinking, 
there are three main tasks for this new feature.
   
   The basic process is **Job ID generation, job status report to governance, 
get current job status by SQL from governance**.
   
   ### Tasks
   #### Generate Job IDs
   - [x] Generate UUID for this job's trunk and its branches
   - [x] Pass these IDs through the whole execution
   
   #### Report execution process from one Proxy
   - [ ] `ExecutorEngine` reports the context (IDs, beginTime, etc.) of each 
query to `governance`
   - [x] Each branch job reports its status and ID to `governance` once it 
finishes in `ExecutorCallback`
   - [ ] `Governance`  handles these requests synchronously
   
   #### Query execution process from other Proxies
   - [ ] It is triggered by `show processlist`
   - [ ] Get the execution status from all the jobs  from `governance`
   - [ ] Make up the result based on `show processlist`' original result with 
the collected data
   
   


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