18.3.3.1 MySQL Cluster Data Node Configuration Parameters

The summary table in this section provides information about parameters used in the [ndbd] or [ndbd default] sections of a config.ini file for configuring MySQL Cluster data nodes. For detailed descriptions and other additional information about each of these parameters, see Section 18.3.2.6, “Defining MySQL Cluster Data Nodes”.

These parameters also apply to ndbmtd, the multi-threaded version of ndbd. For more information, see Section 18.4.3, “ndbmtd — The MySQL Cluster Data Node Daemon (Multi-Threaded)”.

Restart types.  Changes in MySQL Cluster configuration parameters do not take effect until the cluster is restarted. The type of restart required to change a given parameter is indicated in the summary table as follows:

For more information about restart types, see Section 18.3.3, “Overview of MySQL Cluster Configuration Parameters”.

MySQL Cluster NDB 7.2 supports the addition of new data node groups online, to a running cluster. For more information, see Section 18.5.13, “Adding MySQL Cluster Data Nodes Online”.

Table 18.1 Data Node Configuration Parameters

Parameter NameType or UnitsRestart TypeIn Version ... (and later)
Default Value
Minimum/Maximum or Permitted Values

Arbitration

enumerationNNDB 7.2.0
Default
Default, Disabled, WaitExternal

ArbitrationTimeout

millisecondsNNDB 7.2.0
7500
10 / 4294967039 (0xFFFFFEFF)

BackupDataBufferSize

bytesNNDB 7.2.0
16M
0 / 4294967039 (0xFFFFFEFF)

BackupDataDir

pathINNDB 7.2.0
FileSystemPath
...

BackupLogBufferSize

bytesNNDB 7.2.0
16M
0 / 4294967039 (0xFFFFFEFF)

BackupMaxWriteSize

bytesNNDB 7.2.1
1M
2K / 4294967039 (0xFFFFFEFF)

BackupMemory

bytesNNDB 7.2.0
32M
0 / 4294967039 (0xFFFFFEFF)

BackupReportFrequency

secondsNNDB 7.2.0
0
0 / 4294967039 (0xFFFFFEFF)

BackupWriteSize

bytesNNDB 7.2.0
256K
2K / 4294967039 (0xFFFFFEFF)

BatchSizePerLocalScan

integerNNDB 7.2.1
256
1 / 992

BuildIndexThreads

numericSNDB 7.2.0
0
0 / 128

CompressedBackup

booleanNNDB 7.2.0
false
true, false

CompressedLCP

booleanNNDB 7.2.0
false
true, false

ConnectCheckIntervalDelay

stringNNDB 7.2.1
0
0 / 4294967039 (0xFFFFFEFF)

CrashOnCorruptedTuple

booleanSNDB 7.2.1
true
true, false

DataDir

pathINNDB 7.2.0
.
...

DataMemory

bytesNNDB 7.2.0
80M
1M / 1024G

DefaultHashMapSize

LDM threadsNNDB 7.2.11
3840
0 / 3840

DictTrace

bytesNNDB 7.2.0
undefined
0 / 100

DiskCheckpointSpeed

bytesNNDB 7.2.0
10M
1M / 4294967039 (0xFFFFFEFF)

DiskCheckpointSpeedInRestart

bytesNNDB 7.2.0
100M
1M / 4294967039 (0xFFFFFEFF)

DiskIOThreadPool

threadsNNDB 7.2.0
2
0 / 4294967039 (0xFFFFFEFF)

Diskless

true|false (1|0)ISNDB 7.2.0
false
true, false

DiskPageBufferMemory

bytesNNDB 7.2.0
64M
4M / 1T

DiskSyncSize

bytesNNDB 7.2.0
4M
32K / 4294967039 (0xFFFFFEFF)

ExecuteOnComputer

nameSNDB 7.2.0
[none]
...

ExtraSendBufferMemory

bytesNNDB 7.2.0
0
0 / 32G

FileSystemPath

pathINNDB 7.2.0
DataDir
...

FileSystemPathDataFiles

filenameINNDB 7.2.0
[see text]
...

FileSystemPathDD

filenameINNDB 7.2.0
FileSystemPath
...

FileSystemPathUndoFiles

filenameINNDB 7.2.0
[see text]
...

FragmentLogFileSize

bytesINNDB 7.2.0
16M
4M / 1G

HeartbeatIntervalDbApi

millisecondsNNDB 7.2.0
1500
100 / 4294967039 (0xFFFFFEFF)

HeartbeatIntervalDbDb

millisecondsNNDB 7.2.0
5000
10 / 4294967039 (0xFFFFFEFF)

HeartbeatOrder

numericSNDB 7.2.0
0
0 / 65535

HostName

name or IP addressNNDB 7.2.0
localhost
...

Id

unsignedISNDB 7.2.0
[none]
1 / 48

IndexMemory

bytesNNDB 7.2.0
18M
1M / 1T

IndexStatAutoCreate

booleanSNDB 7.2.1
false
false, true

IndexStatAutoUpdate

booleanSNDB 7.2.1
false
false, true

IndexStatSaveScale

