CREATE TABLE `t`(`id`INT(11) NOT NULL,`c`INT(11) NOT NULL,
PRIMARY KEY (`id`)) ENGINE=InnoDB;
INSERT INTO t VALUES (1,1);
操作次序
session A
session B
session C
BEGIN;
UPDATE t SET c=c+1 WHERE id=1;
UPDATE t SET c=c+2 WHERE id=1;(Blocked)
SHOW PROCESSLIST;
KILL QUERY 24;
ERROR 1317 (70100): Query execution was interrupted
mysql> SHOW PROCESSLIST;+----+-----------------+-----------+------+---------+--------+------------------------+-------------------------------+| Id | User | Host | db | Command | Time | State | Info |+----+-----------------+-----------+------+---------+--------+------------------------+-------------------------------+|4| event_scheduler | localhost | NULL | Daemon |