Documentation Home
MySQL Cluster Manager 1.2 User Manual
Related Documentation Download this Manual
PDF (US Ltr) - 1.6Mb
PDF (A4) - 1.6Mb
EPUB - 0.9Mb
HTML Download (TGZ) - 0.9Mb
HTML Download (Zip) - 0.9Mb


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
Sign Up Login You must be logged in to post a comment.