percentageINNDB 7.2.1
100
0 / 4294967039 (0xFFFFFEFF)

IndexStatSaveSize

bytesINNDB 7.2.1
32768
0 / 4294967039 (0xFFFFFEFF)

IndexStatTriggerPct

percentageINNDB 7.2.1
100
0 / 4294967039 (0xFFFFFEFF)

IndexStatTriggerScale

percentageINNDB 7.2.1
100
0 / 4294967039 (0xFFFFFEFF)

IndexStatUpdateDelay

secondsINNDB 7.2.1
60
0 / 4294967039 (0xFFFFFEFF)

InitFragmentLogFiles

[see values]INNDB 7.2.0
SPARSE
SPARSE, FULL

InitialLogFileGroup

stringSNDB 7.2.0
[see text]
...

InitialNoOfOpenFiles

filesNNDB 7.2.0
27
20 / 4294967039 (0xFFFFFEFF)

InitialTablespace

stringSNDB 7.2.0
[see text]
...

LateAlloc

numericNNDB 7.2.0
1
0 / 1

LcpScanProgressTimeout

secondNNDB 7.2.14
60
0 / 4294967039 (0xFFFFFEFF)

LockExecuteThreadToCPU

CPU IDNNDB 7.2.0
64K
0 / 64K

LockMaintThreadsToCPU

CPU IDNNDB 7.2.0
[none]
0 / 64K

LockPagesInMainMemory

numericNNDB 7.2.0
0
0 / 2

LogLevelCheckpoint

log levelNNDB 7.2.0
0
0 / 15

LogLevelCongestion

levelrNNDB 7.2.0
0
0 / 15

LogLevelConnection

integerNNDB 7.2.0
0
0 / 15

LogLevelError

integerNNDB 7.2.0
0
0 / 15

LogLevelInfo

integerNNDB 7.2.0
0
0 / 15

LogLevelNodeRestart

integerNNDB 7.2.0
0
0 / 15

LogLevelShutdown

integerNNDB 7.2.0
0
0 / 15

LogLevelStartup

integerNNDB 7.2.0
1
0 / 15

LogLevelStatistic

integerNNDB 7.2.0
0
0 / 15

LongMessageBuffer

bytesNNDB 7.2.16
64M
512K / 4294967039 (0xFFFFFEFF)

MaxAllocate

unsignedNNDB 7.2.0
32M
1M / 1G

MaxBufferedEpochs

epochsNNDB 7.2.0
100
0 / 100000

MaxBufferedEpochBytes

bytesNNDB 7.2.13
26214400
26214400 (0x01900000) / 4294967039 (0xFFFFFEFF)

MaxDMLOperationsPerTransaction

operations (DML)NNDB 7.2.0
4294967295
32 / 4294967295

MaxLCPStartDelay

secondsNNDB 7.2.0
0
0 / 600

MaxNoOfAttributes

integerNNDB 7.2.0
1000
32 / 4294967039 (0xFFFFFEFF)

MaxNoOfConcurrentIndexOperations

integerNNDB 7.2.0
8K
0 / 4294967039 (0xFFFFFEFF)

MaxNoOfConcurrentOperations

integerNNDB 7.2.0
32K
32 / 4294967039 (0xFFFFFEFF)

MaxNoOfConcurrentScans

integerNNDB 7.2.0
256
2 / 500

MaxNoOfConcurrentSubOperations

unsignedNNDB 7.2.0
256
0 / 4294967039 (0xFFFFFEFF)

MaxNoOfConcurrentTransactions

integerNNDB 7.2.0
4096
32 / 4294967039 (0xFFFFFEFF)

MaxNoOfFiredTriggers

integerNNDB 7.2.0
4000
0 / 4294967039 (0xFFFFFEFF)

MaxNoOfLocalOperations

integerNNDB 7.2.0
UNDEFINED
32 / 4294967039 (0xFFFFFEFF)

MaxNoOfLocalScans

integerNNDB 7.2.0
[see text]
32 / 4294967039 (0xFFFFFEFF)

MaxNoOfOpenFiles

unsignedNNDB 7.2.0
0
20 / 4294967039 (0xFFFFFEFF)

MaxNoOfOrderedIndexes

integerNNDB 7.2.0
128
0 / 4294967039 (0xFFFFFEFF)

MaxNoOfSavedMessages

integerNNDB 7.2.0
25
0 / 4294967039 (0xFFFFFEFF)

MaxNoOfSubscribers

unsignedNNDB 7.2.0
0
0 / 4294967039 (0xFFFFFEFF)

MaxNoOfSubscriptions

unsignedNNDB 7.2.0
0
0 / 4294967039 (0xFFFFFEFF)

MaxNoOfTables

integerNNDB 7.2.0
128
8 / 20320

MaxNoOfTriggers

integerNNDB 7.2.0
768
0 / 4294967039 (0xFFFFFEFF)

MaxNoOfUniqueHashIndexes

integerNNDB 7.2.0
64
0 / 4294967039 (0xFFFFFEFF)

MaxParallelScansPerFragment

bytesNNDB 7.2.0
256
1 / 4294967039 (0xFFFFFEFF)

