MySQL Forums
Forum List  »  NDB clusters

checkpointing causing problems doing an initial data load
Posted by: richard horan
Date: April 11, 2006 01:44PM

I am trying to load 5M rows (each row around 140 bytes) using the load command. around 1.5 million records loaded i get an error with redo logs are overloaded.

Is there a way to turn off checkpointing during this load operation? if not what do i need to look at in my config to get this load through?

## ndbd processes on all nodes
[NDBD DEFAULT]
NoOfReplicas=1
DataMemory=1G
IndexMemory=1G
NoOfFragmentLogFiles=16
MaxNoOfConcurrentTransactions = 500
MaxNoOfConcurrentOperations = 50000
MaxNoOfConcurrentIndexOperations = 32768
TimeBetweenLocalCheckpoints=25
TimeBetweenGlobalCheckpoints = 5000
NoOfDiskPagesToDiskAfterRestartTUP = 10
NoOfDiskPagesToDiskAfterRestartACC = 5

Options: ReplyQuote


Subject
Views
Written By
Posted
checkpointing causing problems doing an initial data load
1855
April 11, 2006 01:44PM


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.