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)
虽然执行了一分钟,但是,数据了和之前的一样,没变。