Hi,
I'm using sqlalchemy version 0.7.8 and MySQL Ver 14.14 Distrib 5.5.25, for
osx10.6 (i386) using readline 5.1. All my tables are using InnoDB.
I'm trying to change the isolation_level,
following http://docs.sqlalchemy.org/en/rel_0_7/dialects/mysql.html
engine = create_engine(
the isolation level is set on a cursor that's not within the usual logged
stream in this case. But you can see what it's set to by selecting these
variables:
from sqlalchemy import create_engine
e = create_engine(mysql://scott:tiger@localhost/test, echo=True,
isolation_level=READ
Thanks!
The reason I was asking this is that I can't see the effect of this
setting. I'm using Sequel Pro and I get the same result as you in
sqlalchemy. I forgot that you needed to also set the transaction isolation
setting in Sequel, or to set it globally, which I did: