MySQL 8.4 Release Notes
17.17.1 InnoDB 监视器类型
There are two types of InnoDB
monitor:
-
The standard
InnoDB
Monitor displays the following types of information:-
Work done by the main background thread
-
Semaphore waits
-
Data about the most recent foreign key and deadlock errors
-
Lock waits for transactions
-
Table and record locks held by active transactions
-
Pending I/O operations and related statistics
-
Insert buffer and adaptive hash index statistics
-
Redo log data
-
Buffer pool statistics
-
Row operation data
-
-
The
InnoDB
Lock Monitor prints additional lock information as part of the standardInnoDB
Monitor output.