How does MySQL determine the auto_increment starting point on a server restart?

I recently restarted my virtual webserver and noticed on one of the tables that the auto_increment number had changed. I had deleted some rows out of this table so it appears that it does not simply start where it left off before the restart, but rather somehow recalculates the auto_increment number. Is this true and if so how does it determine this number?

if it matters to you, then you may be doing something wrong

the only feature you should rely on is that every auto_increment number is unique

Haha, I did figure that out. Not going to tell you how because you would laugh at me. :slight_smile: Was more just curious but you’re right, it should never really matter. Case closed.

This topic was automatically closed 91 days after the last reply. New replies are no longer allowed.