On Jun 19, 2004, at 6:03 AM, Terry Riley wrote:

Just a suggestion, Kevin, but how about changing from INT to BIGINT?


I thought of trying that, but since we're nowhere near the limit even for an INT I think changing to BIGINT is premature. I want to find out a bit more about what's happening first. The fact that it stops at such a low number makes me think it's not related to the size of the field.


I saw a reference in a post (to a different mailing llist) to a tables auto_increment limit, as though that was something different from the max value of an INT, but I haven't run across it in any official documentation.

Kevin

----------Original Message---------

We have a table with a primary index which is INT NOT NULL
AUTO_INCREMENT.

After inserting ~87,000,000 entries, we started seeing error 1062,
ER_DUP_ENTRY.

We can get going again after doing an ALTER TABLE to reset the
auto_increment starting point, but this takes about an hour...

I've seen a couple of places where how to get around this problem was
discussed, but nobody seems to discuss *why* this occurs in the first
place.

Does anyone know why MySQL would start failing to increment an
auto_increment index properly when it's nowhere near the upper limit?
Does anyone know a way to get things functioning again without a couple
of hours downtime?


Hoping there's an answer out there somewhere...

Kevin Brock
[EMAIL PROTECTED]


--
MySQL General Mailing List
For list archives: http://lists.mysql.com/mysql
To unsubscribe: http://lists.mysql.com/[EMAIL PROTECTED]




--
MySQL General Mailing List
For list archives: http://lists.mysql.com/mysql
To unsubscribe:    http://lists.mysql.com/[EMAIL PROTECTED]



Reply via email to