Documentation Home
MySQL Cluster Manager 1.2 User Manual
Download this Manual

MySQL Cluster Manager 1.2 User Manual  /  Attribute Summary Tables  /  Data Node Configuration Parameters

B.2 Data Node Configuration Parameters

Table B.2 Data Node Configuration Parameters

Parameter Name Type or Units Restart Type In Version ... (and later)
Default Value
Minimum/Maximum or Permitted Values

Arbitration

enumeration N NDB 7.3.0
Default
Default, Disabled, WaitExternal

ArbitrationTimeout

milliseconds N NDB 7.3.0
7500
10 / 4294967039 (0xFFFFFEFF)

BackupDataBufferSize

bytes N NDB 7.4.11
16M
512K / 4294967039 (0xFFFFFEFF)

BackupDataDir

path IN NDB 7.3.0
FileSystemPath
...

BackupDiskWriteSpeedPct

percent N NDB 7.4.8
50
0 / 90

BackupLogBufferSize

bytes N NDB 7.4.8
16M
2M / 4294967039 (0xFFFFFEFF)

BackupMaxWriteSize

bytes N NDB 7.4.8
1M
256K / 4294967039 (0xFFFFFEFF)

BackupMemory

bytes N NDB 7.3.0
32M
0 / 4294967039 (0xFFFFFEFF)

BackupReportFrequency

seconds N NDB 7.3.0
0
0 / 4294967039 (0xFFFFFEFF)

BackupWriteSize

bytes N NDB 7.4.8
256K
32K / 4294967039 (0xFFFFFEFF)

BatchSizePerLocalScan

integer N NDB 7.3.0
256
1 / 992

BuildIndexThreads

numeric S NDB 7.3.0
0
0 / 128

CompressedBackup

boolean N NDB 7.3.0
false
true, false

CompressedLCP

boolean N NDB 7.3.0
false
true, false

ConnectCheckIntervalDelay

milliseconds N NDB 7.3.0
0
0 / 4294967039 (0xFFFFFEFF)

CrashOnCorruptedTuple

boolean S NDB 7.3.0
true
true, false

DataDir

path IN NDB 7.3.0
.
...

DataMemory

bytes N NDB 7.3.0
80M
1M / 1024G

DefaultHashMapSize

LDM threads N NDB 7.3.0
3840
0 / 3840

DictTrace

bytes N NDB 7.3.0
undefined
0 / 100

DiskCheckpointSpeed

bytes N NDB 7.3.0
10M
1M / 4294967039 (0xFFFFFEFF)

DiskCheckpointSpeedInRestart

bytes N NDB 7.3.0
100M
1M / 4294967039 (0xFFFFFEFF)

DiskIOThreadPool

threads N NDB 7.3.0
2
0 / 4294967039 (0xFFFFFEFF)

Diskless

true|false (1|0) IS NDB 7.3.0
false
true, false

DiskPageBufferEntries

32K pages N NDB 7.4.3
10
1 / 1000

DiskPageBufferMemory

bytes N NDB 7.3.0
64M
4M / 1T

DiskSyncSize

bytes N NDB 7.3.0
4M
32K / 4294967039 (0xFFFFFEFF)

ExecuteOnComputer

name S NDB 7.3.0
[none]
...

ExtraSendBufferMemory

bytes N NDB 7.3.0
0
0 / 32G

FileSystemPath

path IN NDB 7.3.0
DataDir
...

FileSystemPathDataFiles

filename IN NDB 7.3.0
[see text]
...

FileSystemPathDD

filename IN NDB 7.3.0
FileSystemPath
...

FileSystemPathUndoFiles

filename IN NDB 7.3.0
[see text]
...

FragmentLogFileSize

bytes IN NDB 7.3.0
16M
4M / 1G

HeartbeatIntervalDbApi

milliseconds N NDB 7.3.0
1500
100 / 4294967039 (0xFFFFFEFF)

HeartbeatIntervalDbDb

