Karaethon Posted March 23, 2019 Share Posted March 23, 2019 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 More sharing options...
Barand Posted March 23, 2019 Share Posted March 23, 2019 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. Link to comment Share on other sites More sharing options...
Karaethon Posted March 23, 2019 Author Share Posted March 23, 2019 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 More sharing options...
Barand Posted March 23, 2019 Share Posted March 23, 2019 99,999,999,999 ? Maximum unsigned int is 4,294,967,295 Link to comment Share on other sites More sharing options...
Karaethon Posted March 23, 2019 Author Share Posted March 23, 2019 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 Link to comment Share on other sites More sharing options...
Barand Posted March 23, 2019 Share Posted March 23, 2019 see mysql integer types Link to comment Share on other sites More sharing options...
Karaethon Posted March 23, 2019 Author Share Posted March 23, 2019 Yeah, I sorta knew about that, i just wrote that fast, didn't think about actual limit Link to comment Share on other sites More sharing options...
Recommended Posts
Archived
This topic is now archived and is closed to further replies.