Jump to content

auto increment question


Karaethon

Recommended Posts

What happens when auto incement maxes out? in my db my auto increment field is int(11) so i know it won't happen soon BUT it will happen because this table is filled with script generated data, some is alive but older data will be expired. Since the old data is un-needed should I delete it? If deleted will auto-increment 'roll over' and start at the first number again?

Link to comment
Share on other sites

38 minutes ago, Barand said:

It will go back to 0.

If it really worries you you can move to BIGINT UNSIGNED.

Then, if you add 1,000,000 records every second it will take 584,942 years to run out of ids.

ok, wasnt sure what happened. Not really worried 99,999,999,999 records will take a long time to fill, but i was thinking about the long game.

Link to comment
Share on other sites

Archived

This topic is now archived and is closed to further replies.

×
×
  • Create New...

Important Information

We have placed cookies on your device to help make this website better. You can adjust your cookie settings, otherwise we'll assume you're okay to continue.