… 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…
Page: About This Blog
May 3, 2006 By 48 Comments
… was employed as Manager of High Performace Group at MySQL Inc, I specialise MySQL Server performance as well as in performance… was employed by MySQL Inc as Performance Engineer, working in Peters group working on MySQL Performance and Scalability issues. My primary tasks… mutexes and concurrency control, MMAP IO for MyISAM tables, Innodb Auto-increment optimizations. My recent work in my spare time was…
