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

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

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

A.
The auto-increment lock can be a table-level lock.

B.
InnoDB never uses table-level locks.

C.
Some settings for innodb_autoinc_lock_mode can help reduce locking.

D.
InnoDB always protects auto-increment updates with a table-level lock.

E.
InnoDB always protects auto-increment updates with a table-level lock.



Leave a Reply 2

Your email address will not be published. Required fields are marked *