[摘要]+----+------+9 rows in set (0.00 sec)//注意看这时的最大自增值是13session2mysql> insert into test_autoinc_loc...
+----+------+
9 rows in set (0.00 sec)//注意看这时的最大自增值是13
session2
mysql> insert into test_autoinc_lock(a) values(100);//同样gap锁的存在，这时处于锁等待
session3
mysql> insert into test_autoinc_lock(a) values(5);
Query OK, 1 row affected (0.00 sec)
mysql> select * from test_autoinc_lock;
+----+------+
关键词：案例详细说明mysql中innodb_autoinc_lock_mode