17.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 17.3.2.6, “Defining MySQL Cluster Data Nodes”.

Beginning with MySQL Cluster NDB 6.4.0, these parameters also apply to ndbmtd, which is a multi-threaded version of ndbd. For more information, see Section 17.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 17.3.3, “Overview of MySQL Cluster Configuration Parameters”.

Table 17.1 Data Node Configuration Parameters

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

Arbitration

enumerationNNDB 7.0.7
Default
Default, Disabled, WaitExternal

ArbitrationTimeout

millisecondsNNDB 7.2.0
7500
10 / 4294967039 (0xFFFFFEFF)

BackupDataBufferSize

bytesNNDB 7.0.4
16M
0 / 4294967039 (0xFFFFFEFF)

BackupDataDir

pathINall 5.1-based
FileSystemPath
...

BackupLogBufferSize

bytesNNDB 7.0.4
16M
0 / 4294967039 (0xFFFFFEFF)

BackupMaxWriteSize

bytesN5.1.32
1M
2K / 4294967039 (0xFFFFFEFF)

BackupMemory

bytesNNDB 7.0.4
32M
0 / 4294967039 (0xFFFFFEFF)

BackupReportFrequency

secondsNNDB 6.2.3
0
0 / 4294967039 (0xFFFFFEFF)

BackupWriteSize

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

BatchSizePerLocalScan

integerNNDB 7.2.1
256
1 / 992

BuildIndexThreads

numericSNDB 7.0.11
0
0 / 128

CompressedBackup

booleanNNDB 6.3.7
false
true, false

CompressedLCP

booleanNNDB 6.3.7
false
true, false

ConnectCheckIntervalDelay

stringNNDB 7.1.13
1500
0 / 4294967039 (0xFFFFFEFF)

CrashOnCorruptedTuple

booleanSNDB 7.0.28, 5.1.56-ndb-7.1.17
false
true, false

DataDir

pathINall 5.1-based
.
...

DataMemory

bytesNall 5.1-based
80M
1M / 1024G

DefaultHashMapSize

LDM threadsNNDB 7.1.27
240
0 / 3840

DictTrace

bytesN5.1.12
undefined
0 / 100

DiskCheckpointSpeed

bytesN5.1.12
10M
1M / 4294967039 (0xFFFFFEFF)

DiskCheckpointSpeedInRestart

bytesNall 5.1-based
100M
1M / 4294967039 (0xFFFFFEFF)

DiskIOThreadPool

threadsNNDB 7.1.0
2
0 / 4294967039 (0xFFFFFEFF)

Diskless

true|false (1|0)ISall 5.1-based
false
true, false

DiskPageBufferMemory

bytesN5.1.6
64M
4M / 1T

DiskSyncSize

bytesN5.1.12
4M
32K / 4294967039 (0xFFFFFEFF)

ExecuteOnComputer

nameSall 5.1-based
[none]
...

ExtraSendBufferMemory

bytesNNDB 6.4.0
0
0 / 32G

FileSystemPath

pathINall 5.1-based
DataDir
...

FileSystemPathDataFiles

filenameINNDB 6.4.3
[see text]
...

FileSystemPathDD

filenameINNDB 6.4.3
FileSystemPath
...

FileSystemPathUndoFiles

filenameINNDB 6.4.3
[see text]
...

FragmentLogFileSize

bytesINNDB 6.1.11
16M
4M / 1G

HeartbeatIntervalDbApi

millisecondsNall 5.1-based
1500
100 / 4294967039 (0xFFFFFEFF)

HeartbeatIntervalDbDb

millisecondsNNDB 7.2.0
5000
10 / 4294967039 (0xFFFFFEFF)

HeartbeatOrder

numericSNDB 7.1.5
0
0 / 65535

HostName

name or IP addressSall 5.1-based
localhost
...

Id

unsignedISall 5.1-based
[none]
1 / 48

IndexMemory

bytesNall 5.1-based
18M
1M / 1T

InitFragmentLogFiles

[see values]INNDB 6.3.19
SPARSE
SPARSE, FULL

InitialLogFileGroup

stringSNDB 6.4.3
[see text]
...

InitialNoOfOpenFiles

filesN5.1.9
27
20 / 4294967039 (0xFFFFFEFF)

InitialTablespace

stringSNDB 6.4.3
[see text]
...

IOThreadPool

threadsNNDB 6.4.0
8
0 / 4294967039 (0xFFFFFEFF)

LateAlloc

numericNNDB 6.4.0
1
0 / 1

LcpScanProgressTimeout

secondNNDB 7.1.29
60
0 / 4294967039 (0xFFFFFEFF)

LockExecuteThreadToCPU

