MySQL Forums
Forum List  »  NDB clusters

Alter NDB Table
Posted by: Brian Abreu
Date: August 17, 2006 10:36AM

I am trying to alter a NDB table in mysql 5.1.11 in our testing environment. The table contains about 2GB of data; there is 3GB for data memory. I understand that in order to alter a table it must first be copied into a temporary table. When I attempt to add a column to the table, i get the error:

ERROR 1114 (HY000): The table '#sql-4530_57' is full.

I am guessing there is no way to add/remove columns without creating a temporary copy of the table. This is a problem because this test table is a small subset of a much larger production table (roughly 10GB) from another database. We are looking to migrate to mysql cluster, however, we need an efficient way of altering tables online (IE, the table cannot be write locked for several minuets while data is coppied). Does anyone have any suggestions/workarounds?

Options: ReplyQuote


Subject
Views
Written By
Posted
Alter NDB Table
1593
August 17, 2006 10:36AM
1023
August 23, 2006 09:10PM


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.