mysql 大事务被kill_delete 大事务中途 kill 所有数据都不会被删除

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)

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