MySQL Forums
Forum List  »  NDB clusters

Re: NDB Cluster dump import slow
Posted by: Nils Burkhardt
Date: November 14, 2016 01:28AM

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

Options: ReplyQuote


Subject
Views
Written By
Posted
746
November 11, 2016 07:00AM
435
November 11, 2016 12:06PM
Re: NDB Cluster dump import slow
470
November 14, 2016 01:28AM
418
November 14, 2016 12:27PM
258
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.