MySQL Forums
Forum List  »  NDB clusters

REDO log files overloaded
Posted by: Daniel Blumenthal
Date: August 22, 2006 02:34PM

I've been putting together a cluster using 5.0.24, and when I try to bring over larger tables from my old database using "alter table", I get the following error:

mysql> alter table foo engine=ndbcluster;
ERROR 1297 (HY000): Got temporary error 410 'REDO log files overloaded, consult online manual (decrease TimeBetweenLocalCheckpoints, and|or incre' from ndbcluster

When I try to either decrease TimeBetweenLocalCheckpoints or increase NoOfFragmentLogFiles I get this error:

mysql> alter table foo engine=ndbcluster;
ERROR 1296 (HY000): Got error 1 'Unknown error code' from ndbcluster

I have two storage nodes (Opterons, 6GB RAM), and one management node (dual Xeon, 2GB). My SQL nodes are other machines.

Any ideas on how I can either fix this problem, or avoid it by bringing tables over another way?

Daniel

Options: ReplyQuote


Subject
Views
Written By
Posted
REDO log files overloaded
5660
August 22, 2006 02:34PM
2373
August 22, 2006 03:03PM


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.