查询 select concat('KILL ',id,';') from information_schema.processlist;
复制结果 新建sql脚本粘贴并执行
相关文章
- 08-21mysql_提示 Lock wait timeout exceeded解决办法
- 08-21Mysql错误: Lock wait timeout exceeded 解决办法
- 08-21mysql提示 Lock wait timeout exceeded解决办法 事务锁死
- 08-21MySQL事务锁问题-Lock wait timeout exceeded
- 08-21mysql死锁，等待资源，事务锁，Lock wait timeout exceeded; try restarting transaction解决
- 08-21mysql死锁，等待资源，事务锁，Lock wait timeout exceeded; try restarting transaction解决
- 08-21MySql Lock wait timeout exceeded 解决办法
- 08-21关于mysql锁的错误Lock wait timeout exceeded; try restarting transaction 【求解】
- 08-21mysql 事务锁超时时间 innodb_lock_wait_timeout
- 08-21MySQL事务锁问题-Lock wait timeout exceeded