New answers tagged auto-increment
The disappearing rows are a common behavior of mysqlcheck (or myisam check), because it tries to repair the corrupted blocks. Other engines (eg. Oracle) have more advanced repairing algorithms, that can actually preserve your data. Corruption usually appears when there's a problem with the disk (space, partition headers etc), so start by checking them. Then ...
There are many things that can cause gaps in an IDENTITY column (rollbacks, deletes), but in this case due to the jump I suspect it is this bug - caused by the changes to IDENTITY with the introduction of SEQUENCE: Connect # 739013 : Failover or Restart Results in Reseed of Identity So I bet that if you look in SQL Server's error logs, the rows ...
When inserts are rolled back, the identity values are NOT reset. This is one explanation of the so called "skipped" values.
Top 50 recent answers are included