[ZODB-Dev] RelStorage: Pack no longer holding the commit lock for prolonged periods
Shane Hathaway
shane at hathawaymix.org
Tue May 24 14:22:51 EDT 2011
On 05/23/2011 01:58 PM, Martijn Pieters wrote:
> I've cleared the last area where RelStorage packing could hold the
> transaction lock for long periods of time, during empty transaction
> deletion:
>
> http://zope3.pov.lt/trac/changeset/121783/relstorage/trunk
>
> During a large pack, this section could potentially hold the
> transaction lock for a long period of time and thus block an entire
> RelStorage Zope cluster. It now deletes transactions is batches of
> 1000 and releases the lock in between.
>
> Shane, I have only tested this against PostgreSQL and Oracle, but I am
> pretty confident the MySQL SQL syntax is correct. This has been run on
> the live Elkjøp Oracle cluster without problems.
It looks very nice, thanks! I'll test it with my Buildbot.
Shane
More information about the ZODB-Dev
mailing list