milliseconds N NDB 7.3.0
5000
10 / 4294967039 (0xFFFFFEFF)

HeartbeatOrder

numeric S NDB 7.3.0
0
0 / 65535

HostName

name or IP address N NDB 7.3.0
localhost
...

Id

unsigned IS NDB 7.3.0
[none]
1 / 48

IndexMemory

bytes N NDB 7.3.0
18M
1M / 1T

IndexStatAutoCreate

boolean S NDB 7.3.0
false
false, true

IndexStatAutoUpdate

boolean S NDB 7.3.0
false
false, true

IndexStatSaveScale

percentage IN NDB 7.3.0
100
0 / 4294967039 (0xFFFFFEFF)

IndexStatSaveSize

bytes IN NDB 7.3.0
32768
0 / 4294967039 (0xFFFFFEFF)

IndexStatTriggerPct

percentage IN NDB 7.3.0
100
0 / 4294967039 (0xFFFFFEFF)

IndexStatTriggerScale

percentage IN NDB 7.3.0
100
0 / 4294967039 (0xFFFFFEFF)

IndexStatUpdateDelay

seconds IN NDB 7.3.0
60
0 / 4294967039 (0xFFFFFEFF)

InitFragmentLogFiles

[see values] IN NDB 7.3.0
SPARSE
SPARSE, FULL

InitialLogFileGroup

string S NDB 7.3.0
[see text]
...

InitialNoOfOpenFiles

files N NDB 7.3.0
27
20 / 4294967039 (0xFFFFFEFF)

InitialTablespace

string S NDB 7.3.0
[see text]
...

LateAlloc

numeric N NDB 7.3.0
1
0 / 1

LcpScanProgressTimeout

second N NDB 7.3.3
60
0 / 4294967039 (0xFFFFFEFF)

LockExecuteThreadToCPU

CPU ID N NDB 7.3.0
64K
0 / 64K

LockMaintThreadsToCPU

CPU ID N NDB 7.3.0
[none]
0 / 64K

LockPagesInMainMemory

numeric N NDB 7.3.0
0
0 / 2

LogLevelCheckpoint

log level N NDB 7.3.0
0
0 / 15

LogLevelCongestion

levelr N NDB 7.3.0
0
0 / 15

LogLevelConnection

integer N NDB 7.3.0
0
0 / 15

LogLevelError

integer N NDB 7.3.0
0
0 / 15

LogLevelInfo

integer N NDB 7.3.0
0
0 / 15

LogLevelNodeRestart

integer N NDB 7.3.0
0
0 / 15

LogLevelShutdown

integer N NDB 7.3.0
0
0 / 15

LogLevelStartup

integer N NDB 7.3.0
1
0 / 15

LogLevelStatistic

integer N NDB 7.3.0
0
0 / 15

LongMessageBuffer

bytes N NDB 7.3.5
64M
512K / 4294967039 (0xFFFFFEFF)

MaxAllocate

unsigned N NDB 7.3.0
32M
1M / 1G

MaxBufferedEpochs

epochs N NDB 7.3.0
100
0 / 100000

MaxBufferedEpochBytes

bytes N NDB 7.3.0
26214400
26214400 (0x01900000) / 4294967039 (0xFFFFFEFF)

MaxDiskWriteSpeed

numeric S NDB 7.4.1
20M
1M / 1024G

MaxDiskWriteSpeedOtherNodeRestart

numeric S NDB 7.4.1
50M
1M / 1024G

MaxDiskWriteSpeedOwnRestart

numeric S NDB 7.4.1
200M
1M / 1024G

MaxDMLOperationsPerTransaction

operations (DML) N NDB 7.3.0
4294967295
32 / 4294967295

MaxLCPStartDelay

seconds N NDB 7.3.0
0
0 / 600

MaxNoOfAttributes

integer N NDB 7.3.0
1000
32 / 4294967039 (0xFFFFFEFF)

MaxNoOfConcurrentIndexOperations

