Mysql OCP第9题

Which two statements are true about InnoDB auto-increment locking?
A. InnoDB never uses table_level locks.
B. InnoDB always protects auto-increment updates with a table-level lock
C. InnoDB does not use locks to enforce auto-increment uniqueness.
D. The auto-increment lock can be a table-level lock.
E. Some settings for innodb_autoinc_lock_mode can help reduce locking.
Answer: D,E

# D.自动增量锁可以是表级锁。

# E.Innodb_autoinc_lock_mode的一些设置可以帮助减少锁定。