…lock algorithm for the auto_increment value is configurable and you can select from different algorithms using the innodb_autoinc_lock…AUTO_INCREMENT, `name` int(11) DEFAULT NULL, PRIMARY KEY (`id`), UNIQUE KEY `uniqname` (`name`) ) ENGINE=InnoDB AUTO_INCREMENT…
Post: InnoDB auto-inc scalability fixed
September 26, 2007 By 18 Comments
… 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 level lock is obtained, instead of usual row-level locks. With many concurrent…
Post: Improved InnoDB fast index creation
November 6, 2011 By 4 Comments
… | 0.000008 | | Opening tables | 0.000118 | | System lock | 0.000007 | | setup | 0.000027 | | creating table… slower; mysqldump –innodb-optimize-keys ignores indexes on AUTO_INCREMENT columns, because…InnoDB picks such an index as the clustered one. References: Peter’s post MySQL bug #57583 MySQL bug…
Post: MyISAM Scalability and Innodb, Falcon Benchmarks
October 12, 2007 By 10 Comments
… PRIMARY KEY (`id`), KEY `val` (`val`) ) ENGINE=MyISAM AUTO_INCREMENT=4097 Table t1 contains about 260,000 records,…key cache locking was done so disk IO is not done while lock is held, while lock is … comparison of MyISAM Innodb and Falcon results in the graphical form: I’ve created bug, for MyISAM …
Post: Heikki Tuuri answers to Innodb questions, Part II
November 4, 2007 By 13 Comments
… of micro optimizations in Innodb in 5.0 series. Also note the “Auto Increment Issue” is finally … recently found and fixed: http://bugs.mysql.com/bug.php?id=29560 Concerning a switch to … should be possible to implement online reorganize which locks and reorganizes small portions of table online. Q38…
Post: Instrumentation and the cost of Foreign Keys
September 20, 2010 By 9 Comments
…AUTO_INCREMENT, bogus_column char(32), PRIMARY KEY (id) ) ENGINE=InnoDB; CREATE TABLE child ( id INT NOT NULL AUTO_INCREMENT…lock_trx_id: 87035 lock_mode: X lock_type: RECORD lock_table: `test`.`parent` lock_index: `PRIMARY` lock_space: 1300 lock_page: 3 lock_rec: 6 lock… Server. See BUG #53336 …
Post: Percona Server 5.1.59-13.0
October 16, 2011 By Leave a Comment
…on MySQL 5.1.59, including all the bug fixes in it, Percona Server 5.1….makes prefetch simple but has high overhead from locking rows only to undo changes at rollback. … Kopytov). Fixed assertion failure in InnoDB. #814404 (Yasufumi Kinoshita). Since AUTO_INCREMENT columns must be defined as keys…
Post: Percona Server 5.5.16-22.0
October 16, 2011 By 2 Comments
… on MySQL 5.5.16, including all the bug fixes in it, Percona Server 5.5…. makes prefetch simple but has high overhead from locking rows only to undo changes at rollback. …Oleg Tsarev). Fixed assertion failure in InnoDB. #814404 (Yasufumi Kinoshita). Since AUTO_INCREMENT columns must be defined as keys…
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。 [...]
