Added support for isolation level read-uncommitted
Opened this issue · 2 comments
elranr commented
Can you add support for for different isolation level per session in the select command for preventing long queries to lock the tables.
gabfl commented
Do you mean running the following before the migrations?
SET TRANSACTION ISOLATION LEVEL READ COMMITTED;
Then wrapping all updates with:
START TRANSACTION;
UPDATE ....;
COMMIT;
elranr commented
I meant for the select operation , not for the update operation but both will prevent table lock .