MySQL Forums :: NDB clusters :: NDB Cluster dump import slow


Advanced Search

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
NDB Cluster dump import slow 527 Nils Burkhardt 11/11/2016 07:00AM
Re: NDB Cluster dump import slow 297 David Ashman 11/11/2016 12:06PM
Re: NDB Cluster dump import slow 317 Nils Burkhardt 11/14/2016 01:28AM
Re: NDB Cluster dump import slow 273 David Ashman 11/14/2016 12:27PM
Re: NDB Cluster dump import slow 100 Thomas Waibel 02/14/2017 09:39AM


Sorry, only registered users may post in this forum.

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.