Transactions and Table/Row Locking

[bunton]

Can somebody please quickly tell me if tables/rows are automatically locked during a transaction?

If so, are they locked until the transaction is either committed or rolled-back?

What happens if somebody tries to access the locked row/table from another Connection? Is an exception thrown immediately or does the Connection attempt to wait for the locked table/rows to become available again and then throw an exception after some timeout period?

I have read a little bit about transaction isolation levels but have limited understanding of them.

Thanks,
bunton

[Alexey]

Please consult MySQL Server documentation, because this topic is beyond the scope of our support program.
Especially get acquainted with InnoDB.