查看是否有表锁:show OPEN TABLES where In_use > 0
查询进程:show processlist
查看正在锁的事务:SELECT * FROM INFORMATION_SCHEMA.INNODB_LOCKS
查看等待锁的事务:SELECT * FROM INFORMATION_SCHEMA.INNODB_LOCKS_WAITS
查看mysql死锁语法
最新推荐文章于 2024-07-31 09:08:05 发布
查看是否有表锁:show OPEN TABLES where In_use > 0
查询进程:show processlist
查看正在锁的事务:SELECT * FROM INFORMATION_SCHEMA.INNODB_LOCKS
查看等待锁的事务:SELECT * FROM INFORMATION_SCHEMA.INNODB_LOCKS_WAITS