Which of the following statements are true regarding the InnoDB storage engine?

The correct answer is A. It uses multiversioning to isolate transactions. D. It is possible for deadlocks to occur.. MySQL manages query contention for InnoDB tables using multi-versioning and row-level locking. Multiversioning gives each transaction its own view of the database. This, combined with row-level locking, keeps contention to a minimum. The result is good query concurrency even if c

MySQL Storage Engines

Question

Options

AIt uses multiversioning to isolate transactions.
BIt is not possible for deadlocks to occur.
CIt does not isolate transactions.
DIt is possible for deadlocks to occur.

How the community answered

(29 responses)

A
76% (22)
B
14% (4)
C
10% (3)

Explanation

MySQL manages query contention for InnoDB tables using multi-versioning and row-level locking. Multiversioning gives each transaction its own view of the database. This, combined with row-level locking, keeps contention to a minimum. The result is good query concurrency even if clients are performing a mix of reads and writes. However, it's possible for deadlock to occur.

Topics

#InnoDB#MVCC#deadlocks#transaction concurrency

Community Discussion

No community discussion yet for this question.

Full 1Z0-873 Practice