…with concurrent inserts into a MyISAM table. The inserts were not happening concurrently with SELECT statements; they were blocking and the process list was filling up with queries in…
Post: Avoiding auto-increment holes on InnoDB with INSERT IGNORE
November 29, 2011 By 8 Comments
… we lose concurrency and performance. The problems are even worse with long running queries like INSERT INTO table1 … SELECT … FROM table2. In version 5… of a table lock on AUTO-INC. We have recovered the concurrency and the performance but with a small cost. Queries like INSERT … ON…
Post: MySQL Server Variables - SQL layer or Storage Engine specific.
June 8, 2006 By 14 Comments
…/MEMORY). Note in 5.0 you now have very nice value of 2 which allows concurrent insert to work also if tables have “holes” (deleted rows) which can help significantly. delay_key_write Delay updating indexes for MyISAM tables… storage engines with table locks or if LOCK TABLES are used. So in practice this option is used for MyISAM and MEMORY tables. max_write…
Post: MySQL Users Conference - Innodb
May 9, 2007 By 6 Comments
… for Inserts with auto-increment column. This starts giving you problems if you have a lot of concurrent inserts happening to the same table. This… by having potential “holes” when auto increment values are assigned but never used. There are probably similar problems in INSERT IGNORE and ON…
