On Jun 18, 2004, at 5:31 PM, Scott Haneda wrote:
on 06/18/2004 05:16 PM, Kevin Brock at [EMAIL PROTECTED] wrote:
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.
While I do not know why, I would suggest you simply drop the PK and recreate
it, this should be a whole lot faster than the alter.
Thanks, I'll give it a try next time the problem shows up.
My main worry is that the AUTO_INCREMENT problem is merely a symptom of a more serious problem with the table. I've got a couple of potential band-aids, but I want to find out how it got hurt so we can avoid it in the future...
Kevin
-- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe: http://lists.mysql.com/[EMAIL PROTECTED]
