Read_only and InnoDB transactions

[Viacheslav Biriukov]

Hi all.

From the Mysql Documentation:

If you attempt to enable read_only while other clients hold explicit table
> locks or have pending transactions, the attempt blocks until the locks are
> released and the transactions end. While the attempt to enable read_only is
> pending, requests by other clients for table locks or to begin transactions
> also block until read_only has been set.



But when I try to set "SET GLOBAL read_only = ON;" It brake running
transaction.

-- 
Viacheslav Biriukov
BR