The value of the AUTO_INCREMENT field increases too quickly

[eleven-f]

The experiment found that there were only about 26 million data in the table, but the IDs automatically grew to 136 million. Will this growth rate cause the IDs of a large table (expected to store about 10 billion data) to quickly grow to the upper limit of bigint? Can it support long-term data insertion?

[ixzc]

it can support long-term data insertion.