Oracle Exam 1Z0-888 Topic 7 Question 35 Discussion

Actual exam question for Oracle's 1Z0-888 exam

Question #: 35
Topic #: 7

The MySQL error log shows:

InnoDB: Warning: a long semaphore wait:

The relevant parts of the InnoDB monitor output shows:

Which two options would help avoid the long wait in the future?

AIncrease the value of the innodb_lock_wait_timeout option.

BIncrease the value of the innodb_read_io_threads option.

CChange the table to use HASH indexes instead of BTREE indexes.

DSet the value of innodb_adaptive_hash_index to zero.

EDeactivate the query cache.

FIncrease the size of the InnoDB buffer pool.

Show Suggested Answer

Suggested Answer: B, F

by Luisa at May 07, 2022, 08:15 PM

Limited Time Offer

25%

Off

Contribute your Thoughts:

Submit Cancel

Currently there are no comments in this discussion, be the first to comment!