taojintianxia commented on issue #9568:
URL: https://github.com/apache/shardingsphere/issues/9568#issuecomment-857651087
hi , there
today I tried several times to test this function. followings are the
precodiction :
1. raise up 5 mysql instance and insert 1 million data
2. luanch up a "brand new" zk
3. established a proxy with sharding rule
when proxy is start up, I execute a shell like following :
```
#!/bin/bash
export MYSQL_PWD=root
for (( i = 0; i < 10000000; i=(i+step) )); do
mysql -h127.0.0.1 -P3307 -uroot -Dsharding_db -e "show processlist;" |
tee -a result.txt | echo "\n" | tee -a result.txt
done
exit 0
```
this shell will print out the `show processlist;` in a very shot interval .
Unfortunately, it always print 0/5 as the status.
I just cut part of the result :
```
Id User Host db Command Time State Info
56045088-4ad3-41b4-b2e5-447af0840e1f root 127.0.0.1 sharding_db
Execute 1562 Executing 0/5
Id User Host db Command Time State Info
56045088-4ad3-41b4-b2e5-447af0840e1f root 127.0.0.1 sharding_db
Execute 1562 Executing 0/5
Id User Host db Command Time State Info
56045088-4ad3-41b4-b2e5-447af0840e1f root 127.0.0.1 sharding_db
Execute 1562 Executing 0/5
Id User Host db Command Time State Info
56045088-4ad3-41b4-b2e5-447af0840e1f root 127.0.0.1 sharding_db
Execute 1562 Executing 0/5
Id User Host db Command Time State Info
56045088-4ad3-41b4-b2e5-447af0840e1f root 127.0.0.1 sharding_db
Execute 1562 Executing 0/5
Id User Host db Command Time State Info
56045088-4ad3-41b4-b2e5-447af0840e1f root 127.0.0.1 sharding_db
Execute 1562 Executing 0/5
Id User Host db Command Time State Info
56045088-4ad3-41b4-b2e5-447af0840e1f root 127.0.0.1 sharding_db
Execute 1562 Executing 0/5
Id User Host db Command Time State Info
56045088-4ad3-41b4-b2e5-447af0840e1f root 127.0.0.1 sharding_db
Execute 1562 Executing 0/5
Id User Host db Command Time State Info
56045088-4ad3-41b4-b2e5-447af0840e1f root 127.0.0.1 sharding_db
Execute 1562 Executing 0/5
Id User Host db Command Time State Info
56045088-4ad3-41b4-b2e5-447af0840e1f root 127.0.0.1 sharding_db
Execute 1562 Executing 0/5
Id User Host db Command Time State Info
56045088-4ad3-41b4-b2e5-447af0840e1f root 127.0.0.1 sharding_db
Execute 1562 Executing 0/5
Id User Host db Command Time State Info
56045088-4ad3-41b4-b2e5-447af0840e1f root 127.0.0.1 sharding_db
Execute 1562 Executing 0/5
Id User Host db Command Time State Info
56045088-4ad3-41b4-b2e5-447af0840e1f root 127.0.0.1 sharding_db
Execute 1562 Executing 0/5
Id User Host db Command Time State Info
56045088-4ad3-41b4-b2e5-447af0840e1f root 127.0.0.1 sharding_db
Execute 1562 Executing 0/5
Id User Host db Command Time State Info
56045088-4ad3-41b4-b2e5-447af0840e1f root 127.0.0.1 sharding_db
Execute 1562 Executing 0/5
Id User Host db Command Time State Info
56045088-4ad3-41b4-b2e5-447af0840e1f root 127.0.0.1 sharding_db
Execute 1562 Executing 0/5
Id User Host db Command Time State Info
56045088-4ad3-41b4-b2e5-447af0840e1f root 127.0.0.1 sharding_db
Execute 1562 Executing 0/5
Id User Host db Command Time State Info
56045088-4ad3-41b4-b2e5-447af0840e1f root 127.0.0.1 sharding_db
Execute 1562 Executing 0/5
Id User Host db Command Time State Info
56045088-4ad3-41b4-b2e5-447af0840e1f root 127.0.0.1 sharding_db
Execute 1562 Executing 0/5
Id User Host db Command Time State Info
56045088-4ad3-41b4-b2e5-447af0840e1f root 127.0.0.1 sharding_db
Execute 1562 Executing 0/5
Id User Host db Command Time State Info
56045088-4ad3-41b4-b2e5-447af0840e1f root 127.0.0.1 sharding_db
Execute 1562 Executing 0/5
Id User Host db Command Time State Info
56045088-4ad3-41b4-b2e5-447af0840e1f root 127.0.0.1 sharding_db
Execute 1562 Executing 0/5
Id User Host db Command Time State Info
56045088-4ad3-41b4-b2e5-447af0840e1f root 127.0.0.1 sharding_db
Execute 1562 Executing 0/5
Id User Host db Command Time State Info
56045088-4ad3-41b4-b2e5-447af0840e1f root 127.0.0.1 sharding_db
Execute 1562 Executing 0/5
Id User Host db Command Time State Info
56045088-4ad3-41b4-b2e5-447af0840e1f root 127.0.0.1 sharding_db
Execute 1562 Executing 0/5
Id User Host db Command Time State Info
56045088-4ad3-41b4-b2e5-447af0840e1f root 127.0.0.1 sharding_db
Execute 1562 Executing 0/5
Id User Host db Command Time State Info
56045088-4ad3-41b4-b2e5-447af0840e1f root 127.0.0.1 sharding_db
Execute 1562 Executing 0/5
```
BTW, it works if I set the suspend point in idea :), I saw the 1/5 .... but
not in this way.
--
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]
