Hi all,
I'm trying to set up a cluster and getting the 410 REDO logs overloaded message. I've
tried various things, and seems like I'm not getting anywhere.
I'm trying to load in a dump of approx. 2 GB of data to a cluster with disk storage.
I've scoured the lists and the available information on the internet, and I'm sure I'm
missing something here. My restore only gets ~200 lines before it dumps out with the
error.
I'm getting panicked here because I have a drop-dead date of mid next week to get this
loaded up.
The configuration is as follows:
NDB 7.0.8a
2 data nodes, 2 sql nodes running on the same machines
6 GB of RAM on the servers.
config.ini is as follows:
[ndbd default]
NoOfReplicas=2 # Number of replicas
DataMemory=4096M # How much memory to allocate for data storage
IndexMemory=1024M # How much memory to allocate for index storage
MaxNoOfConcurrentTransactions = 4096
MaxNoOfConcurrentOperations = 32768
MaxNoOfLocalOperations = 36044
MaxNoOfTables = 20320
MaxNoOfOrderedIndexes = 40000
MaxNoOfUniqueHashIndexes = 28000
MaxNoOfAttributes = 80000
MaxNoOfTriggers = 200000
TimeBetweenLocalCheckpoints=6
NoOfFragmentLogFiles=384
RedoBuffer=256M
DiskCheckpointSpeed=256M
NoOfDiskPagesToDiskAfterRestartTUP=180
Thanks in advance for your assistance.
-Doug
