MySQL REPEATABLE-READ Workbench transaction level not set

1
votes

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.

1
mysqlinnodbworkbenchtransaction-isolationread-committed
There's a verified bug on this. No idea what the status of it though. Related: stackoverflow.com/questions/25268782/…, stackoverflow.com/questions/26208007/… – Sithsu

1 Answers

0
votes
SET GLOBAL TRANSACTION ISOLATION LEVEL READ COMMITTED

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