MySQL Forums
Forum List  »  InnoDB

How to check lock status of a single record?
Posted by: Rui Mao
Date: September 27, 2010 09:20PM

I'm working on a multiple thread program. All threads need to process records of a table one by one. So when first thread locks some records with a wide range filter, other threads have to wait. And it is impossible to narrow down the filter. So is it possible to let SELECT command select no-locked records only. Or is there any way to check lock status of a specified record?

Options: ReplyQuote


Subject
Views
Written By
Posted
How to check lock status of a single record?
1749
September 27, 2010 09:20PM


Sorry, you can't reply to this topic. It has been closed.

Content reproduced on this site is the property of the respective copyright holders. It is not reviewed in advance by Oracle and does not necessarily represent the opinion of Oracle or any other party.