# InnoDB auto\_increment

**URL:** <https://forums.percona.com/t/innodb-auto-increment/1035>\
**Category:** Other MySQL® Questions\
**Created:** [December 15, 2008, 10:14pm UTC](https://forums.percona.com/t/innodb-auto-increment/1035 "2008-12-15T22:14:00Z")\
**Posts on this page:** 2\
**Page:** 1

<div class="post-metadata">

**Author:** ![mattj.morrison](https://sea1.discourse-cdn.com/flex019/user_avatar/forums.percona.com/mattj.morrison/32/797_2.png) [@mattj.morrison](https://forums.percona.com/u/mattj.morrison)\
**Post date:** [December 15, 2008, 10:14pm UTC](https://forums.percona.com/t/innodb-auto-increment/1035/1 "2008-12-15T22:14:00Z")

</div>

I have a process where there could potentially be frequent rollbacks to a table keyed by an auto\_increment column. Since this causes gaps in the auto\_increment value, I’m wondering if there are, or could be, performance implications. Will these gaps (vs if there were no gaps in the auto\_increment column value) slow down queries as the table grows? I’ve run some small scale tests and have not seen any differences in query performance…yet.

---

<div class="post-metadata">

**Author:** ![AlexN](https://avatars.discourse-cdn.com/v4/letter/a/b9bd4f/32.png) [@AlexN](https://forums.percona.com/u/AlexN)\
**Post date:** [December 16, 2008, 4:18am UTC](https://forums.percona.com/t/innodb-auto-increment/1035/2 "2008-12-16T04:18:00Z")

</div>

If I understand it correctly, there will be no performance degradation.