CPU IDNNDB 6.3.4
64K
0 / 64K

LockMaintThreadsToCPU

CPU IDNNDB 6.4.0
[none]
0 / 64K

LockPagesInMainMemory

numericN5.1.15
0
0 / 2

LogLevelCheckpoint

log levelNall 5.1-based
0
0 / 15

LogLevelCongestion

levelrNall 5.1-based
0
0 / 15

LogLevelConnection

integerNall 5.1-based
0
0 / 15

LogLevelError

integerNall 5.1-based
0
0 / 15

LogLevelInfo

integerNall 5.1-based
0
0 / 15

LogLevelNodeRestart

integerNall 5.1-based
0
0 / 15

LogLevelShutdown

integerNall 5.1-based
0
0 / 15

LogLevelStartup

integerNall 5.1-based
1
0 / 15

LogLevelStatistic

integerNall 5.1-based
0
0 / 15

LongMessageBuffer

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

MaxAllocate

unsignedN5.1.20
32M
1M / 1G

MaxBufferedEpochs

epochsNNDB 6.2.14
100
0 / 100000

MaxBufferedEpochBytes

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

MaxDMLOperationsPerTransaction

operations (DML)NNDB 7.1.15
4294967295
32 / 4294967295

MaxLCPStartDelay

secondsNNDB 6.4.3
0
0 / 600

MaxNoOfAttributes

integerNall 5.1-based
1000
32 / 4294967039 (0xFFFFFEFF)

MaxNoOfConcurrentIndexOperations

integerNall 5.1-based
8K
0 / 4294967039 (0xFFFFFEFF)

MaxNoOfConcurrentOperations

integerNall 5.1-based
32K
32 / 4294967039 (0xFFFFFEFF)

MaxNoOfConcurrentScans

integerNall 5.1-based
256
2 / 500

MaxNoOfConcurrentSubOperations

unsignedNNDB 6.3.7
256
0 / 4294967039 (0xFFFFFEFF)

MaxNoOfConcurrentTransactions

integerNall 5.1-based
4096
32 / 4294967039 (0xFFFFFEFF)

MaxNoOfFiredTriggers

integerNall 5.1-based
4000
0 / 4294967039 (0xFFFFFEFF)

MaxNoOfLocalOperations

integerNall 5.1-based
UNDEFINED
32 / 4294967039 (0xFFFFFEFF)

MaxNoOfLocalScans

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

MaxNoOfOpenFiles

unsignedN5.1.16
0
20 / 4294967039 (0xFFFFFEFF)

MaxNoOfOrderedIndexes

integerNall 5.1-based
128
0 / 4294967039 (0xFFFFFEFF)

MaxNoOfSavedMessages

integerNall 5.1-based
25
0 / 4294967039 (0xFFFFFEFF)

MaxNoOfSubscribers

unsignedNNDB 6.3.7
0
0 / 4294967039 (0xFFFFFEFF)

MaxNoOfSubscriptions

unsignedNNDB 6.3.7
0
0 / 4294967039 (0xFFFFFEFF)

MaxNoOfTables

integerNall 5.1-based
128
8 / 20320

MaxNoOfTriggers

integerNall 5.1-based
768
0 / 4294967039 (0xFFFFFEFF)

MaxNoOfUniqueHashIndexes

integerNall 5.1-based
64
0 / 4294967039 (0xFFFFFEFF)

MaxParallelScansPerFragment

bytesNNDB 7.2.0
256
1 / 4294967039 (0xFFFFFEFF)

MaxStartFailRetries

unsignedNNDB 6.2.19
3
0 / 4294967039 (0xFFFFFEFF)

MemReportFrequency

unsignedN5.1.16
0
0 / 4294967039 (0xFFFFFEFF)

MinFreePct

unsignedNNDB 7.1.18
5
0 / 100

NodeGroup

 ISNDB 6.4.0
[none]
0 / 65536

NodeId

unsignedISall 5.1-based
[none]
1 / 48

NoOfDiskPagesToDiskAfterRestartACC

8K pages/100 millisecondsNall 5.1-based
20
1 / 4294967039 (0xFFFFFEFF)

NoOfDiskPagesToDiskAfterRestartTUP

8K pages/100 millisecondsNall 5.1-based
40
1 / 4294967039 (0xFFFFFEFF)

NoOfDiskPagesToDiskDuringRestartACC

8K pages/100 millisecondsNall 5.1-based
20
1 / 4294967039 (0xFFFFFEFF)

NoOfDiskPagesToDiskDuringRestartTUP

8K pages/100 millisecondsNall 5.1-based
40
1 / 4294967039 (0xFFFFFEFF)

