innodb_trx、innodb_locks、innodb_lock_waits ゝ一纸荒年。 2022-12-02 13:59 129阅读 0赞 os: centos 7.4 db: mysql 5.7.28 root@localhost 15:45:40 [test]> select * from information_schema.innodb_trx; Empty set (0.00 sec) root@localhost 15:55:03 [test]> select * from information_schema.innodb_locks; Empty set, 1 warning (0.00 sec) root@localhost 15:55:07 [test]> show warnings; +---------+------+------------------------------------------------------------------------------------------+ | Level | Code | Message | +---------+------+------------------------------------------------------------------------------------------+ | Warning | 1681 | 'INFORMATION_SCHEMA.INNODB_LOCKS' is deprecated and will be removed in a future release. | +---------+------+------------------------------------------------------------------------------------------+ 1 row in set (0.00 sec) root@localhost 15:55:39 [test]> select * from information_schema.innodb_lock_waits; Empty set, 1 warning (0.00 sec) root@localhost 15:55:56 [test]> show warnings; +---------+------+-----------------------------------------------------------------------------------------------+ | Level | Code | Message | +---------+------+-----------------------------------------------------------------------------------------------+ | Warning | 1681 | 'INFORMATION_SCHEMA.INNODB_LOCK_WAITS' is deprecated and will be removed in a future release. | +---------+------+-----------------------------------------------------------------------------------------------+ 1 row in set (0.00 sec)
还没有评论，来说两句吧...