查看正在锁的事物:SELECT * FROM INFORMATION_SCHEMA.INNODB_LOCKS. 查看等待锁的事物:SELECT * FROM INFORMATION_SCHEMA.INNODB_LOCK_WAITS.
mysql数据库中查询表是否被锁
最新推荐文章于 2024-03-10 17:54:11 发布
查看正在锁的事物:SELECT * FROM INFORMATION_SCHEMA.INNODB_LOCKS. 查看等待锁的事物:SELECT * FROM INFORMATION_SCHEMA.INNODB_LOCK_WAITS.