MySQL Forums
Forum List  »  NDB clusters

Re: Unable to convert large table to NDB: lock wait timeout
Posted by: Zhihong He
Date: January 06, 2014 08:43AM

Hi,

As you mentioned, your memory is 8G, and the table you are updating is 4G. In cluster, when you use ALTER TABLE, you need double space of the table, as the original table will be kept in the database till it is ALTER/UPDATE completely. So you need more than 8G to finish this ALTER action. And in this case, I think you can do this in two ways:
1. Create a new empty NDB table, and partly move your InnoDB table in the new table. After part of the table moved in the NDB table, the moved part in the old table needs to be deleted use DELETE and OPTIMIZE.
2. Mysqldump the innodb and change the dumped file by changing the ENGINE from INNODB to NDB. And then import the dumped file to the new NDB database.

Options: ReplyQuote


Subject
Views
Written By
Posted
Re: Unable to convert large table to NDB: lock wait timeout
1244
January 06, 2014 08:43AM


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.