Devart Forums

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

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