1Z0-908: MySQL 8.0 Database AdministratorDemo

By Oracle · Question Mode

QuestionQ147

Performance

Which two actions can be used to obtain information about deadlocks?

Choose two
  • A Run the SHOW ENGINE INNODB MUTEX command from the mysql client.
  • B Use the sys.innodb_lock_waits view.
  • C Run the SHOW ENGINE INNODB STATUS command from the mysql client.
  • D Enable the innodb_status_output_locks global parameter.
  • E Enable the innodb_print_all_deadlocks global parameter.
Explanation

SHOW ENGINE INNODB STATUS displays details of the most recent InnoDB deadlock. Enabling the global innodb_print_all_deadlocks variable records information about all InnoDB user-transaction deadlocks in the MySQL server error log.

Learn more

Community Discussion

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