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

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

ArbitrationTimeout

millisecondsNall
7500
10 / 4294967039 (0xFFFFFEFF)

BackupDataBufferSize

bytesNall
16M
0 / 4294967039 (0xFFFFFEFF)

BackupDataDir

pathINall
FileSystemPath
...

BackupLogBufferSize

bytesNall
16M
0 / 4294967039 (0xFFFFFEFF)

BackupMaxWriteSize

bytesNall
1M
2K / 4294967039 (0xFFFFFEFF)

BackupMemory

bytesNall
32M
0 / 4294967039 (0xFFFFFEFF)

BackupWriteSize

bytesNall
256K
2K / 4294967039 (0xFFFFFEFF)

BatchSizePerLocalScan

integerNall
256
1 / 992

DataDir

pathINall
.
...

DataMemory

bytesNall
80M
1M / 1024G

Diskless

true|false (1|0)ISall
false
true, false

ExecuteOnComputer

nameSall
[none]
...

FileSystemPath

pathIN5.0.0
DataDir
...

HeartbeatIntervalDbApi

millisecondsNall
1500
100 / 4294967039 (0xFFFFFEFF)

HeartbeatIntervalDbDb

millisecondsNall
5000
10 / 4294967039 (0xFFFFFEFF)

HostName

name or IP addressSall
localhost
...

Id

unsignedISall
[none]
1 / 48

IndexMemory

bytesNall
18M
1M / 1T

LockPagesInMainMemory

numericN5.0.36
0
0 / 2

LogLevelCheckpoint

log levelNall
0
0 / 15

LogLevelCongestion

levelrN5.0.0
0
0 / 15

LogLevelConnection

integerNall
0
0 / 15

LogLevelError

integerNall
0
0 / 15

LogLevelInfo

integerNall
0
0 / 15

LogLevelNodeRestart

integerNall
0
0 / 15

LogLevelShutdown

integerNall
0
0 / 15

LogLevelStartup

integerNall
1
0 / 15

LogLevelStatistic

integerNall
0
0 / 15

LongMessageBuffer

bytesNall
64M
512K / 4294967039 (0xFFFFFEFF)

MaxNoOfAttributes

integerNall
1000
32 / 4294967039 (0xFFFFFEFF)

MaxNoOfConcurrentIndexOperations

integerNall
8K
0 / 4294967039 (0xFFFFFEFF)

MaxNoOfConcurrentOperations

integerNall
32K
32 / 4294967039 (0xFFFFFEFF)

MaxNoOfConcurrentScans

integerNall
256
2 / 500

MaxNoOfConcurrentTransactions

integerNall
4096
32 / 4294967039 (0xFFFFFEFF)

MaxNoOfFiredTriggers

integerNall
4000
0 / 4294967039 (0xFFFFFEFF)

MaxNoOfLocalOperations

integerNall
UNDEFINED
32 / 4294967039 (0xFFFFFEFF)

MaxNoOfLocalScans

integerNall
[see text]
32 / 4294967039 (0xFFFFFEFF)

MaxNoOfOpenFiles

unsignedNall
0
20 / 4294967039 (0xFFFFFEFF)

MaxNoOfOrderedIndexes

integerNall
128
0 / 4294967039 (0xFFFFFEFF)

MaxNoOfSavedMessages

integerNall
25
0 / 4294967039 (0xFFFFFEFF)

MaxNoOfTables

integerN5.0.0
128
8 / 20320

MaxNoOfTriggers

integerNall
768
0 / 4294967039 (0xFFFFFEFF)

MaxNoOfUniqueHashIndexes

integerNall
64
0 / 4294967039 (0xFFFFFEFF)

NodeId

unsignedIS5.0.15
[none]
1 / 48

NoOfDiskPagesToDiskAfterRestartACC

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

NoOfDiskPagesToDiskAfterRestartTUP

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

NoOfDiskPagesToDiskDuringRestartACC

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

NoOfDiskPagesToDiskDuringRestartTUP

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

NoOfFragmentLogFiles

integerINall
16
3 / 4294967039 (0xFFFFFEFF)

NoOfReplicas

integerISall
2
1 / 4

RedoBuffer

bytesNall
32M
1M / 4294967039 (0xFFFFFEFF)

RestartOnErrorInsert

error codeNall
2
0 / 4

ServerPort

unsignedNall
[none]
1 / 64K

StartFailureTimeout

millisecondsNall
0
0 / 4294967039 (0xFFFFFEFF)

StartPartialTimeout

millisecondsNall
30000
0 / 4294967039 (0xFFFFFEFF)

StartPartitionedTimeout

millisecondsNall
60000
0 / 4294967039 (0xFFFFFEFF)

StopOnError

booleanNall
true
true, false

StringMemory

% or bytesSall
25
0 / 4294967039 (0xFFFFFEFF)

TimeBetweenGlobalCheckpoints

millisecondsNall
2000
20 / 32000

TimeBetweenInactiveTransactionAbortCheck

millisecondsNall
1000
1000 / 4294967039 (0xFFFFFEFF)

TimeBetweenLocalCheckpoints

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

TimeBetweenWatchDogCheck

millisecondsNall
6000
70 / 4294967039 (0xFFFFFEFF)

TransactionBufferMemory

bytesNall
1M
1K / 4294967039 (0xFFFFFEFF)

TransactionDeadlockDetectionTimeout

millisecondsNall
1200
50 / 4294967039 (0xFFFFFEFF)

TransactionInactiveTimeout

millisecondsNall
[see text]
0 / 4294967039 (0xFFFFFEFF)

UndoDataBuffer

unsignedNall
16M
1M / 4294967039 (0xFFFFFEFF)

UndoIndexBuffer

unsignedNall
2M
1M / 4294967039 (0xFFFFFEFF)

Note

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.

It is possible to add new data node groups to a running cluster online using MySQL Cluster NDB 7.0 or later (see Adding MySQL Cluster Data Nodes Online); however, we do not plan to implement this change in MySQL 5.0.