MySQL Forums
Forum List  »  MyISAM

Re: 16GB index file limit
Posted by: Ingo Strüwing
Date: February 07, 2006 03:46AM

Hi,

this should not have happened if you did just change MAX_ROWS.

Can you please look at SHOW CREATE TABLE ... if the auto_increment column is still listed as it should be?

If it is ok, please look at SHOW TABLE STATUS. It should tell you what the current auto_increment value is. You can fix this number with SET INSERT_ID=number. With the next insert, the auto_increment value will jump to this number.

Regards

Ingo Strüwing, Senior Software Developer - Storage Engines
MySQL AB, www.mysql.com

Options: ReplyQuote


Subject
Views
Written By
Posted
3834
February 01, 2006 03:22AM
2343
February 02, 2006 04:14AM
2275
February 07, 2006 03:26AM
Re: 16GB index file limit
2418
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.