mysql workbench 提交事务,未设置MySQL REPEATABLE-READ Workbench事务级别

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