Details
-
Task
-
Status: Closed (View Workflow)
-
Major
-
Resolution: Duplicate
-
None
Description
InnoDB auto_increment value is not persistent and can lead to some
|
values reused, as described by official bug #199.
|
|
This patch fix the problem by writing the last used AUTO_INCREMENT
|
to the root page of the clustered index, using the PAGE_MAX_TRX_ID
|
field, which is unused for root page.
|
|
Two InnoDB variables are introduced to control this persistent behaviour:
|
- innodb_autoinc_persistent
|
This persistent behaviour is enabled or not.
|
|
- innodb_autoinc_persistent_interval
|
The interval of persist max auto_increment value.
|
https://github.com/alibaba/AliSQL/commit/02a52074a637303a6b298b5f452b7673830f3ad8
Attachments
Issue Links
- duplicates
-
MDEV-6076 Persistent AUTO_INCREMENT for InnoDB
- Closed