Re: Please advise [Re: Restore locking: TRUNCATE resets AUTO_INCREMENT on InnoDB]

[Ingo Strüwing]

Hi Rafal,

Rafal Somla, 28.07.2009 07:19:

> Hi,
> 
> Ingo Strüwing wrote:
>> Still we would have two options to make this safe:
>>
>> A) Explicitly transport the auto_increment value.
>>    A.1) Since the value is part of the meta data of a table in the
>>         backup image, we could modify si_objects to save the value
>>         in a context object so that the value used to create the last
>>         table can be queried from si_objects. However, this means that
>>     si_objects will have to parse the serialization string.
> 
> I want to note that A.1) might be possible without parsing the
> serialisation string (I mean, parsing the CREATE TABLE statement). Since
> serialization string produced by si_objects can consist of several
> sub-strings, it is possible that the value of auto_increment is appended
> to it in a form which is easy to retrieve at restore time.

Ok, but current backup images don't have that. What do you suggest
regarding treatment of old images?

Regards
Ingo
-- 
Ingo Strüwing, Database Group
Sun Microsystems GmbH, Sonnenallee 1, D-85551 Kirchheim-Heimstetten
Geschäftsführer: Thomas Schröder,   Wolfgang Engels,   Wolf Frenkel
Vorsitzender des Aufsichtsrates: Martin Häring   HRB München 161028