Re: Which Transaction Isolation Level to use

[Zach Ellis]

Hello John Noble

I'm new to mysql dba so if someone more experienced comes go with them.

From the manual

https://dev.mysql.com/doc/refman/8.0/en/innodb-deadlocks.html

The possibility of deadlocks is not affected by the isolation level, because the isolation level changes the behavior of read operations, while deadlocks occur because of write operations

if you want to have your update transaction act in a serial way use this from the manual

https://dev.mysql.com/doc/refman/8.0/en/innodb-deadlocks-handling.html

SET autocommit=0;
LOCK TABLES t1 WRITE, t2 READ, ...;
... do something with tables t1 and t2 here ...
COMMIT;
UNLOCK TABLES;

hope this helps
Zach Ellis