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