…. Concurrent INSERT … ON DUPLICATE KEY UPDATE statements on a table with an AUTO_INCREMENT column could result in spurious duplicate key errors (and, as a result, lost data due to some rows being updated rather than inserted) with…
Post: Announcing Percona Server 5.5.27-28.0
August 23, 2012 By 5 Comments
…. Concurrent INSERT … ON DUPLICATE KEY UPDATE statements on a table with an AUTO_INCREMENT column could result in spurious duplicate key errors (and, as a result, lost data due to some rows being updated rather than inserted) with…
Comment: Using any general purpose computer as a special purpose SIMD computer
May 16, 2011 By 5 Comments
… results are merged together with ON DUPLICATE KEY UPDATE in the insert. INSERT INTO #tmp values (…),(…) ON DUPLICATE KEY UPDATE set expr1=expr1, expr2 = expr2, expr3…
Post: Distributed Set Processing with Shard-Query
May 14, 2011 By 27 Comments
… table and thus the logic for applying changes via ON DUPLICATE KEY UPDATE is the same. All of the fastest incremental materialized view…_airport_id` * storage node result set merge optimization enabled: ON DUPLICATE KEY UPDATE `origin_airport_id`=VALUES(`origin_airport_id`), `count(*)`=`count(*)` + VALUES…
Comment: INSERT ON DUPLICATE KEY UPDATE and summary counters.
November 20, 2008 By 48 Comments
i sinc i add duplicate key the insert not work that not work now someone know …_unlimited (data_key,data_value,agent_id,data_group,access_time) VALUES (‘$key‘, ‘$value’, ‘$group’, ‘$owner_id’, NOW()) ON DUPLICATE KEY UPDATE access_time = NOW…
Comment: INSERT ON DUPLICATE KEY UPDATE and summary counters.
February 28, 2008 By 48 Comments
… a whole bunch of inserts but update them if they exist already and update the primary key also? so for example insert into tmmember values (‘STRES17N’,'SK’,’1725′,’ESTRES17′,’N',’6′,’255′,’-1′) on duplicate key update…
Post: Avoiding auto-increment holes on InnoDB with INSERT IGNORE
November 29, 2011 By 8 Comments
… performance but with a small cost. Queries like INSERT … ON DUPLICATE KEY UPDATE produce gaps on the auto_increment column. To avoid this… NULL AUTO_INCREMENT, `name` int(11) DEFAULT NULL, PRIMARY KEY (`id`), UNIQUE KEY `uniqname` (`name`) ) ENGINE=InnoDB AUTO_INCREMENT=2 DEFAULT CHARSET…
Post: MySQL Users Conference - Innodb
May 9, 2007 By 6 Comments
…. There are probably similar problems in INSERT IGNORE and ON DUPLICATE KEY UPDATE cases. Now In MySQL 5.1+ it is also possible… get relaxed locks in many other cases. Gap or next-key locks which limit concurrency in many cases can be removed… match where clause (think for example about running not-indexed UPDATE which has to lock all rows in Innodb right now…
Comment: InnoDB vs MyISAM vs Falcon benchmarks - part 1
April 9, 2007 By 117 Comments
… file used 11 queries max (5 selects, 6 insert on duplicate key updates). Using InnoDB on all tables, import took 8 hours, as… after import (before empty). All selects and on updates were using primary key. I’d be interested what made such difference, because…
Comment: INSERT ON DUPLICATE KEY UPDATE and summary counters.
March 23, 2012 By 48 Comments
… Can you please explain how really locking in INSERT … ON DUPLICATE KEY UPDATE works. As I recall: Lock 1) Transaction 1 locks row… INSERT Lock 2) Transaction 2 tries to locks row for UPDATE (goes into queue) Lock 3) Transaction 1 tries to locks row for UPDATE (goes into queue) It is reasonable not to release Lock…
