Re: Transactions / locking / atomic operations - pek...@mysql.com - com.mysql.lists.cluster

5 messages in com.mysql.lists.clusterRe: Transactions / locking / atomic o...

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.