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

Create an account or sign in to comment

You need to be a member in order to leave a comment

Create an account

Sign up for a new account in our community. It's easy!

Register a new account

Sign in

Already have an account? Sign in here.

Sign In Now

×

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.