1Z0-908: MySQL 8.0 Database AdministratorDemo

By Oracle · Question Mode

QuestionQ105

Performance

Which two tools can be used to monitor the overall status of InnoDB locking?

Choose two
  • 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;
Explanation

SHOW ENGINE INNODB STATUS provides InnoDB Monitor output that includes locking information. INFORMATION_SCHEMA.INNODB_METRICS exposes InnoDB performance counters, including lock-related metrics such as row-lock waits, wait times, deadlocks, and lock timeouts.

Learn more

Community Discussion

No comments yet. Be the first to start the discussion!