Skip to content

Instantly share code, notes, and snippets.

@avargas

avargas/gist:1328457

Created October 31, 2011 18:53
Show Gist options
  • Save avargas/1328457 to your computer and use it in GitHub Desktop.
Save avargas/1328457 to your computer and use it in GitHub Desktop.
Download ZIP
MySQL query without locking
Raw
gistfile1.sql
SET SESSION TRANSACTION ISOLATION LEVEL READ UNCOMMITTED;
select * from big_data_table;
SET SESSION TRANSACTION ISOLATION LEVEL REPEATABLE READ;
Sign up for free to join this conversation on GitHub. Already have an account? Sign in to comment