How to reuse auto_increment values? [duplicate]

by

The maximum number of INT in MySQL 4294967295 if you are creating 1000 threads per minute you would need 1440000 ( 1000 x 60 x 24 ) id’s per day. So you would run out of ids after about 8.17 years.

The maximum number of BIGINT is 18446744073709551615 and that would be enough to create 1000000000 (1 billion) ids per minute for 35 096 years.

So you should be fine with just wasting ids as much as you like and not worry about them.

More Related Contents:

  1. How to insert data to MySQL with auto-incremented column(field)?
  2. How does MySQL Auto Increment work?
  3. mysql Failed to read auto-increment value from storage engine
  4. Reorder / reset auto increment primary key
  5. MySQL Trigger after update only if row has changed
  6. MySQL Query to select data from last week?
  7. Select last N rows from MySQL
  8. How can I modify the size of column in a MySQL table?
  9. MySQL InnoDB foreign key between different databases
  10. How to design a multi tenant mysql database
  11. SQL Order By Count
  12. Replace Into Query Syntax
  13. What resources exist for Database performance-tuning? [closed]
  14. How to connect to MySQL from the command line
  15. Remote connect to clearDB heroku database
  16. How to produce “phantom read” in REPEATABLE READ? (MySQL)
  17. MySQL foreign key to allow NULL?
  18. Difference between two table structure
  19. How to schedule a stored procedure in MySQL
  20. What’s the best way to migrate a Django DB from SQLite to MySQL?
  21. How to get multiple records against one record based on relation?
  22. What are the differences between the BLOB and TEXT datatypes in MySQL?
  23. What is the best way to store media files on a database?
  24. Native JSON support in MYSQL 5.7 : what are the pros and cons of JSON data type in MYSQL?
  25. Foreign key constraints: When to use ON UPDATE and ON DELETE
  26. How to use a user variables in MySQL LIKE clause?
  27. remove all numeric characters from column mysql
  28. MySQL: how to do row-level security (like Oracle’s Virtual Private Database)?
  29. Inventory management with stock options
  30. Failed to connect to mysql at 127.0.0.1:3306 with user root access denied for user ‘root’@’localhost'(using password:YES)

Leave a Comment