MySQL 5.5 Reference Manual :: 17 MySQL Cluster NDB 7.2 :: 17.3 MySQL Cluster Configuration :: 17.3.3 Overview of MySQL Cluster Configuration Parameters :: 17.3.3.1 MySQL Cluster Data Node Configuration Parameters

« 17.3.3 Overview of MySQL Cluster Configuration Parameters

17.3.3.2 MySQL Cluster Management Node Configuration Parameters »

Section Navigation [Toggle]

17.3.3 Overview of MySQL Cluster Configuration Parameters
17.3.3.1 MySQL Cluster Data Node Configuration Parameters
17.3.3.2 MySQL Cluster Management Node Configuration Parameters
17.3.3.3 MySQL Cluster SQL Node and API Node Configuration Parameters
17.3.3.4 Other MySQL Cluster Configuration Parameters

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”.

These parameters also apply to ndbmtd, the 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:

N—Node restart: The parameter can be updated using a rolling restart (see Section 17.5.5, “Performing a Rolling Restart of a MySQL Cluster”).
S—System restart: The cluster must be shut down completely, then restarted, to effect a change in this parameter.
I—Initial restart: Data nodes must be restarted using the --initial option.

For more information about restart types, see Section 17.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 17.5.13, “Adding MySQL Cluster Data Nodes Online”.

Table 17.1. 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.2.0
	Default
	Default, Disabled, WaitExternal
`ArbitrationTimeout`	milliseconds	N	NDB 7.2.0
	7500
	10 / 4G
`BackupDataBufferSize`	bytes	N	NDB 7.2.0
	16M
	0 / 4G
`BackupDataDir`	path	IN	NDB 7.2.0
	FileSystemPath
	...
`BackupLogBufferSize`	bytes	N	NDB 7.2.0
	16M
	0 / 4G
`BackupMaxWriteSize`	bytes	N	NDB 7.2.1
	1M
	2K / 4G
`BackupMemory`	bytes	N	NDB 7.2.0
	32M
	0 / 4G
`BackupReportFrequency`	seconds	N	NDB 7.2.0
	0
	0 / 4G
`BackupWriteSize`	bytes	N	NDB 7.2.0
	256K
	2K / 4G
`BatchSizePerLocalScan`	integer	N	NDB 7.2.1
	256
	1 / 992
`BuildIndexThreads`	numeric	S	NDB 7.2.0
	0
	0 / 128
`CompressedBackup`	boolean	N	NDB 7.2.0
	false
	true, false
`CompressedLCP`	boolean	N	NDB 7.2.0
	false
	true, false
`ConnectCheckIntervalDelay`	string	N	NDB 7.2.1
	0
	0 / 4G
`CrashOnCorruptedTuple`	boolean	S	NDB 7.2.1
	true
	true, false
`DataDir`	path	IN	NDB 7.2.0
	.
	...
`DataMemory`	bytes	N	NDB 7.2.0
	80M
	1M / 1024G
`DefaultHashMapSize`	LDM threads	N	NDB 7.2.11
	3840
	0 / 3840
`DictTrace`	bytes	N	NDB 7.2.0
	undefined
	0 / 100
`DiskCheckpointSpeed`	bytes	N	NDB 7.2.0
	10M
	1M / 4G
`DiskCheckpointSpeedInRestart`	bytes	N	NDB 7.2.0
	100M
	1M / 4G
`DiskIOThreadPool`	threads	N	NDB 7.2.0
	2
	0 / 4G
`Diskless`	true\|false (1\|0)	IS	NDB 7.2.0
	false
	true, false
`DiskPageBufferMemory`	bytes	N	NDB 7.2.0
	64M
	4M / 1T
`DiskSyncSize`	bytes	N	NDB 7.2.0
	4M
	32K / 4G
`ExecuteOnComputer`	name	S	NDB 7.2.0
	[none]
	...
`ExtraSendBufferMemory`	bytes	N	NDB 7.2.0
	0
	0 / 32G
`FileSystemPath`	path	IN	NDB 7.2.0
	DataDir
	...
`FileSystemPathDataFiles`	filename	IN	NDB 7.2.0
	[see text]
	...
`FileSystemPathDD`	filename	IN	NDB 7.2.0
	FileSystemPath
	...
`FileSystemPathUndoFiles`	filename	IN	NDB 7.2.0
	[see text]
	...
`FragmentLogFileSize`	bytes	IN	NDB 7.2.0
	16M
	4M / 1G
`HeartbeatIntervalDbApi`	milliseconds	N	NDB 7.2.0
	1500
	100 / 4G
`HeartbeatIntervalDbDb`	milliseconds	N	NDB 7.2.0
	5000
	10 / 4G
