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.
解决方案SET GLOBAL TRANSACTION ISOLATION LEVEL READ COMMITTED