I have a question regarding MySQL locking and transaction management. My Question is ..does mysql takes lock on the the tuple/table on which I am doing select/update in a transaction ?
With MyISAM, you can use the
With InnoDB, the rules are:
This is probably not a thorough list, but should get you the general picture.
Each INSERT, UPDATE, and DELETE performs a full table lock before perform in the SQL command.
There are other posts I have for to look over to see how InnoDB and MyISAM differ