…(11) not null auto_increment primary key) ENGINE=InnoDB; Query OK, 0 rows affected (0.09 sec) session1 > insert into t1 values(null…) not null auto_increment primary key) ENGINE=InnoDB; When using MySQL 5.1 the second CREATE would just fail immediately with the error “ERROR…
Post: InnoDB auto-inc scalability fixed
September 26, 2007 By 18 Comments
… issue 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… determines behavior of InnoDB for tables with autoinc. I do not want to copy-paste MySQL documentation, the very good and informative…
Post: What's up with HandlerSocket?
March 28, 2011 By 43 Comments
…MySQL interface. No support for auto increment – Exactly as it sounds, you couldn’t have auto-incrementing columns get an auto increment value on insert…
Post: The story of one MySQL Upgrade
October 8, 2010 By 8 Comments
… there are only few INSERT ON DUPLICATE KEY UPDATE query instances, and only one of them into table with AUTO_INCREMENT column (and so affected by this bug). It was easy enough to change the single application not to use INSERT… for some time, with rollback to old setup being trivial. This was the best choice as with New MySQL version upgrade involves new…
Post: Checking the subset sum set problem with set processing
May 16, 2011 By Leave a Comment
…, which you can then distribute with Shard-Query: CREATE TABLE `the list` ( `id` bigint(20) NOT NULL AUTO_INCREMENT, `val` bigint(20) NOT… in set (20.47 sec) Now insert a value which will cause our check to pass: mysql> insert into data (val) values (16); Query OK, 1 row affected (0.01 sec) mysql> SELECT val as…
Post: To UUID or not to UUID ?
March 13, 2007 By 28 Comments
…auto_increment columns, which is however completely separate problem which can be fixed in MySQL…or data on disk case with auto_increment having advantage when UUID …insert benchmark for this case with larger data size so here they are: I’ve created MyISAM tables containing just integer auto_increment…
Post: Hacking to make ALTER TABLE online for certain changes
October 29, 2007 By 26 Comments
…tables with read lock while switching .frm files. When and how it works: auto_increment (removing). Let’s have a simple table with auto_increment …sec) mysql> INSERT INTO `huge_table` (text) VALUES (‘test’); ERROR 1062 (23000): Duplicate entry ’0′ for key 1 Unfortunately, adding auto_increment does …
Post: Benchmarking single-row insert performance on Amazon EC2
May 16, 2012 By 17 Comments
… come to the MySQL configuration. MySQL Configuration I used …with secondary indexes is as follows: CREATE TABLE `purchases_index` ( `transactionid` int(11) NOT NULL AUTO_INCREMENT…insert rate of ~25k INSERTs Per Second, while with the table purchases_index, the avg. insert rate reduced to ~9k INSERTs…
Post: Adventures in archiving
February 11, 2013 By 16 Comments
…recently had an issue with size on disk for…’s inbuilt row compression MySQL‘s inbuilt compress() …AUTO_INCREMENT, `dat` blob, PRIMARY KEY (`id`) ) ENGINE=InnoDB DEFAULT CHARSET=latin1; CREATE TABLE `compressed_row` ( `id` int(11) NOT NULL AUTO_INCREMENT…operation. #37648 Use of INSERT DELAYED is not …
Post: Drilling down to the source of the problem
November 8, 2008 By 7 Comments
… famous Innodb AUTO-INC lock. That would be an easy excuse to blame everything on this lock, suggest upgrading to MySQL 5… 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… AUTO-INC lock which again was a false one – because single insert slows down a lot of inserts pile up waiting on the AUTO…
