Have you seen http://bugs.mysql.com/bug.php?id=37252 ? This implies it is the locking that causes the slowdown (even for InnoDB/Falcon). Can you try your test with locking the table first, doing the INSERT ON DUPLICATE KEY UPDATE statements, and then unlock?
Post: Implications of Metadata Locking Changes in MySQL 5.5
February 1, 2013 By 9 Comments
…0.57 sec) Records: 2 Duplicates: 0 Warnings: 0 session1 >…UPDATE, because ALTER did not block waiting for the transaction to commit. For the reasons described above the implementation of Metadata Locking… table that is accessed on every request, then…null auto_increment primary key) ENGINE=InnoDB; When…
Post: InnoDB's gap locks
March 27, 2012 By 15 Comments
…lock and the gaps between them with a shared gap lock. This lock doesn’t only affect to SELECT … FOR UPDATE…locks to prevent that from happening. 2- innodb_locks_unsafe_for_binlog = 1. Disables the gap locks except for foreign-key constraint checking or duplicate-key…
Post: Improved InnoDB fast index creation
November 6, 2011 By 4 Comments
…| | init | 0.000008 | | Opening tables | 0.000118 | | System lock | 0.000007 | | setup | 0.000027 | | creating table | 0….table without updating indexes took 18 seconds, and about the same time was spent on … ADD KEY (c), ADD KEY(c); Query OK, 0 rows affected (36.42 sec) Records: 0 Duplicates: …
Post: Announcing Percona Server 5.5.28-29.2
December 7, 2012 By 2 Comments
… Fixed: innodb_fake_changes didn’t handle duplicate keys on REPLACE. In some cases this could cause …innodb_fake_changes would allocate too many extents on UPDATE. In some cases this could cause infinite …exclusive (X) row locks to shared (S) locks, these S locks prevent X locks from being taken and…
Post: Announcing Percona Server for MySQL version 5.5.29-30.0
February 26, 2013 By Leave a Comment
… Fixed the upstream bug #67504 that caused spurious duplicate key errors. Errors would happen if a trigger … is present only on slave server while there are updates on the replicated table on the master which … the data pages for printing lock information even if no lock information was going to be …
Post: Shard-Query EC2 images available
May 11, 2011 By 2 Comments
… indexes (not even primary keys). Here is the complete InnoDB schema from one shard. The schema is duplicated 20 times (but not…=16 innodb-stats-auto-update=0 innodb-stats-on-metadata=0 innodb-stats-sample-pages=256 innodb-stats-update-need-lock=0 innodb-status…-write-io-threads=4 join-buffer-size=16M key-buffer-size=64M local-infile=on lock-wait-timeout=300 log-error=/var/log…
Post: MySQL Query Cache
July 27, 2006 By 70 Comments
…locked and is being prepared to be updated. So if you’re using query cache in default configuration you can’t assume locking… queries with select done by primary key, obviously there is no upper boundary -…can effectively use memory on multiple systems so there is no duplication. Memcached is probably…
