周梦康 发表于 2019-03-18 758 次浏览
mysql> delete from article_rank where id>=211409621;
^C^C -- query aborted

在客户端关闭似乎没用的,经过实验发现。

mysql> show processlist;
+----+------+-----------+------+---------+------+-----------+----------------------------------------------+
| Id | User | Host      | db   | Command | Time | State     | Info                                         |
+----+------+-----------+------+---------+------+-----------+----------------------------------------------+
|  7 | root | localhost | test | Query   |   63 | query end | delete from article_rank where id>=211409621 |
|  9 | root | localhost | NULL | Query   |    0 | starting  | show processlist                             |
+----+------+-----------+------+---------+------+-----------+----------------------------------------------+
2 rows in set (0.00 sec)
mysql> kill 7;
Query OK, 0 rows affected (0.00 sec)
mysql> select count(*) from article_rank where id>=211409621;
+----------+
| count(*) |
+----------+
|   785102 |
+----------+
1 row in set (3.32 sec)

虽然执行了一分钟,但是,数据了和之前的一样,没变。

评论列表