http://dev.mysql.com/doc/refman/5.0/...ing-reads.html

1)....
Locks set by IN SHARE MODE and FOR UPDATE reads are released when the transaction is committed or rolled back.
2) dipende da come fai la prova....