… special AUTO_INC table level lock is obtained, instead of usual row-level locks. With many concurrent inserted threads this causes serious scalability problems, and in our consulting practice we had a lot of customers who was affected by InnoDB auto-inc. For several of them we even advised to replace auto-inc column by that or another…
Post: Hacking to make ALTER TABLE online for certain changes
October 29, 2007 By 26 Comments
… hit the InnoDB auto-inc scalability issue with MySQL 5.0 and older versions, employing other techniques to maintain the PK auto incremental becomes… of: CREATE TABLE `huge_table` ( `id` int(6) NOT NULL auto_increment, `text` text NOT NULL, PRIMARY KEY (`id`) ) ENGINE=InnoDB… 1062 (23000): Duplicate entry ’0′ for key 1 Unfortunately, adding auto_increment does not work that way. Enum values (add and…
Post: Fix of InnoDB/XtraDB scalability of rollback segment
January 18, 2009 By 9 Comments
Recently I wrote about InnoDB scalability on 24-core box, and we made research of scalability problems in sysbench write workload (benchmark…-updates –oltp-non-index-updates –oltp-nontrx-mode select –oltp-auto-inc off –oltp-connect-delay 10000 –oltp-user-delay-min 0… uniform –oltp-dist-pct –oltp-dist-res –db-ps-mode auto –mysql-host localhost –mysql-port 3306 –mysql-socket /data/vadim…
Comment: InnoDB auto-inc scalability fixed
October 29, 2007 By 18 Comments
[...] that more and more folks hit the InnoDB auto-inc scalability issue with MySQL 5.0 and older versions, employing other techniques to maintain the PK auto incremental [...]
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。 [...]
Comment: InnoDB auto-inc scalability fixed
June 26, 2009 By 18 Comments
[...] маÑштабируемоÑти, давно уже новоÑтью не ÑвлÑетÑÑ (Ñм. InnoDB auto-inc scalability fixed, ÑентÑбрь 2007). ПрактичеÑкий пример типичной проблемы и [...]
Comment: InnoDB auto-inc scalability fixed
June 26, 2009 By 18 Comments
[...] маÑштабируемоÑти, давно уже новоÑтью не ÑвлÑетÑÑ (Ñм. InnoDB auto-inc scalability fixed, ÑентÑбрь 2007). ПрактичеÑкий пример типичной проблемы и [...]
Comment: InnoDB auto-inc scalability fixed
October 7, 2007 By 18 Comments
[...] InnoDB auto-inc scalability fixed ã«ã‚ˆã‚‹ã¨æœ€æ–°ç‰ˆã® MySQL 5.1.22 [...]
Comment: Hacking to make ALTER TABLE online for certain changes
October 29, 2007 By 26 Comments
… when these tables were small and first created to use auto-inc primary key. At the time (over 2 years ago), I… getting lots of auto-inc waits. Now that these tables are huge, I’ve got a big problem with scalability. It is really… PC software. If this works, then I can push the auto-inc‘ing up into my application and relieve MySQL of this…
