The SHOW TRANSACTION statement shows you the current transaction’s priority or isolation level.

SHOW TRANSACTION can be run outside of transactions but simply returns NORMAL priority and SERIALIZABLE isolation level.

Synopsis

SHOW TRANSACTION ISOLATION LEVEL PRIORITY STATUS

Required Privileges

No privileges are required to view transaction isolation level or priority.

Examples

Show the Transaction’s Isolation Level

> BEGIN;

> SET TRANSACTION ISOLATION LEVEL SNAPSHOT, PRIORITY HIGH;

> SHOW TRANSACTION ISOLATION LEVEL;
+-----------------------------+
| TRANSACTION ISOLATION LEVEL |
+-----------------------------+
| SNAPSHOT                    |
+-----------------------------+

Show the Transaction’s Priority

> BEGIN;

> SET TRANSACTION ISOLATION LEVEL SNAPSHOT, PRIORITY HIGH;

> SHOW TRANSACTION PRIORITY;
+----------------------+
| TRANSACTION PRIORITY |
+----------------------+
| HIGH                 |
+----------------------+

See Also



Yes No