可以看到按照KILL TIDB语法执行后，查询依旧还在
tidb@prod-asset-tipd-e01:~$ mysql -h 172.18.244.30 -P 4000 -u root -p
Enter password:
Welcome to the MySQL monitor. Commands end with ; or \g.
Your MySQL connection id is 643287
Server version: 5.7.25-TiDB-v5.1.0 TiDB Server (Apache License 2.0) Community Edition, MySQL 5.7 compatible
Copyright (c) 2000, 2021, Oracle and/or its affiliates.
Oracle is a registered trademark of Oracle Corporation and/or its
affiliates. Other names may be trademarks of their respective
owners.
Type 'help;' or '\h' for help. Type '\c' to clear the current input statement.
mysql> select * from information_schema.CLUSTER_PROCESSLIST where id=2375\G
*************************** 1. row ***************************
INSTANCE: 172.18.244.30:10080
ID: 2375
USER: asset-user
HOST: 172.18.37.1:54598
DB: db_name
COMMAND: Query
TIME: 252073
STATE: in transaction
INFO: select t2.id from ( select ROW_NUMBER() over() as 'idx', t1.id from ( select c.id id from tb_name c order by c.id) t1 )t2 where t2.idx % 5096 = 1 order by t2.idx
DIGEST: 9ff1ce262b1a5f7d7c50b42f4c88ddb0a10f04311d2f848e0b1a48895700214c
MEM: 1186719
DISK: 0
TxnStart: 08-24 18:38:02.369(427242679794139138)
1 row in set (0.01 sec)
mysql> KILL TIDB 2375;
Query OK, 0 rows affected (0.00 sec)
mysql> select * from information_schema.CLUSTER_PROCESSLIST where id=2375\G
*************************** 1. row ***************************
INSTANCE: 172.18.244.30:10080
ID: 2375
USER: asset-user
HOST: 172.18.37.1:54598
DB: db_name
COMMAND: Query
TIME: 252089
STATE: in transaction
INFO: select t2.id from ( select ROW_NUMBER() over() as 'idx', t1.id from ( select c.id id from tb_name c order by c.id) t1 )t2 where t2.idx % 5096 = 1 order by t2.idx
DIGEST: 9ff1ce262b1a5f7d7c50b42f4c88ddb0a10f04311d2f848e0b1a48895700214c
MEM: 1186719
DISK: 0
TxnStart: 08-24 18:38:02.369(427242679794139138)
1 row in set (0.01 sec)