Which two tools are available to monitor the global status of InnoDB locking? (Choose two.)
Which two tools are available to monitor the global status of InnoDB locking? (Choose two.)
To monitor the global status of InnoDB locking, the commands SHOW ENGINE INNODB STATUS; and INFORMATION_SCHEMA.INNODB_METRICS are useful. SHOW ENGINE INNODB STATUS; provides detailed information about the current status of the InnoDB storage engine, including details about locking. INFORMATION_SCHEMA.INNODB_METRICS contains various metrics related to InnoDB performance and status, which can include locking metrics. Other options like INFORMATION_SCHEMA.STATISTICS and INFORMATION_SCHEMA.INNODB_TABLESTATS do not specifically focus on locking information, making them less relevant for this particular monitoring task.
why not A and B?
AF, but show status might need to be show global status