MySQL REPEATABLE-READ Workbench transaction level

Question

We have set the following in the my.ini file

[mysqld] transaction-isolation = READ-COMMITTED

We assume this setting will be the default for all user sessions.

When logging in using PHPMyAdmin the tx_isolation is set correctly and works as expected. However, when connecting to the server using MySQL Workbench 6.0 an examination of the variables shows that the tx_isolation level is set to REPEATABLE-READ. The effects of this isolation level are also as expected.

We want to set the transaction-isolation level to READ-COMMITTED globally, preferably at DB startup.

We have restarted the server (V 5.5.25a) and obviously workbench. Storage engine is INNODB.

Answer 1

SET GLOBAL TRANSACTION ISOLATION LEVEL READ COMMITTED

http://dev.mysql.com/doc/refman/5.5/en/set-transaction.html