Puoi iniziare leggendo:

http://dev.mysql.com/doc/refman/5.1/en/lock-tables.html
http://dev.mysql.com/doc/refman/5.1/...ock-modes.html