`HeartbeatOrder`	numeric	S	NDB 7.2.0
	0
	0 / 65535
`HostName`	name or IP address	S	NDB 7.2.0
	localhost
	...
`Id`	unsigned	IS	NDB 7.2.0
	[none]
	1 / 48
`IndexMemory`	bytes	N	NDB 7.2.0
	18M
	1M / 1T
`InitFragmentLogFiles`	[see values]	IN	NDB 7.2.0
	SPARSE
	SPARSE, FULL
`InitialLogFileGroup`	string	S	NDB 7.2.0
	[see text]
	...
`InitialNoOfOpenFiles`	files	N	NDB 7.2.0
	27
	20 / 4G
`InitialTablespace`	string	S	NDB 7.2.0
	[see text]
	...
`IOThreadPool`	threads	N	NDB 7.2.0
	8
	0 / 4G
`LockExecuteThreadToCPU`	CPU ID	N	NDB 7.2.0
	64K
	0 / 64K
`LockMaintThreadsToCPU`	CPU ID	N	NDB 7.2.0
	[none]
	0 / 64K
`LockPagesInMainMemory`	numeric	N	NDB 7.2.0
	0
	0 / 2
`LogLevelCheckpoint`	log level	N	NDB 7.2.0
	0
	0 / 15
`LogLevelCongestion`	levelr	N	NDB 7.2.0
	0
	0 / 15
`LogLevelConnection`	integer	N	NDB 7.2.0
	0
	0 / 15
`LogLevelError`	integer	N	NDB 7.2.0
	0
	0 / 15
`LogLevelInfo`	integer	N	NDB 7.2.0
	0
	0 / 15
`LogLevelNodeRestart`	integer	N	NDB 7.2.0
	0
	0 / 15
`LogLevelShutdown`	integer	N	NDB 7.2.0
	0
	0 / 15
`LogLevelStartup`	integer	N	NDB 7.2.0
	1
	0 / 15
`LogLevelStatistic`	integer	N	NDB 7.2.0
	0
	0 / 15
`LongMessageBuffer`	bytes	N	NDB 7.2.0
	4M
	512K / 4G
`MaxAllocate`	unsigned	N	NDB 7.2.0
	32M
	1M / 1G
`MaxBufferedEpochs`	epochs	N	NDB 7.2.0
	100
	0 / 100000
`MaxDMLOperationsPerTransaction`	operations (DML)	N	NDB 7.2.0
	4294967295
	32 / 4294967295
`MaxLCPStartDelay`	seconds	N	NDB 7.2.0
	0
	0 / 600
`MaxNoOfAttributes`	integer	N	NDB 7.2.0
	1000
	32 / 4G
`MaxNoOfConcurrentIndexOperations`	integer	N	NDB 7.2.0
	8K
	0 / 4G
`MaxNoOfConcurrentOperations`	integer	N	NDB 7.2.0
	32K
	32 / 4G
`MaxNoOfConcurrentScans`	integer	N	NDB 7.2.0
	256
	2 / 500
`MaxNoOfConcurrentSubOperations`	unsigned	N	NDB 7.2.0
	256
	0 / 4G
`MaxNoOfConcurrentTransactions`	integer	S	NDB 7.2.0
	4096
	32 / 4G
`MaxNoOfFiredTriggers`	integer	N	NDB 7.2.0
	4000
	0 / 4G
`MaxNoOfLocalOperations`	integer	N	NDB 7.2.0
	UNDEFINED
	32 / 4G
`MaxNoOfLocalScans`	integer	N	NDB 7.2.0
	UNDEFINED
	32 / 4G
`MaxNoOfOpenFiles`	unsigned	N	NDB 7.2.0
	0
	20 / 4G
`MaxNoOfOrderedIndexes`	integer	N	NDB 7.2.0
	128
	0 / 4G
`MaxNoOfSavedMessages`	integer	N	NDB 7.2.0
	25
	0 / 4G
`MaxNoOfSubscribers`	unsigned	N	NDB 7.2.0
	0
	0 / 4G
`MaxNoOfSubscriptions`	unsigned	N	NDB 7.2.0
	0
	0 / 4G
`MaxNoOfTables`	integer	N	NDB 7.2.0
	128
	8 / 20320
`MaxNoOfTriggers`	integer	N	NDB 7.2.0
	768
	0 / 4G
`MaxNoOfUniqueHashIndexes`	integer	N	NDB 7.2.0
	64
	0 / 4G
`MaxParallelScansPerFragment`	bytes	N	NDB 7.2.0
	256
	1 / 1G
`MaxStartFailRetries`	unsigned	N	NDB 7.2.0
	3
	0 / 4G
