MySQL Forums
Forum List  »  MyISAM

Re: 16GB index file limit
Posted by: Andon Zlatev
Date: February 07, 2006 03:26AM

Hi,


You are right, after the "alter" the index grew to ~ 18GB, and it took ~ 15 hours. But now the autoincrement of the primary key stopped working. New inserts do not increase the autoincrement that can be seen with "show table status", and the second insert generates - duplicate primary key error....

Any idea, how to fix it.

Thanks and regards,

Andon

Options: ReplyQuote


Subject
Views
Written By
Posted
3834
February 01, 2006 03:22AM
2344
February 02, 2006 04:14AM
Re: 16GB index file limit
2275
February 07, 2006 03:26AM
2419
February 07, 2006 03:46AM
2374
February 07, 2006 07:12AM
2190
February 08, 2006 01:43PM
2547
February 09, 2006 03:22AM


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.