Jump to content
Karaethon

auto increment question

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?

Share this post


Link to post
Share on other sites

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.

Share this post


Link to post
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.

Share this post


Link to post
Share on other sites

  99,999,999,999 ? Maximum unsigned int is 4,294,967,295

Share this post


Link to post
Share on other sites
1 minute ago, Barand said:

  99,999,999,999 ? Maximum unsigned int is 4,294,967,295

oh, well, i was going off an 11 digit number

Share this post


Link to post
Share on other sites

Yeah, I sorta knew about that, i just wrote that fast, didn't think about actual limit

Share this post


Link to post
Share on other sites

Join the conversation

You can post now and register later. If you have an account, sign in now to post with your account.

Guest
Reply to this topic...

×   Pasted as rich text.   Restore formatting

  Only 75 emoji are allowed.

×   Your link has been automatically embedded.   Display as a link instead

×   Your previous content has been restored.   Clear editor

×   You cannot paste images directly. Upload or insert images from URL.


×
×
  • 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.