Re: Re: RTFM - Show locks

The GET_LOCK() and RELEASE_LOCK() functions might help you, if you need this feature enough to build it yourself. Cheers, Kent Hoover Feed the filter: database, query - Before posting, please check:

RE: RTFM - Show locks

I too have wondered this... it looks like the manual just says (in your case) user 'b' will wait indefinitely for the lock held by user 'a' to be released. Maybe you could just have user 'a' hold a READ or READ LOCAL lock and not a WRITE lock, therefore user 'b' will still be able to do SELECTS