Exam 1z0-908 All QuestionsBrowse all questions from this exam
Question 96

Which two tools are available to monitor the global status of InnoDB locking? (Choose two.)

    Correct Answer: A, B

    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.

Discussion
eena96Options: AB

why not A and B?

marklvOptions: AB

AF, but show status might need to be show global status