Shulou(Shulou.com)06/01 Report--

There are three values for innodb_autoinc_lock_mode: 0 1 2. The default is 1.

Innodb_autoinc_lock_mode=0

This is the traditional mode, all insert-like statements will hold table-level AUTO-INC lock, that is, lock, until the completion of the statement execution, the assigned self-increment value is also continuous and predictable. At the same time, in the replication mode of statement-based, the consistency of master-slave self-increment columns can be guaranteed.

Innodb_autoinc_lock_mode=1

Continuous mode, in which table-level AUTO-INC lock is not used for simple insertion, and the number of rows to be inserted will be known in advance. However, the insertion of "mixed-mode inserts" is different from the traditional mode, in which the user may accurately provide the number of rows of some self-incrementing columns, but not all of them will clearly know that at this time, innodb will allocate more self-increment than the known number of rows to the following insert, so that the assigned value is also continuous, but it may have gap with the previous self-increment, and at this time gap value will lost.

Innodb_autoinc_lock_mode = 2

Interactive mode, in which all insert-like statements do not hold table-level AUTO-INC lock, but it is not very safe in statement-based replication mode.

Make up in the later stage of specific verification!

Welcome to subscribe "Shulou Technology Information " to get latest news, interesting things and hot topics in the IT industry, and controls the hottest and latest Internet news, technology news and IT industry trends.