Transactions and Table/Row Locking

Transactions and Table/Row Locking

Postby 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.

Thanks,
bunton
bunton
 
Posts: 7
Joined: Wed 07 Feb 2007 19:40

Postby 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.
Alexey
 
Posts: 2756
Joined: Mon 13 Mar 2006 07:43


Return to dotConnect for MySQL