MaxStartFailRetries

unsignedNNDB 7.2.0
3
0 / 4294967039 (0xFFFFFEFF)

MemReportFrequency

unsignedNNDB 7.2.0
0
0 / 4294967039 (0xFFFFFEFF)

MinFreePct

unsignedNNDB 7.2.3
5
0 / 100

NodeGroup

 ISNDB 7.2.0
[none]
0 / 65536

NodeId

unsignedISNDB 7.2.0
[none]
1 / 48

NoOfFragmentLogFiles

integerINNDB 7.2.0
16
3 / 4294967039 (0xFFFFFEFF)

NoOfReplicas

integerISNDB 7.2.0
2
1 / 4

Numa

booleanNNDB 7.2.0
1
...

ODirect

booleanNNDB 7.2.0
false
true, false

RealtimeScheduler

booleanNNDB 7.2.0
false
true, false

RedoBuffer

bytesNNDB 7.2.0
32M
1M / 4294967039 (0xFFFFFEFF)

RedoOverCommitCounter

numericNNDB 7.2.0
3
0 / 4294967039 (0xFFFFFEFF)

RedoOverCommitLimit

secondsNNDB 7.2.0
20
0 / 4294967039 (0xFFFFFEFF)

ReservedSendBufferMemory

bytesNNDB 7.2.0
256K
0 / 4294967039 (0xFFFFFEFF)

RestartOnErrorInsert

error codeNNDB 7.2.0
2
0 / 4

SchedulerExecutionTimer

µsecNNDB 7.2.0
50
0 / 11000

SchedulerSpinTimer

µsecNNDB 7.2.0
0
0 / 500

ServerPort

unsignedNNDB 7.2.0
[none]
1 / 64K

SharedGlobalMemory

bytesNNDB 7.2.0
128M
0 / 64T

StartFailRetryDelay

unsignedNNDB 7.2.0
0
0 / 4294967039 (0xFFFFFEFF)

StartFailureTimeout

millisecondsNNDB 7.2.0
0
0 / 4294967039 (0xFFFFFEFF)

StartNoNodeGroupTimeout

millisecondsNNDB 7.2.0
15000
0 / 4294967039 (0xFFFFFEFF)

StartPartialTimeout

millisecondsNNDB 7.2.0
30000
0 / 4294967039 (0xFFFFFEFF)

StartPartitionedTimeout

millisecondsNNDB 7.2.0
60000
0 / 4294967039 (0xFFFFFEFF)

StartupStatusReportFrequency

secondsNNDB 7.2.0
0
0 / 4294967039 (0xFFFFFEFF)

StopOnError

booleanNNDB 7.2.0
1
0, 1

StringMemory

% or bytesSNDB 7.2.1
25
0 / 4294967039 (0xFFFFFEFF)

TcpBind_INADDR_ANY

booleanNNDB 7.2.0
false
true, false

TimeBetweenEpochs

millisecondsNNDB 7.2.0
100
0 / 32000

TimeBetweenEpochsTimeout

millisecondsNNDB 7.2.0
0
0 / 256000

TimeBetweenGlobalCheckpoints

millisecondsNNDB 7.2.0
2000
20 / 32000

TimeBetweenInactiveTransactionAbortCheck

millisecondsNNDB 7.2.0
1000
1000 / 4294967039 (0xFFFFFEFF)

TimeBetweenLocalCheckpoints

number of 4-byte words, as a base-2 logarithmNNDB 7.2.0
20
0 / 31

TimeBetweenWatchDogCheck

millisecondsNNDB 7.2.0
6000
70 / 4294967039 (0xFFFFFEFF)

TimeBetweenWatchDogCheckInitial

millisecondsNNDB 7.2.0
6000
70 / 4294967039 (0xFFFFFEFF)

TotalSendBufferMemory

bytesNNDB 7.2.0
256K
0 / 4294967039 (0xFFFFFEFF)

TransactionBufferMemory

bytesNNDB 7.2.0
1M
1K / 4294967039 (0xFFFFFEFF)

TransactionDeadlockDetectionTimeout

millisecondsNNDB 7.2.0
1200
50 / 4294967039 (0xFFFFFEFF)

TransactionInactiveTimeout

millisecondsNNDB 7.2.0
[see text]
0 / 4294967039 (0xFFFFFEFF)

TwoPassInitialNodeRestartCopy

booleanNNDB 7.2.0
false
true, false

UndoDataBuffer

unsignedNNDB 7.2.0
16M
1M / 4294967039 (0xFFFFFEFF)

UndoIndexBuffer

unsignedNNDB 7.2.0
2M
1M / 4294967039 (0xFFFFFEFF)

Table 18.2 Multi-Threaded Data Node Configuration Parameters

Parameter NameType or UnitsRestart TypeIn Version ... (and later)
Default Value
Minimum/Maximum or Permitted Values

MaxNoOfExecutionThreads

integerISNDB 7.2.5
2
2 / 36

NoOfFragmentLogParts

numericINNDB 7.2.5
4
4, 8, 12, 16

ThreadConfig

stringISNDB 7.2.3
''
...