Not the answer you need?
Register and ask your own question!

InnoDB auto_increment

mattj.morrison@gmail.com[email protected] EntrantCurrent User Role Participant
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.

Comments

  • AlexNAlexN Contributor Current User Role Advisor
    If I understand it correctly, there will be no performance degradation.
Sign In or Register to comment.

MySQL, InnoDB, MariaDB and MongoDB are trademarks of their respective owners.
Copyright ©2005 - 2020 Percona LLC. All rights reserved.