List:Maria Storage Engine« Previous MessageNext Message »
From:Oleksandr \"Sanja\" Byelkin Date:November 11 2008 9:07am
Subject:Re: Versioning for delete & update (for transactional tables) (4619)
View as plain text  

Guilhem Bichot пишет:
> Hello Monty,
> 
> I have some questions about the specs.
> 
>> -=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-
>> TASK...........: Versioning for delete & update (for transactional 
>> tables)
>> DESCRIPTION:
>>
>> Versioning for delete & update (for transactional tables)
>>
>>
>> HIGH-LEVEL SPECIFICATION:
>>
>> For delete, instead of physically deleting rows when maria_delete() is
>> called, we will change the delete internally to an update where the
>> row and it's keys are tagged with the current transaction id as their
>> delete trans id.
> 
> Will there be a new type of REDO log record to describe this change done 
> to the row or key? Or does some existing REDO log record need to be 
> slightly changed?
> If there is a "yes" to one of these questions, we need to update 
> recovery's code to add/modify "log record replay" functions.


As I remember our plans now we use the record which purger will use and 
for delete will be different record.

[skip]

-- 
    __  ___     ___ ____  __
   /  |/  /_ __/ __/ __ \/ /    Mr. Oleksandr Byelkin <sanja@stripped>
  / /|_/ / // /\ \/ /_/ / /__   MySQL AB, Full-Time Developer
/_/  /_/\_, /___/\___\_\___/   Lugansk, Ukraine
        <___/   www.mysql.com
Thread
Re: Versioning for delete & update (for transactional tables) (4619)Guilhem Bichot10 Nov
  • Re: Versioning for delete & update (for transactional tables) (4619)Oleksandr \"Sanja\" Byelkin11 Nov
  • Re: Versioning for delete & update (for transactional tables)(4619)Michael Widenius11 Nov
    • Re: Versioning for delete & update (for transactional tables) (4619)Guilhem Bichot12 Nov
      • Re: Versioning for delete & update (for transactional tables) (4619)Guilhem Bichot12 Nov