The 2021-01-05: mysql on the id implementation logic is what look like? # # f greatly architects a daily topic

CodePudding user response:

Mysql 8.0 and 8.0 is not the same as before, table 8.0 before the increase in memory, each service can get the maximum value in the table, to do the current increment value, so there will be physically deleted after, the risk of id is to be repeated,
After 8.0, is a physical storage, physically deleted after id will not change