Mysql错误: ERROR 1205: Lock wait timeout exceeded解决办法

1、show full processlist;

然后找出查询语句的系统id：kill掉被锁住的线程id

2、查看事物表: select * from information_schema.innodb_trx;

结果中对trx_state为LOCKWAIT的线程id执行kill