gabfl/mysql-batch

Added support for isolation level read-uncommitted

Opened this issue · 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.

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;

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