How to show transaction isolation level (MySQL)

Question

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.

Answer 1

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';