Bug #56969 auto_increment can increase by values other than 1
Submitted: 23 Sep 2010 13:35 Modified: 18 Oct 2010 19:30
Reporter: Scott Noyes Email Updates:
Status: Closed Impact on me:
None 
Category:MySQL Server: Documentation Severity:S3 (Non-critical)
Version:any OS:Any
Assigned to: John Russell CPU Architecture:Any

[23 Sep 2010 13:35] Scott Noyes
Description:
The auto_increment_increment and auto_increment_offset can cause auto_increment o initialize and increase by values other than 1. This fact is not correctly represented in the InnoDB auto_increment handling description.

How to repeat:
http://dev.mysql.com/doc/refman/5.1/en/innodb-auto-increment-handling.html

"InnoDB increments by one the value retrieved by the statement and assigns it to the column "

"If the table is empty, InnoDB uses the value 1"

Suggested fix:
Documentation should mention that it doesn't have to be 1 (although it usually is).
[18 Oct 2010 19:30] John Russell
Mentioned that the starting value and increment value can be overridden by the config options mentioned in the bug text.