integer N NDB 7.3.0
8K
0 / 4294967039 (0xFFFFFEFF)

MaxNoOfConcurrentOperations

integer N NDB 7.3.0
32K
32 / 4294967039 (0xFFFFFEFF)

MaxNoOfConcurrentScans

integer N NDB 7.3.0
256
2 / 500

MaxNoOfConcurrentSubOperations

unsigned N NDB 7.3.0
256
0 / 4294967039 (0xFFFFFEFF)

MaxNoOfConcurrentTransactions

integer N NDB 7.3.0
4096
32 / 4294967039 (0xFFFFFEFF)

MaxNoOfFiredTriggers

integer N NDB 7.3.0
4000
0 / 4294967039 (0xFFFFFEFF)

MaxNoOfLocalOperations

integer N NDB 7.3.0
UNDEFINED
32 / 4294967039 (0xFFFFFEFF)

MaxNoOfLocalScans

integer N NDB 7.3.0
[see text]
32 / 4294967039 (0xFFFFFEFF)

MaxNoOfOpenFiles

unsigned N NDB 7.3.0
0
20 / 4294967039 (0xFFFFFEFF)

MaxNoOfOrderedIndexes

integer N NDB 7.3.0
128
0 / 4294967039 (0xFFFFFEFF)

MaxNoOfSavedMessages

integer N NDB 7.3.0
25
0 / 4294967039 (0xFFFFFEFF)

MaxNoOfSubscribers

unsigned N NDB 7.3.0
0
0 / 4294967039 (0xFFFFFEFF)

MaxNoOfSubscriptions

unsigned N NDB 7.3.0
0
0 / 4294967039 (0xFFFFFEFF)

MaxNoOfTables

integer N NDB 7.3.0
128
8 / 20320

MaxNoOfTriggers

integer N NDB 7.3.0
768
0 / 4294967039 (0xFFFFFEFF)

MaxNoOfUniqueHashIndexes

integer N NDB 7.3.0
64
0 / 4294967039 (0xFFFFFEFF)

MaxParallelCopyInstances

integer S NDB 7.4.3
0
0 / 64

MaxParallelScansPerFragment

bytes N NDB 7.3.0
256
1 / 4294967039 (0xFFFFFEFF)

MaxStartFailRetries

unsigned N NDB 7.3.0
3
0 / 4294967039 (0xFFFFFEFF)

MemReportFrequency

unsigned N NDB 7.3.0
0
0 / 4294967039 (0xFFFFFEFF)

MinDiskWriteSpeed

numeric S NDB 7.4.1
10M
1M / 1024G

MinFreePct

unsigned N NDB 7.3.0
5
0 / 100

NodeGroup

  IS NDB 7.3.0
[none]
0 / 65536

NodeId

unsigned IS NDB 7.3.0
[none]
1 / 48

NoOfFragmentLogFiles

integer IN NDB 7.3.0
16
3 / 4294967039 (0xFFFFFEFF)

NoOfReplicas

integer IS NDB 7.3.0
2
1 / 4

Numa

boolean N NDB 7.3.0
1
...

ODirect

boolean N NDB 7.3.0
false
true, false

RealtimeScheduler

boolean N NDB 7.3.0
false
true, false

RedoBuffer

bytes N NDB 7.3.0
32M
1M / 4294967039 (0xFFFFFEFF)

RedoOverCommitCounter

numeric N NDB 7.3.0
3
0 / 4294967039 (0xFFFFFEFF)

RedoOverCommitLimit

seconds N NDB 7.3.0
20
0 / 4294967039 (0xFFFFFEFF)

ReservedSendBufferMemory

bytes N NDB 7.3.0
256K
0 / 4294967039 (0xFFFFFEFF)

RestartOnErrorInsert

error code N NDB 7.3.0
2
0 / 4

SchedulerExecutionTimer

µs N NDB 7.3.0
50
0 / 11000

SchedulerResponsiveness

integer S NDB 7.4.9
5
0 / 10

