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

[Konstantin Osipov]

* Ingo Strüwing <Ingo.Struewing@stripped> [09/07/27 21:00]:
> An idea to solve this was to retrieve the auto_increment value from the
> tables before they are truncated. And then set these values after data
> restore.
> 
> This would improve the situation a lot, but still leave stray INSERTs a
> chance to increment the values between CREATE TABLE and LOCK TABLES.

You need to remember the value of the auto increment in the image, 
then you don't have to extract it, and don't rely on favourable
concurrency.


--