… with InnoDB auto-increment field. For details check Bug 16979. In short words the problem is in case of insert into table with auto-increment column the special AUTO_INC table… by InnoDB auto-inc. For several of them we even advised to replace auto-inc column by that or another solution. Good news is the bug…
Post: Avoiding auto-increment holes on InnoDB with INSERT IGNORE
November 29, 2011 By 7 Comments
… documentation bug is already submitted. Firstly, we will start with a simple question. Why do we have gaps on auto-increment columns….22 InnoDB used a method to access that counter values called “Traditional”. This one uses a special table lock called AUTO-INC that…(11) NOT NULL AUTO_INCREMENT, `name` int(11) DEFAULT NULL, PRIMARY KEY (`id`), UNIQUE KEY `uniqname` (`name`) ) ENGINE=InnoDB AUTO_INCREMENT=2 DEFAULT…
Comment: InnoDB auto-inc scalability fixed
September 26, 2007 By 18 Comments
[...] MySQL InnoDB çš„ auto-increment æœƒé€ æˆ INSERT 時使用 table-level lock çš„ bug çµ‚æ–¼ä¿®æ£ (從 2006 年一月就進 MySQL å›žå ±ç³»çµ±çš„ bug)，下個 5.1 的版本 (é 定是 5.1.22) 就會包括在裡é¢ï¼šInnoDB auto-inc scalability fixed。 [...]
