3 messages in com.mysql.lists.clusterRe: transactions and table locks
FromSent OnAttachments
Patrick Duda14 Aug 2006 07:50 
Stewart Smith14 Aug 2006 19:51 
Stewart Smith15 Aug 2006 19:24 
Subject:Re: transactions and table locks
From:Stewart Smith (stew@mysql.com)
Date:08/15/2006 07:24:52 PM
List:com.mysql.lists.cluster

(replying to list so that everybody can learn)

On Tue, 2006-08-15 at 14:58 -0500, Patrick Duda wrote:

Thanks for the reply but I guess I am still not understanding this. Or I am still doing something wrong.

I have used SELECT FOR UPDATE in other programs running against a single database and it worked just fine. But when I try it with the cluster it doesn't seem to do anything.

There were quite recently bugs fixed in this area - make sure you're running the latest version (check the changelog in the manual to see if your version has the fix)

Jumpstart your cluster: http://www.mysql.com/consulting/packaged/cluster.html