show processlist;//显示所有进程
select * from information_schema.innodb_trx;//查询锁的进程
-- kill 310;//杀掉锁进程
相关文章
- mysql提示 Lock wait timeout exceeded解决办法
- mysql大数据表删除操作锁表，导致其他线程等待锁超时（Lock wait timeout exceeded; try restarting transaction;）
- Mysql错误: Lock wait timeout exceeded 解决办法
- MySQL死锁：Lock wait timeout exceeded; try restarting transaction
- mysql : Lock wait timeout exceeded; try restarting transaction
- mysql遇到锁 或者Lock wait timeout exceeded; try restarting transaction
- MySql Lock wait timeout exceeded该如何处理？ (转载)
- mysql 操作突然断网，MySQL: “lock wait timeout exceeded”
- 【MySQL】事务没有提交导致 锁等待Lock wait timeout exceeded异常
- mysql中Lock wait timeout exceeded; try restarting transaction