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 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 table 2.
> Then they result in deadlock trying to get a lock on the other table.
>
> could this ever happen using the lock tables command in MySQL?
>
> >From: Gerald Clark <[EMAIL PROTECTED]>
> >To: Kurt Washington <[EMAIL PROTECTED]>
> >CC: [EMAIL PROTECTED]
> >Subject: Re: possible deady
> >Date: Mon, 02 Apr 2001 09:28:25 -0500
> >
> >Kurt Washington wrote:
> > >
> > > I am curious if any knows of possible deadlock
> > > conditions that can occur when using the lock tables command in MySQL
> >when
> > > you are referencing multiple tables?
> > > _________________________________________________________________
> > > Get your FREE download of MSN Explorer at http://explorer.msn.com
> > >
> > > ---------------------------------------------------------------------
> > > Before posting, please check:
> > > http://www.mysql.com/manual.php (the manual)
> > > http://lists.mysql.com/ (the list archive)
> > >
> > > To request this thread, e-mail <[EMAIL PROTECTED]>
> > > To unsubscribe, e-mail
> ><[EMAIL PROTECTED]>
> > > Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php
> >
> >Since you can not read or write any files you did not obtain a lock for,
> >what deadlock could you envision?
> >
> >---------------------------------------------------------------------
> >Before posting, please check:
> > http://www.mysql.com/manual.php (the manual)
> > http://lists.mysql.com/ (the list archive)
> >
> >To request this thread, e-mail <[EMAIL PROTECTED]>
> >To unsubscribe, e-mail
> ><[EMAIL PROTECTED]>
> >Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php
> >
>
> _________________________________________________________________
> Get your FREE download of MSN Explorer at http://explorer.msn.com
---------------------------------------------------------------------
Before posting, please check:
http://www.mysql.com/manual.php (the manual)
http://lists.mysql.com/ (the list archive)
To request this thread, e-mail <[EMAIL PROTECTED]>
To unsubscribe, e-mail <[EMAIL PROTECTED]>
Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php
