The MySQL error log shows:InnoDB: Warning: a long semaphore wait:The relevant parts of the InnoDB...

Oracle 1z0-888 Question Answer

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?

Increase the value of the innodb_lock_wait_timeout option.

Increase the value of the innodb_read_io_threads option.

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

Set the value of innodb_adaptive_hash_index to zero.

Deactivate the query cache.

Increase the size of the InnoDB buffer pool.

Oracle 1z0-888 Summary

Price: $52.5 ~~$149.99~~