From: Jim Starkey
Date: January 28 2009 8:26pm
Subject: Another Idea for Transaction Lifetime Control
List-Archive: http://lists.mysql.com/falcon/444
Message-Id: <4980BF6D.6030003@nimbusdb.com>
MIME-Version: 1.0
Content-Type: text/plain; charset=ISO-8859-1; format=flowed
Content-Transfer-Encoding: 7bit

Here's another idea.  Define an "in-use" flag in the transaction 
object.  Before a scavenge, clear the in-use flag for transactions.  
During scavenge, set the flag on every transaction referenced.  At the 
end of scavenge, purge all transaction that are a) committed and b) not 
marked as in-use.

Since the flag is used exclusively by the scavenge thread, no locking is 
required.

-- 
Jim Starkey
President, NimbusDB, Inc.
978 526-1376