Mysql错误: ERROR 1205: Lock wait timeout exceeded; try restarting transaction

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

如果这样不好使，毙了狗，直接关掉集成运行环境，像PHPstudy,wampserver这些集成包，

简单粗暴，搞定！

Mysql错误: ERROR 1205: Lock wait timeout exceeded; try restarting transaction

标签：blog   线程id   nbsp   sql命令   log   timeout   show   time   slist