MySQL Forums
Forum List  »  Performance

Re: database crashes on ALTER TABLE
Posted by: Rick James
Date: July 30, 2013 09:44PM

You did not say, but I guess this is an InnoDB table? SHOW CREATE TABLE might be handy.

You are adding 104 columns to a table? Ugh. Suggest you avoid the ALTER altogether and simply create another table with 105 columns -- the ID of your current table, plus the 104 new fields. Then JOIN when needed.

Probably the crash came from running out of disk space during the copy of the table. (Doing a second table would not have that problem.)

> 32-bit MySQL 5.6 database

Geez. I'm surprised that you can get that new version on that old an architecture.

Options: ReplyQuote


Subject
Views
Written By
Posted
1558
July 29, 2013 01:24PM
Re: database crashes on ALTER TABLE
763
July 30, 2013 09:44PM


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.