task_005_set_transaction_isolation_levels

Transaction Isolation Levels

• Transaction Isolation Levels
  • Check the current transaction isolation level
  • Check global transaction isolation levels
  • Set the transaction isolation level for the current session

Check the current transaction isolation level

select @@transaction_isolation;

Output

mysql> select @@transaction_isolation;
+-------------------------+
| @@transaction_isolation |
+-------------------------+
| REPEATABLE-READ         |
+-------------------------+
1 row in set (0.00 sec)

mysql> 

Check global transaction isolation levels

select @@global.transaction_isolation;

mysql> select @@global.transaction_isolation;
+--------------------------------+
| @@global.transaction_isolation |
+--------------------------------+
| REPEATABLE-READ                |
+--------------------------------+
1 row in set (0.00 sec)

mysql>

Set the transaction isolation level for the current session

set session transaction isolation level read uncommitted;

Output

mysql> set session transaction isolation level read uncommitted;
Query OK, 0 rows affected (0.00 sec)

mysql> select @@transaction_isolation;
+-------------------------+
| @@transaction_isolation |
+-------------------------+
| READ-UNCOMMITTED        |
+-------------------------+
1 row in set (0.00 sec)

mysql>