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的一些设置可以帮助减少锁定。

版权声明：本文为博主原创文章，未经博主允许不得转载。

MYSQL