Bug #9514 Provide a way to select a lock status of a row or rows
Submitted: 31 Mar 2005 5:49 Modified: 13 May 2010 16:04
Reporter: Lachlan Mulcahy Email Updates:
Status: Verified Impact on me:
None 
Category:MySQL Server: InnoDB storage engine Severity:S4 (Feature request)
Version:4.1 OS:Any (Any)
Assigned to: Assigned Account CPU Architecture:Any

[31 Mar 2005 5:49] Lachlan Mulcahy 
Description:
The customer would like a feature which allows them to check the lock status of a record without waiting for the lock wait timeout to expire.

Eg. SELECT ... FOR UPDATE NOWAIT;

or.

Eg. SELECT LOCK_STATUS(id) FROM t1 WHERE id=1;

Could return 1 for the record is locked and 1 otherwise.

How to repeat:
N/a

Suggested fix:
n/a
[4 Apr 2005 5:32] Heikki Tuuri 
Hi!

Jan should implement NOWAIT locks for InnoDB.

Regards,

Heikki
[25 Oct 2006 20:16] Daniel Liljebaldh 
Yes we would like to have the NOWAIT functionality. MSSQL and Oracle have it so MySQL should also have it!
[19 Mar 2009 20:54] Bob Hansen 
We would like to have it too. Thanks.