-----------+--------+------ ---------------+---------------------+ | j01013a38b0184e07c864627b5bb05da09ee0 | t_order | 1 | false | 2022- 10-31 18:18:24 | 2022-10-31 18:18:31 | +------------------- -------+------+-----------+-------------+---------+---- --+---------------+------------------+ | 05ede3bd584fd4a429dcaac382be2973 | root | 127.0.0.1 | sharding_db | Execute | 2 | Executing 0/1 | select ShardingSphere cancels the SQL being executed according to the ID in the KILL statement. mysql> kill 05ede3bd584fd4a429dcaac382be2973; Query OK, 0 rows affected (0.04 sec) mysql> show processlist; Empty

-----------+--------+------ ---------------+---------------------+ | j01013a38b0184e07c864627b5bb05da09ee0 | t_order | 1 | false | 2022- 10-31 18:18:24 | 2022-10-31 18:18:31 | +------------------- -------+------+-----------+-------------+---------+---- --+---------------+------------------+ | 05ede3bd584fd4a429dcaac382be2973 | root | 127.0.0.1 | sharding_db | Execute | 2 | Executing 0/1 | select ShardingSphere cancels the SQL being executed according to the ID in the KILL statement. mysql> kill 05ede3bd584fd4a429dcaac382be2973; Query OK, 0 rows affected (0.04 sec) mysql> show processlist; Empty

---+ 9.2. ShardingSphere-Proxy 320 Apache ShardingSphere document | j01013a38b0184e07c864627b5bb05da09ee0 | t_order | 1 | false | 2022- 10-31 18:18:24 | 2022-10-31 18:18:31 | +------------------- -------+------+-----------+-------------+---------+---- --+---------------+------------------+ | 05ede3bd584fd4a429dcaac382be2973 | root | 127.0.0.1 | sharding_db | Execute | 2 | Executing 0/1 | select SHOW PROCESSLIST 返回的结果，判断是否需要执行 KILL 语句，ShardingSphere 会根据 KILL 语句中的 ID 取消正在执行中的 SQL。 mysql> kill 05ede3bd584fd4a429dcaac382be2973; Query OK, 0 rows affected (0.04 sec) mysql> show processlist; Empty

-----------+--------+------ ---------------+---------------------+ | j01013a38b0184e07c864627b5bb05da09ee0 | t_order | 1 | false | 2022- 10-31 18:18:24 | 2022-10-31 18:18:31 | +------------------- -------+------+-----------+-------------+---------+---- --+---------------+------------------+ | 05ede3bd584fd4a429dcaac382be2973 | root | 127.0.0.1 | sharding_db | Execute | 2 | Executing 0/1 | select SHOW PROCESSLIST 返回的结果，判断是否需要执行 KILL 语句，ShardingSphere 会根据 KILL 语句中的 ID 取消正在执行中的 SQL。 mysql> kill 05ede3bd584fd4a429dcaac382be2973; Query OK, 0 rows affected (0.04 sec) mysql> show processlist; Empty

-----------+--------+------ ---------------+---------------------+ | j01013a38b0184e07c864627b5bb05da09ee0 | t_order | 1 | false | 2022- 10-31 18:18:24 | 2022-10-31 18:18:31 | +------------------- -------+------+-----------+-------------+---------+---- --+---------------+------------------+ | 05ede3bd584fd4a429dcaac382be2973 | root | 127.0.0.1 | sharding_db | Execute | 2 | Executing 0/1 | select SHOW PROCESSLIST 返回的结果，判断是否需要执行 KILL 语句，ShardingSphere 会根据 KILL 语句中的 ID 取消正在执行中的 SQL。 mysql> kill 05ede3bd584fd4a429dcaac382be2973; Query OK, 0 rows affected (0.04 sec) mysql> show processlist; Empty

-------+------+-----------+-------------+---------+---- --+---------------+------------------+ | 05ede3bd584fd4a429dcaac382be2973 | root | 127.0.0.1 | sharding_db | Execute | 2 | Executing 0/1 | select ShardingSphere cancels the SQL being executed according to the ID in the KILL statement. mysql> kill 05ede3bd584fd4a429dcaac382be2973; Query OK, 0 rows affected (0.04 sec) mysql> show processlist; Empty Test 369 Apache ShardingSphere document, v5.2.1 s_dist_03 char(24), s_dist_04 char(24), s_dist_05 char(24), s_dist_06 char(24), s_dist_07 char(24), s_dist_08 char(24), s_dist_09 char(24), s_dist_10

db0 ├── t_order_00 ├── t_order_01 ├── t_order_02 ├── t_order_03 ├── t_order_04 ├── t_order_05 ├── t_order_06 ├── t_order_07 ├── t_order_08 ├── t_order_09 ├── t_order_10 ├── t_order_11 ├── t_order_20 db1 ├── t_order_00 ├── t_order_01 ├── t_order_02 ├── t_order_03 ├── t_order_04 ├── t_order_05 ├── t_order_06 ├── t_order_07 ├── t_order_08 ├── t_order_09 ├── t_order_10 ├── t_order_11 4 varchar(50), s_dist_01 char(24), s_dist_02 char(24), s_dist_03 char(24), s_dist_04 char(24), s_dist_05 char(24), s_dist_06 char(24), s_dist_07 char(24), s_dist_08 char(24), s_dist_09 char(24), s_dist_10

db0 ├── t_order_00 ├── t_order_01 ├── t_order_02 ├── t_order_03 ├── t_order_04 ├── t_order_05 ├── t_order_06 ├── t_order_07 ├── t_order_08 ├── t_order_09 ├── t_order_10 ├── t_order_11 ├── t_order_20 db1 ├── t_order_00 ├── t_order_01 ├── t_order_02 ├── t_order_03 ├── t_order_04 ├── t_order_05 ├── t_order_06 ├── t_order_07 ├── t_order_08 ├── t_order_09 ├── t_order_10 ├── t_order_11 4 varchar(50), s_dist_01 char(24), s_dist_02 char(24), s_dist_03 char(24), s_dist_04 char(24), s_dist_05 char(24), s_dist_06 char(24), s_dist_07 char(24), s_dist_08 char(24), s_dist_09 char(24), s_dist_10

db0 ├── t_order_00 ├── t_order_01 ├── t_order_02 ├── t_order_03 ├── t_order_04 ├── t_order_05 ├── t_order_06 ├── t_order_07 ├── t_order_08 ├── t_order_09 ├── t_order_10 ├── t_order_11 ├── t_order_20 db1 ├── t_order_00 ├── t_order_01 ├── t_order_02 ├── t_order_03 ├── t_order_04 ├── t_order_05 ├── t_order_06 ├── t_order_07 ├── t_order_08 ├── t_order_09 ├── t_order_10 ├── t_order_11 4 varchar(50), s_dist_01 char(24), s_dist_02 char(24), s_dist_03 char(24), s_dist_04 char(24), s_dist_05 char(24), s_dist_06 char(24), s_dist_07 char(24), s_dist_08 char(24), s_dist_09 char(24), s_dist_10

博客 • 2020‐07 InfoQ 文章：ElasticJob 的产品定位与新版本设计理念 • 2020‐07 开源中国：GitHub 上持续冲榜，ElasticJob 重启 • 2020‐05 官微快讯：分布式调度项目 ElasticJob 即将重新起航 • 2017‐09 Mesosphere 新闻：Q&A with Zhang Liang of Dangdang: the biggest