Hi, All
We have got the following error when a large amount of data loading by
LOAD DATA
to MySQL Cluster are performed.
LOAD DATA LOCAL INFILE "/tmp/address.data" INTO TABLE address FIELDS
TERMINATED BY "," OPTIONALLY ENCLOSED BY """";
:
ERROR 1297 (HY000) at line 20: Got temporary error 410 'REDO log files
overloaded, consult online manual (decrease
TimeBetweenLocalCheckpoints, and|or incre' from NDBCLUSTER
This means that following two parameters are needed to be tuned.
DiskCheckpointSpeed
NoOfFragmentLogFiles
But the large value of NoOfFragmentLogFiles needs a large amount of disk
space
and the long duration of DiskCheckpointSpeed causes the delay of
performance.
I have a question.
Do you know the way of bulk data loading to MySQL Cluster?
I intend that the bulk data loading performed with non-transactional
and it does not writes REDO and/or UNDO log to the disk.
Best Regards,
Y. Nakayama
1 message in com.mysql.lists.clustertemporary error 410 'REDO log files o...