多选题

Which two actions can obtain information about deadlocks?

ARun the SHOW ENGINE INNODB MUTEX command from the mysql client.

BEnable the innodb_status_output_locks global parameter.

CEnable the innodb_print_all_deadlocks global parameter.

DRun the SHOW ENGINE INNODB STATUS command from the mysql client.

EUse the sys.innodb_lock_waits view.

查看答案

正确答案：A （备注：此答案有误）

相似试题

多选题

Which two actions can obtain information about deadlocks?

答案解析
多选题

Choose two.Your MySQL installation is running low on space due to binary logs. You need to reduce your log space usage urgently.Which two sets of actions when completed will accomplish this?

答案解析
单选题

The left wing party wants to keep these two actions ________.

答案解析
多选题

Choose two.A valid raw backup of the shop.customers MyISAM table was taken. You must restore the table. You begin with these steps:1Confirm that secure_file_priv= ‘/var/tmp ‘2mysql> DROP TABLE shop.customers;3shell> cp /backup/customers.MY* /var/1ib/mysql/shop/ Which two actions are required to complete the restore?

答案解析
多选题

Choose two.You have an InnoDB Cluster configured with three servers. Examine this command, which executes successfully:Mysqldump -uroot -p -d mydatabase > mydatabase_backup.sqlDue to data loss, the cluster is initialized and a restore is attempted resulting in this error:ERROR 13176 (HY000) at line 23: Cannot update GTID_PURGED with the Group Replication plugin runningWhich two actions, either one of which, can fix this error and allow a successful restore of the cluster?

答案解析