Clever Geek Handbook

MySQL REPEATABLE-READ Workbench transaction level not set

We have set the following in my.ini file

[tricks] transactional isolation = READ-COMMITTED

Let's assume this parameter will be used by default for all user sessions.

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

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

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

+1


source to share


1 answer 


SET GLOBAL TRANSACTION ISOLATION LEVEL READ COMMITTED


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

0


source






More articles:


All Articles