we had this in ceilometer events. you can see it here: https://github.com/openstack/ceilometer/commit/898cd3d036c4358aa16f7b3e2028365dc9829213 note, that patch is removing it because it slowed everything way down because of locking. if you can avoid it, avoid it. On 08/12/2015 7:28 AM, Renat Akhmerov wrote: > Hi, > > Moshe, thanks a lot for bringing this up. I remember I tried to find a > way to change isolation level per connection but also was unable to do > that. > > An advice from oslo team would be very helpful. > > Renat Akhmerov > @ Mirantis Inc. > > > >> On 08 Dec 2015, at 13:41, ELISHA, Moshe (Moshe) >> <moshe.elisha at alcatel-lucent.com >> <mailto:moshe.elisha at alcatel-lucent.com>> wrote: >> >> Hi, >> We at Mistral want to move from the default transaction isolation >> level of REPEATABLE READ to READ COMMITTED as part of a bugfix[1]. >> I did not find a way to pass the isolation level to sqlachemy using >> oslo.db and the current solution is to use monkey-patching[2] that >> adds the “isolation_level” property. >> Is there currently a better way to set the default isolation level? >> If not – I will create a BP for it. >> Thanks. >> [1]https://review.openstack.org/#/c/253819 >> [2]https://review.openstack.org/#/c/253819/11/mistral/db/sqlalchemy/base.py >> __________________________________________________________________________ >> OpenStack Development Mailing List (not for usage questions) >> Unsubscribe:OpenStack-dev-request at lists.openstack.org >> <mailto:OpenStack-dev-request at lists.openstack.org>?subject:unsubscribe >> http://lists.openstack.org/cgi-bin/mailman/listinfo/openstack-dev > > > > __________________________________________________________________________ > OpenStack Development Mailing List (not for usage questions) > Unsubscribe: OpenStack-dev-request at lists.openstack.org?subject:unsubscribe > http://lists.openstack.org/cgi-bin/mailman/listinfo/openstack-dev -- gord -------------- next part -------------- An HTML attachment was scrubbed... URL: <http://lists.openstack.org/pipermail/openstack-dev/attachments/20151208/4acf71c7/attachment.html>