MySQL Forums
Forum List  »  Quality Assurance

Row locking
Posted by: Sanita Linguo
Date: October 04, 2011 01:41AM

Hi all,

A quick question, when I do a write row lock on two particular record rows (for e.g. update row no. 2 and 3), and before the lock is released, I do another read on another two record rows (for e.g. select row no. 3 and 4), does the read for 4 go as per normal before the lock is released on 3, or will it have to wait for the lock on 3 to be released before the reads for 3 and 4 is being done?


Options: ReplyQuote

Written By
Row locking
October 04, 2011 01:41AM
November 23, 2011 01:55AM
February 12, 2012 09:29PM

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.