Re: NDB Cluster dump import slow
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
Subject
Views
Written By
Posted
1829
November 11, 2016 07:00AM
1059
November 11, 2016 12:06PM
Re: NDB Cluster dump import slow
1140
November 14, 2016 01:28AM
1037
November 14, 2016 12:27PM
948
February 14, 2017 09:39AM
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.