Mysql 8.0 OCP认证考试原题题库整理（CUUG内部资料）-第2题

Mysql 8.0 OCP认证考试原题题库整理（CUUG内部资料）-第2题

2、Choose two.

Which two actions can obtain information about deadlocks?

A) Run the SHOW ENGINE INNODB MUTEX command from the mysql client.

B) Enable the innodb_status_output_locks global parameter.

C) Enable the innodb_print_all_deadlocks global parameter.

D) Run the SHOW ENGINE INNODB STATUS command from the mysql client.

E) Use the sys.innodb_lock_waits view.