Which two statements are true about InnoDB auto-increment locking?

Question

Options

• AThe auto-increment lock can be a table-level lock.
• BInnoDB never uses table-level locks.
• CSome settings for innodb_autoinc_lock_mode can help reduce locking.
• DInnoDB always protects auto-increment updates with a table-level lock.
• EInnoDB does not use locks to enforce auto-increment uniqueness.

• A
  85% (28)
• B
  9% (3)
• D
  3% (1)
• E
  3% (1)

Explanation

It can be table level lock if the value of innodb_autoinc_lock_mode is set to 1 or 0 but value 2 doe not use table level locking.

No community discussion yet for this question.