[ZODB-Dev] RelStorage: Pack no longer holding the commit lock for	prolonged periods
    Martijn Pieters 
    mj at zopatista.com
       
    Mon May 23 15:58:35 EDT 2011
    
    
  
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.
-- 
Martijn Pieters
    
    
More information about the ZODB-Dev
mailing list