SchedulerSpinTimer

µs N NDB 7.3.0
0
0 / 500

ServerPort

unsigned S NDB 7.3.0
[none]
1 / 64K

SharedGlobalMemory

bytes N NDB 7.3.0
128M
0 / 64T

StartFailRetryDelay

unsigned N NDB 7.3.0
0
0 / 4294967039 (0xFFFFFEFF)

StartFailureTimeout

milliseconds N NDB 7.3.0
0
0 / 4294967039 (0xFFFFFEFF)

StartNoNodeGroupTimeout

milliseconds N NDB 7.3.0
15000
0 / 4294967039 (0xFFFFFEFF)

StartPartialTimeout

milliseconds N NDB 7.3.0
30000
0 / 4294967039 (0xFFFFFEFF)

StartPartitionedTimeout

milliseconds N NDB 7.3.0
60000
0 / 4294967039 (0xFFFFFEFF)

StartupStatusReportFrequency

seconds N NDB 7.3.0
0
0 / 4294967039 (0xFFFFFEFF)

StopOnError

boolean N NDB 7.3.0
1
0, 1

StringMemory

% or bytes S NDB 7.3.0
25
0 / 4294967039 (0xFFFFFEFF)

TcpBind_INADDR_ANY

boolean N NDB 7.3.0
false
true, false

TimeBetweenEpochs

milliseconds N NDB 7.3.0
100
0 / 32000

TimeBetweenEpochsTimeout

milliseconds N NDB 7.3.0
0
0 / 256000

TimeBetweenGlobalCheckpoints

milliseconds N NDB 7.3.0
2000
20 / 32000

TimeBetweenGlobalCheckpointsTimeout

milliseconds N NDB 7.3.9
120000
10 / 4294967039 (0xFFFFFEFF)

TimeBetweenInactiveTransactionAbortCheck

milliseconds N NDB 7.3.0
1000
1000 / 4294967039 (0xFFFFFEFF)

TimeBetweenLocalCheckpoints

number of 4-byte words, as a base-2 logarithm N NDB 7.3.0
20
0 / 31

TimeBetweenWatchDogCheck

milliseconds N NDB 7.3.0
6000
70 / 4294967039 (0xFFFFFEFF)

TimeBetweenWatchDogCheckInitial

milliseconds N NDB 7.3.0
6000
70 / 4294967039 (0xFFFFFEFF)

TotalSendBufferMemory

bytes N NDB 7.3.0
0
256K / 4294967039 (0xFFFFFEFF)

TransactionBufferMemory

bytes N NDB 7.3.0
1M
1K / 4294967039 (0xFFFFFEFF)

TransactionDeadlockDetectionTimeout

milliseconds N NDB 7.3.0
1200
50 / 4294967039 (0xFFFFFEFF)

TransactionInactiveTimeout

milliseconds N NDB 7.3.0
[see text]
0 / 4294967039 (0xFFFFFEFF)

TwoPassInitialNodeRestartCopy

boolean N NDB 7.3.0
false
true, false

UndoDataBuffer

unsigned N NDB 7.3.0
16M
1M / 4294967039 (0xFFFFFEFF)

UndoIndexBuffer

unsigned N NDB 7.3.0
2M
1M / 4294967039 (0xFFFFFEFF)

Table B.3 Multi-Threaded Data Node Configuration Parameters

Parameter Name Type or Units Restart Type In Version ... (and later)
Default Value
Minimum/Maximum or Permitted Values

MaxNoOfExecutionThreads

integer IS NDB 7.3.3
2
2 / 72

NoOfFragmentLogParts

numeric IN NDB 7.3.3
4
4, 8, 12, 16, 24, 32

ThreadConfig

string IS NDB 7.3.0
''
...


User Comments
User comments in this section are, as the name implies, provided by MySQL users. The MySQL documentation team is not responsible for, nor do they endorse, any of the information provided here.
Sign Up Login You must be logged in to post a comment.