How is the auto increment number generated and reset?

I believe there are much more details need to be revealed regarding how the auto increment number from the DB. Do we need to perform the actual insert operation to make the number increase? How do we reset it every second? Are we just executing the reset command every second? How we can get an exact 1 second interval considering the time skew issue?

1 Like