The Ultimate Guide to High Availability with MariaDB

Comments - START TRANSACTION

2 years, 9 months ago Tibor den Ouden
No deadlock in transaction guarantee

If I have 2 different transactions which: Both only update records from the same table and the first line in the transaction is a select for update (which locks all records touched in the rest of the transaction).

But the where clauses are different, for instance in transaction A it is: where id in (1, 2, 8) and in transaction B it is: id >= 0 and id <= 10. Is it then guaranteed that both transactions never deadlock ?

 
Content reproduced on this site is the property of its respective owners, and this content is not reviewed in advance by MariaDB. The views, information and opinions expressed by this content do not necessarily represent those of MariaDB or any other party.