Re: possible deady(dead lock)

2001-04-02 Thread Gerald Clark
The manual chapter 7.32 declares it to be deadlock free. Did you read the manual? Kurt Washington wrote: > > here is an example in perl > my $sthLock = $dbh->prepare("LOCK TABLES table1 WRITE, table2 WRITE") > > could there ever be a possibility of a race condition or dead lock > where you ha

Re: possible deady(dead lock)

2001-04-02 Thread Kurt Washington
here is an example in perl my $sthLock = $dbh->prepare("LOCK TABLES table1 WRITE, table2 WRITE") could there ever be a possibility of a race condition or dead lock where you have two threads that access the code almost at the same time One gets a lock on table one and another gets a lock on t