Which of the following statements are true for locks established by the InnoDB storage engine?

The correct answer is D. It never escalates locks to page or table level. During the course of a transaction, InnoDB may acquire row locks as it discovers them to be However, it never escalates a lock (for example, by converting it to a page lock or table lock). This keeps lock contention to a minimum and improves concurrency.

MySQL Storage Engines

Question

Options

AIt sometimes escalates locks to page level.
BIt sometimes escalates locks to table level.
CIt sometimes escalates locks to page or table level.
DIt never escalates locks to page or table level.

How the community answered

(39 responses)

A
13% (5)
B
8% (3)
C
3% (1)
D
77% (30)

Explanation

During the course of a transaction, InnoDB may acquire row locks as it discovers them to be However, it never escalates a lock (for example, by converting it to a page lock or table lock). This keeps lock contention to a minimum and improves concurrency.

Topics

#InnoDB locking#row-level locks#lock escalation#storage engine

Community Discussion

No community discussion yet for this question.

Full 1Z0-873 Practice