mysql-batch icon indicating copy to clipboard operation
mysql-batch copied to clipboard

Added support for isolation level read-uncommitted

Open elranr opened this issue 6 years ago • 2 comments

Can you add support for for different isolation level per session in the select command for preventing long queries to lock the tables.

elranr avatar Mar 01 '18 11:03 elranr

Do you mean running the following before the migrations?

SET TRANSACTION ISOLATION LEVEL READ COMMITTED;

Then wrapping all updates with:

START TRANSACTION;

UPDATE ....;

COMMIT;

gabfl avatar Mar 01 '18 12:03 gabfl

I meant for the select operation , not for the update operation but both will prevent table lock .

elranr avatar Mar 04 '18 16:03 elranr