NoOfFragmentLogFiles

integerIN5.1.0
16
3 / 4294967039 (0xFFFFFEFF)

NoOfReplicas

integerISNDB 7.0.6
2
1 / 4

Numa

booleanNNDB 7.1.9
1
...

ODirect

booleanNNDB 6.3.0
false
true, false

RealtimeScheduler

booleanNNDB 6.3.4
false
true, false

RedoBuffer

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

RedoOverCommitCounter

numericNNDB 7.1.10
3
0 / 4294967039 (0xFFFFFEFF)

RedoOverCommitLimit

secondsNNDB 7.1.10
20
0 / 4294967039 (0xFFFFFEFF)

ReservedSendBufferMemory

bytesNNDB 6.4.0
256K
0 / 4294967039 (0xFFFFFEFF)

RestartOnErrorInsert

error codeNall 5.1-based
2
0 / 4

SchedulerExecutionTimer

µsecNNDB 6.3.4
50
0 / 11000

SchedulerSpinTimer

µsecNNDB 6.3.4
0
0 / 500

ServerPort

unsignedNall 5.1-based
[none]
1 / 64K

SharedGlobalMemory

bytesN5.1.6
20M
0 / 64T

StartFailRetryDelay

unsignedNNDB 6.2.19
0
0 / 4294967039 (0xFFFFFEFF)

StartFailureTimeout

millisecondsNall 5.1-based
0
0 / 4294967039 (0xFFFFFEFF)

StartNoNodeGroupTimeout

millisecondsNNDB 7.0.24
15000
0 / 4294967039 (0xFFFFFEFF)

StartPartialTimeout

millisecondsNall 5.1-based
30000
0 / 4294967039 (0xFFFFFEFF)

StartPartitionedTimeout

millisecondsNall 5.1-based
60000
0 / 4294967039 (0xFFFFFEFF)

StartupStatusReportFrequency

secondsNNDB 6.4.0
0
0 / 4294967039 (0xFFFFFEFF)

StopOnError

booleanNall 5.1-based
true
true, false

StringMemory

% or bytesS5.1.6
5
0 / 4294967039 (0xFFFFFEFF)

TcpBind_INADDR_ANY

booleanNNDB 6.2.0
false
true, false

TimeBetweenEpochs

millisecondsNNDB 6.2.5
100
0 / 32000

TimeBetweenEpochsTimeout

millisecondsN5.1.51
0
0 / 256000

TimeBetweenGlobalCheckpoints

millisecondsNNDB 6.2.0
2000
20 / 32000

TimeBetweenInactiveTransactionAbortCheck

millisecondsNall 5.1-based
1000
1000 / 4294967039 (0xFFFFFEFF)

TimeBetweenLocalCheckpoints

number of 4-byte words, as a base-2 logarithmNall 5.1-based
20
0 / 31

TimeBetweenWatchDogCheck

millisecondsNall 5.1-based
6000
70 / 4294967039 (0xFFFFFEFF)

TimeBetweenWatchDogCheckInitial

millisecondsN5.1.20
6000
70 / 4294967039 (0xFFFFFEFF)

TotalSendBufferMemory

bytesNNDB 6.4.0
256K
0 / 4294967039 (0xFFFFFEFF)

TransactionBufferMemory

bytesNall 5.1-based
1M
1K / 4294967039 (0xFFFFFEFF)

TransactionDeadlockDetectionTimeout

millisecondsNall 5.1-based
1200
50 / 4294967039 (0xFFFFFEFF)

TransactionInactiveTimeout

millisecondsNall 5.1-based
[see text]
0 / 4294967039 (0xFFFFFEFF)

TwoPassInitialNodeRestartCopy

booleanNNDB 7.1.11
false
true, false

UndoDataBuffer

unsignedNall 5.1-based
16M
1M / 4294967039 (0xFFFFFEFF)

UndoIndexBuffer

unsignedNall 5.1-based
2M
1M / 4294967039 (0xFFFFFEFF)

Table 17.2 Multi-Threaded Data Node Configuration Parameters

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

MaxNoOfExecutionThreads

integerNNDB 7.0.4
2
2 / 8

ThreadConfig

stringNNDB 7.1.17
''
...

Note

Prior to MySQL Cluster NDB 7.0, to add new data nodes to a MySQL Cluster, it is necessary to shut down the cluster completely, update the config.ini file, and then restart the cluster, starting all data node processes using the --initial option—that is, you must perform a system restart.

Beginning in MySQL Cluster NDB 7.0, it is possible to add new data node groups to a running cluster online. For more information, see Section 17.5.13, “Adding MySQL Cluster Data Nodes Online”.