前言：朋友咨询我说执行简单的update语句失效，症状如下：mysql> update order_info set province_id=15 ,city_id= 1667 where order_from=10 and order_out_sn='1407261241xxxx';ERROR1205 (HY000): Lockwaittimeoutexceeded; try re
朋友咨询我说执行简单的update语句失效，症状如下：mysql> update order_info set province_id=15 ,city_id= 1667 where order_from=10 and order_out_sn='1407261241xxxx';ERROR1205 (HY000): Lockwaittimeoutexceeded; try resta
1、查询是否锁表
show open tables where in_use>0;
2、查询进程
show processlist
查询到相对应的进程，然后kill id
3、查看正在锁的事务:
select * from information_schema.INNODB_LOCKS;
select * from information_schema.INNODB_TRX;
4、查看等待锁
