MySQL Like SQL Server With Nolock Use

• Session Scope

          SET SESSION TRANSACTION ISOLATION LEVEL READ UNCOMMITTED ;

          SELECT * FROM TABLE_NAME ;

          SET SESSION TRANSACTION ISOLATION LEVEL REPEATABLE READ ;

• Global Scope

          SET GLOBAL TRANSACTION ISOLATION LEVEL READ UNCOMMITTED ;

• Isolation Level Variables

          SELECT @@global.tx_isolation;

          SELECT @@tx_isolation;