List:General Discussion« Previous MessageNext Message »
From:Gerald Clark Date:April 2 2001 3:20pm
Subject:Re: possible deady(dead lock)
View as plain text  
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 <gerald_clark@stripped>
> >To: Kurt Washington <kwhitsel_mysql@stripped>
> >CC: mysql@stripped
> >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 <mysql-thread70218@stripped>
> > > To unsubscribe, e-mail
> ><mysql-unsubscribe-gerald_clark=suppliersystems.com@stripped>
> > > 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 <mysql-thread70257@stripped>
> >To unsubscribe, e-mail
> ><mysql-unsubscribe-kwhitsel_mysql=hotmail.com@stripped>
> >Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php
> >
> 
> _________________________________________________________________
> Get your FREE download of MSN Explorer at http://explorer.msn.com
Thread
Re: possible deady(dead lock)Kurt Washington2 Apr
  • Re: possible deady(dead lock)Gerald Clark2 Apr