有两种类型的InnoDB监控器:There are two types of InnoDB monitor:
标准的
InnoDB监控器显示以下类型的信息:The standardInnoDBMonitor 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
待处理的 I/O 操作及相关统计信息Pending I/O operations and related statistics
插入缓冲区和自适应哈希索引统计Insert buffer and adaptive hash index statistics
重做日志数据Redo log data
缓冲池统计信息Buffer pool statistics
行操作数据Row operation data
InnoDB锁监控器在标准InnoDB监控器输出中打印额外的锁信息。TheInnoDBLock Monitor prints additional lock information as part of the standardInnoDBMonitor output.