`MemReportFrequency`	unsigned	N	NDB 7.2.0
	0
	0 / 4G
`MinFreePct`	unsigned	N	NDB 7.2.3
	5
	0 / 100
`NodeGroup`		IS	NDB 7.2.0
	[none]
	0 / 65536
`NodeId`	unsigned	IS	NDB 7.2.0
	[none]
	1 / 48
`NoOfFragmentLogFiles`	integer	IN	NDB 7.2.0
	16
	3 / 4G
`NoOfReplicas`	integer	IS	NDB 7.2.0
	2
	1 / 4
`Numa`	boolean	N	NDB 7.2.0
	false
	...
`ODirect`	boolean	N	NDB 7.2.0
	false
	true, false
`RealtimeScheduler`	boolean	N	NDB 7.2.0
	false
	true, false
`RedoBuffer`	bytes	N	NDB 7.2.0
	32M
	1M / 4G
`RedoOverCommitCounter`	numeric	N	NDB 7.2.0
	3
	0 / 4G
`RedoOverCommitLimit`	seconds	N	NDB 7.2.0
	20
	0 / 4G
`ReservedSendBufferMemory`	bytes	N	NDB 7.2.0
	256K
	0 / 4G
`RestartOnErrorInsert`	error code	N	NDB 7.2.0
	2
	0 / 4
`SchedulerExecutionTimer`	µsec	N	NDB 7.2.0
	50
	0 / 11000
`SchedulerSpinTimer`	µsec	N	NDB 7.2.0
	0
	0 / 500
`ServerPort`	unsigned	N	NDB 7.2.0
	[none]
	1 / 64K
`SharedGlobalMemory`	bytes	N	NDB 7.2.0
	128M
	0 / 64T
`StartFailRetryDelay`	unsigned	N	NDB 7.2.0
	0
	0 / 4G
`StartFailureTimeout`	milliseconds	N	NDB 7.2.0
	0
	0 / 4G
`StartNoNodeGroupTimeout`	milliseconds	N	NDB 7.2.0
	15000
	0 / 4294967039
`StartPartialTimeout`	milliseconds	N	NDB 7.2.0
	30000
	0 / 4G
`StartPartitionedTimeout`	milliseconds	N	NDB 7.2.0
	60000
	0 / 4G
`StartupStatusReportFrequency`	seconds	N	NDB 7.2.0
	[none]
	...
`StopOnError`	boolean	N	NDB 7.2.0
	true
	true, false
`StringMemory`	% or bytes	S	NDB 7.2.1
	25
	0 / 4G
`TcpBind_INADDR_ANY`	boolean	N	NDB 7.2.0
	false
	true, false
`TimeBetweenEpochs`	milliseconds	N	NDB 7.2.0
	100
	0 / 32000
`TimeBetweenEpochsTimeout`	milliseconds	N	NDB 7.2.0
	4000
	0 / 256000
`TimeBetweenGlobalCheckpoints`	milliseconds	N	NDB 7.2.0
	2000
	20 / 32000
`TimeBetweenInactiveTransactionAbortCheck`	milliseconds	N	NDB 7.2.0
	1000
	1000 / 4G
`TimeBetweenLocalCheckpoints`	number of 4-byte words, as a base-2 logarithm	N	NDB 7.2.0
	20
	0 / 31
`TimeBetweenWatchDogCheck`	milliseconds	N	NDB 7.2.0
	6000
	70 / 4G
`TimeBetweenWatchDogCheckInitial`	milliseconds	N	NDB 7.2.0
	6000
	70 / 4G
`TotalSendBufferMemory`	bytes	N	NDB 7.2.0
	256K
	0 / 4G
`TransactionBufferMemory`	bytes	N	NDB 7.2.0
	1M
	1K / 4G
`TransactionDeadlockDetectionTimeout`	milliseconds	N	NDB 7.2.0
	1200
	50 / 4G
`TransactionInactiveTimeout`	milliseconds	N	NDB 7.2.0
	4G
	0 / 4G
`TwoPassInitialNodeRestartCopy`	boolean	N	NDB 7.2.0
	false
	true, false
`UndoDataBuffer`	unsigned	N	NDB 7.2.0
	16M
	1M / 4G
`UndoIndexBuffer`	unsigned	N	NDB 7.2.0
	2M
	1M / 4G

Table 17.2. 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	N	NDB 7.2.5
	2
	2 / 36
`NoOfFragmentLogParts`	numeric	IN	NDB 7.2.5
	4
	4, 8, 12, 16
`ThreadConfig`	string	N	NDB 7.2.3
	''
	...

Previous / Next / Up / Table of Contents

User Comments

Add your own comment.

Top / Previous / Next / Up / Table of Contents