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?

Thanks!

Options: ReplyQuote


Subject
Views
Written By
Posted
Row locking
2199
October 04, 2011 01:41AM
975
November 23, 2011 01:55AM
802
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.