show processlist;//显示所有进程
select * from information_schema.innodb_trx;//查询锁的进程
-- kill 310;//杀掉锁进程
相关文章
- 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; try restarting transaction
- 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的问题