mysqlsqldatabasetransactionsisolation-level

How to show transaction isolation level (MySQL)

I want to know what isolation level is set for current Mysql database. How can find it out? I tried searching it on the google but did not find it.

Solution

  • I did a bit of more searching on the google and found out that if have MySQL 5.1+ then you can find out the isolation level by firing below query

    SELECT * FROM information_schema.session_variables
WHERE variable_name = 'tx_isolation';