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.

1z0-888 PDF/Engine

Get 65% Discount on All Products, Use Coupon: "ac4s65"