List:General Discussion« Previous MessageNext Message »
From:Jim Faucette Date:July 23 1999 8:07pm
Subject:Re: locking problem...?
View as plain text  
elble@stripped wrote:
> 
> hello, Sinisa.
> 
> BTW, this works:
> 
> client #1.) lock tables foobar read; ('READ' lock acquired)
> client #2.) update low_priority foobar set this=1; (pending 'WRITE' lock, blocked)
> client #3.) select * from foobar; (this doesn't block now!!!)
> 
> i see now, it doesn't really have anything to do with locking per se. ;-)
> 
> but, am i the only person who has this problem?
> 

In general read and write locking is not intuitive. Whether at the
system or application level it usually takes time and effort to
understand get used to the 'logic'.

  jim...
Thread
locking problem...?elble20 Jul
  • locking problem...?sinisa20 Jul
    • Re: locking problem...?elble20 Jul
Re: locking problem...?elble20 Jul
  • Re: locking problem...?sinisa21 Jul
    • Re: locking problem...?elble21 Jul
      • Re: locking problem...?sinisa22 Jul
        • Re: locking problem...?elble22 Jul
          • Re: locking problem...?sinisa22 Jul
            • Re: locking problem...?elble22 Jul
              • Re: locking problem...?elble23 Jul
                • Re: locking problem...?Jim Faucette24 Jul
                  • Re: locking problem...?elble24 Jul
                    • Re: locking problem...?Michael Widenius29 Jul
                      • Re: locking problem...?elble29 Jul