MySQL Forums
Forum List  »  General

Advanced Search
New Topic

Re: Auto-increment maximum values?
Posted by: Mike Hillyer
Date: January 11, 2005 10:13AM

Look at the size of the number you just quoted. At 1 million auto_increments a day that works out to

18,446,744,073,709,551,615 / 1000000

= 18446744073709551616 days / 365

= 50539024859478223 years

In other words, at a million inserts a day you will be dead and rotted away before this is a problem.

2^64 is a bigger number than you think, so my advice is to not worry about running out of auto_increment values.

Mike Hillyer, Technical Writer
MySQL AB, www.mysql.com
Office: +1 403-380-6535
Mobile: +1 403-330-0870
Blog: http://www.openwin.org/mike

Navigate: Previous Message• Next Message
Options: Reply• Quote


Subject
Written By
Posted
Auto-increment maximum values?
Jay Vee
January 11, 2005 09:55AM
Re: Auto-increment maximum values?
Mike Hillyer
January 11, 2005 10:13AM


Sorry, you can't reply to this topic. It has been closed.

Content reproduced on this site is the property of the respective copyright holders. It is not reviewed in advance by Oracle and does not necessarily represent the opinion of Oracle or any other party.