Skip to content
New issue

Have a question about this project? Sign up for a free GitHub account to open an issue and contact its maintainers and the community.

By clicking “Sign up for GitHub”, you agree to our terms of service and privacy statement. We’ll occasionally send you account related emails.

Already on GitHub? Sign in to your account

Added support for isolation level read-uncommitted #5

Open
elranr opened this issue Mar 1, 2018 · 2 comments
Open

Added support for isolation level read-uncommitted #5

elranr opened this issue Mar 1, 2018 · 2 comments

Comments

@elranr
Copy link

elranr commented Mar 1, 2018

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

@gabfl
Copy link
Owner

gabfl commented Mar 1, 2018

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
Copy link
Author

elranr commented Mar 4, 2018

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

Sign up for free to join this conversation on GitHub. Already have an account? Sign in to comment
Labels
None yet
Projects
None yet
Development

No branches or pull requests

2 participants