If some one has a Table structure some thing like this,
CREATE TABLE IF NOT EXISTS `domain_source` (`nid` int(11) NOT NULL DEFAULT '0', `domain_id` int(11) NOT NULL DEFAULT '0', PRIMARY KEY (`nid`) ) ENGINE=InnoDB DEFAULT CHARSET=utf8 COMMENT='Stores the canonical domain for each node.';
On Heavy load i get Deadlock on Insert to this Table Structure. I usually delete and insert a row in the table rather than update as the engine is Innodb.