一个古老的“删除单条logging”声明冻结了我。 怀疑（死）锁问题，我检查了进程列表，看看什么阻止delete 。 delete语句是唯一的运行数据库进程，仍然是其状态Locked 。 它保持在这个状态2分钟，然后成功完成。
问题：什么可以使一个MySQL进程Locked除了另一个进程locking？
以下是来自show processlist的输出：
mysql> show processlist; +-------+------+-----------------------------------+------+---------+------+--------+---------------------------------------------+ | Id | User | Host | db | Command | Time | State | Info | +-------+------+-----------------------------------+------+---------+------+--------+---------------------------------------------+ | 79616 | htt | gateway1.xxxxxxxxxxxxxxxxxx:42254 | foo | Query | 106 | Locked | delete from xbarApp_testfoo where id = 2279 | | 79618 | htt | gateway1.xxxxxxxxxxxxxxxxxx:41009 | foo | Query | 0 | NULL | show processlist | +-------+------+-----------------------------------+------+---------+------+--------+---------------------------------------------+ 2 rows in set (0.35 sec)