How can we check the current MySQL transaction isolation level?

By executing SELECT @@TX_ISOLATION command we can check the current MySQL transaction isolation level.

Example

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

karthikeya Boyini

Updated on: 22-Jun-2020

3K+ Views

Kickstart Your Career

Get certified by completing the course

Get Started