What if I need a very very big autoincrement ID?

mysql bigint
Artist Kampong picture Artist Kampong · Apr 23, 2011 · Viewed 11.2k times · Source

According to the MySQL website, the signed bigint can go up to 18446744073709551615. What if I need a number bigger than that for the auto-incrementing primary key?

Answer

9000 picture 9000 · Apr 23, 2011

If you insert 1 million records per second 24x7, it will take 584542 years to reach the limit.

I hope by then a next version of MySQL will support bigger ID columns :)

Related questions

What to do when you need integers larger than 20 digits on mysql?

Seems like BIGINT is the biggest integer available on MySQL, right? What to do when you need to store a BIGINT(80) for example? Why in some cases, like somewhere in the Twitter API docs, they recommend us to store these …

Read More
mysql alter int column to bigint with foreign keys

I want to change the datatype of some primary-key columns in my database from INT to BIGINT. The following definition is a toy-example to illustrate the problem: CREATE TABLE IF NOT EXISTS `owner` ( `id` int(11) NOT NULL AUTO_INCREMENT, `thing_…

Read More
Convert binary string to bigint in MySQL?

I am attempting to hash a string to a 64-bit value (bigint) in MySQL. I am aware of the MD5() function, which returns a 128-bit hash as a binary string. I'd be happy to just take the bottom or top 64 …

Read More