information_schema(INNODB_TRX | INNODB_LOCKs | INNODB_LOCK_waits)_select * from information_schema.innodb_locks;-CSDN博客

网友收藏2023-10-12 12:11

链接地址：https://blog.csdn.net/shuzhupeng/article/details/103179650
链接标题：information_schema(INNODB_TRX | INNODB_LOCKs | INNODB_LOCK_waits)_select * from information_schema.innodb_locks;-CSDN博客
所属网站：blog.csdn.net
被收藏次数：4754

这三条语句分别查事务、锁、锁等待：SELECT * FROM information_schema.INNODB_TRX;-- 命令是用来查看当前运行的所有事务：SELECT * FROM information_schema.INNODB_LOCKs;-- 命令是用来查看当前出现的锁；SELECT * FROM information_schema.INNODB_L..._select * from information_schema.innodb_locks;

本文地址：https://tebull.com/detail/65040.html

标签：select * from information_schema.innodb_locks;