5.0.19 cluster temp error "REDO log files overloaded"

[Xing Li]

ERROR 1297 (HY000): Got temporary error 410 'REDO log files overloaded, consult online manual (decrease TimeBetweenLocalCheckpoints, and|or incre' from ndbcluster

I get the above error whenver I tried to alter table engine=ndbcluster on several tables of over 1 millions rows and about 350MB in myisam.

I'm trying to test mysql cluste operation with the below config with 4 data nodes. There is plenty of memory and I upped the redobuffer in the config.

Not sure what to change for TimeBetweenLocalCheckpoints to fix the above problem without random trial and error. Any help is appreciated.

[NDBD DEFAULT]
NoOfReplicas=2 # Number of replicas
DataMemory=26000M # How much memory to allocate for data storage
IndexMemory=4000M # How much memory to allocate for index storage
# For DataMemory and IndexMemory, we have used the
# default values. Since the "world" database takes up
# only about 500KB, this should be more than enough for
# this example Cluster setup.
LockPagesInMainMemory=1
RedoBuffer=64M



Edited 1 time(s). Last edit at 03/27/2006 02:17AM by Xing Li.