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