MySQL 8.0 Database Administrator — Question 124

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

Answer options

• A. SHOW ENGINE INNODB STATUS;
• B. INFORMATION_SCHEMA.INNODB_METRICS
• C. SHOW TABLE STATUS;
• D. INFORMATION_SCHEMA.STATISTICS
• E. INFORMATION_SCHEMA.INNODB_TABLESTATS
• F. SHOW STATUS;

Correct answer: D, E

Explanation

The correct answers, D and E, refer to INFORMATION_SCHEMA.STATISTICS and INFORMATION_SCHEMA.INNODB_TABLESTATS, which provide insights into InnoDB locking metrics. The other options, while useful for various database monitoring tasks, do not specifically focus on the global status of InnoDB locking.