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.