Re: NDB Cluster dump import slow

[Nils Burkhardt]

Hi,
I am just running a normal mysqldump import (mysql -u -p dbname < dmpfile.sql). Not using ndb_restore. Please see below our config.ini file. All other parameters have the default values. The problem is with all tables across the board.

config.ini

[ndbd default]
NoOfReplicas=2
DataMemory=150000M
IndexMemory=15000M
MaxNoOfConcurrentOperations= 2000000
MaxNoOfLocalOperations= 2200000
TimeBetweenWatchDogCheck= 30000
TransactionDeadlockDetectionTimeout=1000000

MaxNoOfTables=4096
MaxNoOfOrderedIndexes=2048
MaxNoOfUniqueHashIndexes=2048
MaxNoOfAttributes=20000
MaxNoOfTriggers=10000
MaxBufferedEpochs=4000
FragmentLogFileSize=256M
NoOfFragmentLogFiles=48
RedoBuffer=256M

UndoDataBuffer=1024M
UndoIndexBuffer=128M

LockPagesInMainMemory=1

ODirect=1

MaxDiskWriteSpeed=250M

NoOfFragmentLogParts=4
MaxNoOfExecutionThreads=8