5 messages in com.mysql.lists.clusterRe: Transactions / locking / atomic o...
FromSent OnAttachments
Ted Schundler18 Apr 2005 13:48 
Martin Skold18 Apr 2005 14:24 
pek...@mysql.com18 Apr 2005 14:38 
Ted Schundler18 Apr 2005 14:58 
pek...@mysql.com18 Apr 2005 15:19 
Subject:Re: Transactions / locking / atomic operations
From:pek...@mysql.com (pek@mysql.com)
Date:04/18/2005 03:19:56 PM
List:com.mysql.lists.cluster

seems doing a useless update will correctly lock the relevant rows.

Yes, that's a "good" workaround.

It would appreciated if "FOR UPDATE" was supported. As I understand UPDATE in NDB = DELETE + INSERT, so it's not such lightweight

Only if primary key is updated (not the normal case).

Also, is there a way to increase the lock wait timeout?

See online manual for TransactionDeadlockDetectionTimeout.