Transactions and Table/Row Locking

Discussion of open issues, suggestions and bugs regarding ADO.NET provider for MySQL
Post Reply
Posts: 7
Joined: Wed 07 Feb 2007 19:40

Transactions and Table/Row Locking

Post by bunton » Wed 21 Feb 2007 19:58

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.


Posts: 2756
Joined: Mon 13 Mar 2006 07:43

Post by Alexey » Fri 23 Feb 2007 10:13

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

Post Reply