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

[GitBox <gi...@apache.org>]

taojintianxia commented on issue #9568:
URL: https://github.com/apache/shardingsphere/issues/9568#issuecomment-844999160


   hi , there
   following is the process I try to test the RQL
   
   1. I launched up 3 containers through docker compose, MySQL-A, MySQL-B, zookeeper
   
   2. switch the option `return context.getSqlStatement() instanceof DDLStatement;` in ExecuteProcessStrategyEvaluator.java
   
   3. compiled the shardingsphere project and unzip the proxy districution
   
   4. edit the config-sharding.yaml and luanch up proxy
   
   5. insert 2 million records by sysbench prepare 
   ```shell
   sysbench oltp_read_only        --mysql-host=127.0.0.1 --mysql-port=3307 --mysql-user=root --mysql-password='root' --mysql-db=sbtest --tables=10 --table-size=2000000 --report-interval=30  --time=180 --threads=16 --max-requests=0 --percentile=99  --mysql-ignore-errors="all" --range_selects=off --rand-type=uniform --auto_inc=off prepare
   ```
   this is the structure of test table
   
   ![image](https://user-images.githubusercontent.com/4112856/118969807-18635100-b9a0-11eb-9cbd-a3ed7b0d3ea8.png)
   
   
   6.try to delete one collumn by alter table clause 
   
   ```sql
   alter table sbtest1 drop c;
   ```
   
   7. since there are a lot of record in that table, this takes time....
   
   in the meanwhile


-- 
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:
users@infra.apache.org