…= InnoDB) */ While the structure of the table with secondary indexes is as follows: CREATE TABLE `purchases_index` ( `transactionid` int(11) NOT NULL AUTO_INCREMENT, `… simulate 5 concurrent connections writing to the table, with each instance of iiBench writing 200 million single row inserts, for a …
Post: Avoiding auto-increment holes on InnoDB with INSERT IGNORE
November 29, 2011 By 7 Comments
… concurrency and the performance but with a small cost. Queries like INSERT … ON DUPLICATE KEY UPDATE produce gaps on the auto_increment …); insert into mutex(i) values (1); Our InnoDB table with auto increment column will be like this: CREATE TABLE `foo` ( `id` int(11) NOT NULL AUTO_INCREMENT, `…
Post: Sharing an auto_increment value across multiple MySQL tables
October 4, 2010 By 9 Comments
… Use a table to insert into, and grab the insert_id: CREATE TABLE option1 (id int not null primary key auto_increment) engine=innodb; # each insert does one…really tell until a little concurrency is applied. Using only the “transactional” test in a few more concurrency options: (results are …
Post: MySQL Users Conference - Innodb
May 9, 2007 By 6 Comments
…. Improved Auto Increment handling Yet another known Innodb problem is table locks which are taken for statement duration for Inserts with auto-increment column. This starts giving you problems if you have a lot of concurrent inserts happening to the same table…
Post: InnoDB auto-inc scalability fixed
September 26, 2007 By 18 Comments
…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 inserted…
Post: Heikki Tuuri answers to Innodb questions, Part II
November 4, 2007 By 13 Comments
… in Innodb in 5.0 series. Also note the “Auto Increment Issue…innodb_buffer_pool_size Q36: There have been several MySQL bugs opened about multi-core scalability (concurrent queries, autoincrement, concurrent inserts… large Innodb table (150GB) that is showing poor performance for full table scans….
Post: Ultimate MySQL variable and status reference list
January 8, 2011 By 4 Comments
…auto_increment_incrementblogpercona.commanual auto_increment…
Post: Drilling down to the source of the problem
November 8, 2008 By 7 Comments
… of queries stuck in the innodb queue, with innodb_thread_concurrency set to 8 Happily enough innodb_thread_concurrency is the variable which …it is not only inserts to table with auto increment were stalling but also inserts to the tables which did not have auto-increment columns and general …
Comment: Some little known facts about Innodb Insert Buffer
December 14, 2010 By 11 Comments
Innodb locking problem with unique keys when inserting CREATE TABLE `male_id` ( `entry_id` int(10) unsigned NOT NULL AUTO_INCREMENT, `jy_id` int(10…=InnoDB AUTO_INCREMENT=1 When 10 processes concurrently inserting rows to the above table, only the rows from one process are actually recorded in the table. I…
Post: PBXT benchmarks
April 8, 2007 By 14 Comments
…auto increment primary key and couple of extra indexes. CREATE TABLE IF NOT EXISTS `$tableName` ( `id` int(10) unsigned NOT NULL auto_increment…InnoDB ./configure –prefix=/usr/local/mysqltest/mysql- –with-innodb Method of benchmark: 1. Prepare table…128, 256, 512 concurrent threads. … on INSERT/…
