只列查看锁的SQL语句,其他内容搞透彻后再添加
表级锁定:SHOW STATUS LIKE ‘table%’;
行级锁定:SHOW STATUS LIKE ‘innodb_row_lock%’;
select * from information_schema.innodb_locks;
MySQL锁
最新推荐文章于 2022-11-20 20:03:56 发布
只列查看锁的SQL语句,其他内容搞透彻后再添加
表级锁定:SHOW STATUS LIKE ‘table%’;
行级锁定:SHOW STATUS LIKE ‘innodb_row_lock%’;
select * from information_schema.innodb_locks;