MySQL 5.1 Reference Manual :: 17 MySQL Cluster NDB 6.1 - 7.1 :: 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”.

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.4, “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.4, “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”.

Table 17.1. Data Node Configuration Parameters

Name	Effective Version	Type/Units	Default	Minimum/Maximum, Permitted Values	Restart Type
`Arbitration`	NDB 7.0.7	enumeration	Default	Default, Disabled, WaitExternal	N
`ArbitrationTimeout`	NDB 7.2.0	milliseconds	7500	10 / 4G	N
`BackupDataBufferSize`	NDB 7.0.4	bytes	16M	0 / 4G	N
`BackupDataDir`	all 5.1-based	path	FileSystemPath	...	I
`BackupLogBufferSize`	NDB 7.0.4	bytes	16M	0 / 4G	N
`BackupMaxWriteSize`	5.1.32	bytes	1M	2K / 4G	N
`BackupMemory`	NDB 7.0.4	bytes	32M	0 / 4G	N
`BackupReportFrequency`	NDB 6.2.3	seconds	0	0 / 4G	N
`BackupWriteSize`	NDB 7.0.4	bytes	256K	2K / 4G	N
`BatchSizePerLocalScan`	NDB 7.2.1	integer	256	1 / 992	N
`BuildIndexThreads`	NDB 7.0.11	numeric	0	0 / 128	S
`CompressedBackup`	NDB 6.3.7	boolean	false	...	N
`CompressedLCP`	NDB 6.3.7	boolean	false	...	N
`ConnectCheckIntervalDelay`	NDB 7.1.10	string	1500	0 / 4G	N
`CrashOnCorruptedTuple`	NDB 7.0.28, 5.1.56-ndb-7.1.17	boolean	OFF	...	S
`DataDir`	all 5.1-based	path	.	...	I
`DataMemory`	all 5.1-based	bytes	80M	1M / 1024G	N
`DictTrace`	5.1.12	bytes	undefined	0 / 100	N
`DiskCheckpointSpeed`	5.1.12	bytes	10M	1M / 4G	N
`DiskCheckpointSpeedInRestart`	all 5.1-based	bytes	100M	1M / 4G	N
`DiskIOThreadPool`	NDB 7.1.0	threads	2	0 / 4G	N
`Diskless`	all 5.1-based	true\|false (1\|0)	0	0 / 1	I
`DiskPageBufferMemory`	5.1.6	bytes	64M	4M / 1T	N
`DiskSyncSize`	5.1.12	bytes	4M	32K / 4G	N
`ExecuteOnComputer`	all 5.1-based	name	[none]	...	S
`ExtraSendBufferMemory`	NDB 6.4.0	bytes	0	0 / 32G	N
`FileSystemPath`	all 5.1-based	path	DataDir	...	I
`FileSystemPathDataFiles`	NDB 6.4.3	filename	FileSystemPathDD	...	I
`FileSystemPathDD`	NDB 6.4.3	filename	FileSystemPath	...	I
`FileSystemPathUndoFiles`	NDB 6.4.3	filename	FileSystemPathDD	...	I
`FragmentLogFileSize`	NDB 6.1.11	bytes	16M	4M / 1G	I
`HeartbeatIntervalDbApi`	all 5.1-based	milliseconds	1500	100 / 4G	N
`HeartbeatIntervalDbDb`	NDB 7.2.0	milliseconds	5000	10 / 4G	N
`HeartbeatOrder`	NDB 7.1.5	numeric	0	0 / 65535	S
`HostName`	all 5.1-based	name or IP address	localhost	...	S
`Id`	all 5.1-based	unsigned	[none]	1 / 48	N
`IndexMemory`	all 5.1-based	bytes	18M	1M / 1T	N
`InitFragmentLogFiles`	NDB 6.3.19	sparse\|full	[none]	...	I
`InitialLogFileGroup`	NDB 6.4.3	string	[see documentation]	...	S
`InitialNoOfOpenFiles`	5.1.9	files	27	20 / 4G	N
`InitialTablespace`	NDB 6.4.3	string	[see documentation]	...	S
`IOThreadPool`	NDB 6.4.0	threads	8	0 / 4G	N
`LockExecuteThreadToCPU`	NDB 6.3.4	CPU ID	64K	0 / 64K	N
`LockMaintThreadsToCPU`	NDB 6.4.0	CPU ID	[none]	0 / 64K	N
`LockPagesInMainMemory`	5.1.15	numeric	0	0 / 2	N
`LogLevelCheckpoint`	all 5.1-based	log level	0	0 / 15	I
`LogLevelCongestion`	all 5.1-based	levelr	0	0 / 15	N
`LogLevelConnection`	all 5.1-based	integer	0	0 / 15	N
`LogLevelError`	all 5.1-based	integer	0	0 / 15	N
`LogLevelInfo`	all 5.1-based	integer	0	0 / 15	N
`LogLevelNodeRestart`	all 5.1-based	integer	0	0 / 15	N
`LogLevelShutdown`	all 5.1-based	integer	0	0 / 15	N
`LogLevelStartup`	all 5.1-based	integer	1	0 / 15	N
`LogLevelStatistic`	all 5.1-based	integer	0	0 / 15	N
`LongMessageBuffer`	NDB 7.0.4	bytes	4M	512K / 4G	N
`MaxAllocate`	5.1.20	unsigned	32M	1M / 1G	N
`MaxBufferedEpochs`	NDB 6.2.14	epochs	100	0 / 100000	N
`MaxDMLOperationsPerTransaction`	NDB 7.1.15	operations (DML)	4294967295	32 / 4294967295	N
`MaxLCPStartDelay`	NDB 6.4.3	seconds	0	0 / 600	N
`MaxNoOfAttributes`	all 5.1-based	integer	1000	32 / 4G	N
`MaxNoOfConcurrentIndexOperations`	all 5.1-based	integer	8K	0 / 4G	N
`MaxNoOfConcurrentOperations`	all 5.1-based	integer	32K	32 / 4G	N
`MaxNoOfConcurrentScans`	all 5.1-based	integer	256	2 / 500	N
`MaxNoOfConcurrentSubOperations`	NDB 6.3.7	unsigned	256	0 / 4G	N
`MaxNoOfConcurrentTransactions`	all 5.1-based	integer	4096	32 / 4G	S
`MaxNoOfFiredTriggers`	all 5.1-based	integer	4000	0 / 4G	N
`MaxNoOfLocalOperations`	all 5.1-based	integer	UNDEFINED	32 / 4G	N
`MaxNoOfLocalScans`	all 5.1-based	integer	UNDEFINED	32 / 4G	N
`MaxNoOfOpenFiles`	5.1.16	unsigned	0	20 / 4G	N
`MaxNoOfOrderedIndexes`	all 5.1-based	integer	128	0 / 4G	N
`MaxNoOfSavedMessages`	all 5.1-based	integer	25	0 / 4G	N
`MaxNoOfSubscribers`	NDB 6.3.7	unsigned	0	0 / 4G	N
`MaxNoOfSubscriptions`	NDB 6.3.7	unsigned	0	0 / 4G	N
`MaxNoOfTables`	all 5.1-based	integer	128	8 / 20320	N
`MaxNoOfTriggers`	all 5.1-based	integer	768	0 / 4G	N
`MaxNoOfUniqueHashIndexes`	all 5.1-based	integer	64	0 / 4G	N
`MaxParallelScansPerFragment`	NDB 7.2.0	bytes	256	1 / 1G	N
`MaxStartFailRetries`	NDB 6.2.19	unsigned	3	0 / 4G	N
`MemReportFrequency`	5.1.16	unsigned	0	0 / 4G	N
`MinFreePct`	NDB 7.1.18	unsigned	5	0 / 100	N
`NodeGroup`	NDB 6.4.0		[none]	0 / 65536	I
`NodeId`	all 5.1-based	unsigned	[none]	1 / 48	N
`NoOfDiskPagesToDiskAfterRestartACC`	all 5.1-based	8K pages/100 milliseconds	20	1 / 4G	N
`NoOfDiskPagesToDiskAfterRestartTUP`	all 5.1-based	8K pages/100 milliseconds	40	1 / 4G	N
`NoOfDiskPagesToDiskDuringRestartACC`	all 5.1-based	8K pages/100 milliseconds	20	1 / 4G	N
`NoOfDiskPagesToDiskDuringRestartTUP`	all 5.1-based	8K pages/100 milliseconds	40	1 / 4G	N
`NoOfFragmentLogFiles`	5.1.0	integer	16	3 / 4G	I
`NoOfReplicas`	NDB 7.0.6	integer	2	1 / 4	I
`Numa`	NDB 7.1.9	boolean	false	...	N
`ODirect`	NDB 6.3.0	boolean	0	0 / 1	N
`RealtimeScheduler`	NDB 6.3.4	boolean	false	...	N
`RedoBuffer`	NDB 7.0.4	bytes	32M	1M / 4G	N
`RedoOverCommitCounter`	NDB 7.1.10	numeric	3	0 / 4G	N
`RedoOverCommitLimit`	NDB 7.1.10	seconds	20	0 / 4G	N
`ReservedSendBufferMemory`	NDB 6.4.0	bytes	256K	0 / 4G	N
`RestartOnErrorInsert`	all 5.1-based	error code	2	0 / 4	N
`SchedulerExecutionTimer`	NDB 6.3.4	µsec	50	0 / 11000	N
`SchedulerSpinTimer`	NDB 6.3.4	µsec	0	0 / 500	N
`ServerPort`	all 5.1-based	unsigned	[none]	1 / 64K	N
`SharedGlobalMemory`	5.1.6	bytes	20M	0 / 64T	N
`StartFailRetryDelay`	NDB 6.2.19	unsigned	0	0 / 4G	N
`StartFailureTimeout`	all 5.1-based	milliseconds	0	0 / 4G	N
`StartNoNodeGroupTimeout`	NDB 7.0.24	milliseconds	15000	0 / 4294967039	N
`StartPartialTimeout`	all 5.1-based	milliseconds	30000	0 / 4G	N
`StartPartitionedTimeout`	all 5.1-based	milliseconds	60000	0 / 4G	N
`StartupStatusReportFrequency`	NDB 6.4.0	seconds	[none]	...	N
`StopOnError`	all 5.1-based	true\|false (1\|0)	true	...	N
`StringMemory`	5.1.6	% or bytes	5	0 / 4G	S
`TcpBind_INADDR_ANY`	NDB 6.2.0	boolean	false	...	N
`TimeBetweenEpochs`	NDB 6.2.5	milliseconds	100	0 / 32000	N
`TimeBetweenEpochsTimeout`	5.1.51	milliseconds	4000	0 / 256000	N
`TimeBetweenGlobalCheckpoints`	NDB 6.2.0	milliseconds	2000	20 / 32000	N
`TimeBetweenInactiveTransactionAbortCheck`	all 5.1-based	milliseconds	1000	1000 / 4G	N
`TimeBetweenLocalCheckpoints`	all 5.1-based	number of 4-byte words, as a base-2 logarithm	20	0 / 31	N
`TimeBetweenWatchDogCheck`	all 5.1-based	milliseconds	6000	70 / 4G	N
`TimeBetweenWatchDogCheckInitial`	5.1.20	milliseconds	6000	70 / 4G	N
`TotalSendBufferMemory`	NDB 6.4.0	bytes	256K	0 / 4G	N
`TransactionBufferMemory`	all 5.1-based	bytes	1M	1K / 4G	N
`TransactionDeadlockDetectionTimeout`	all 5.1-based	milliseconds	1200	50 / 4G	N
`TransactionInactiveTimeout`	all 5.1-based	milliseconds	4G	0 / 4G	N
`TwoPassInitialNodeRestartCopy`	NDB 7.1.11	boolean	FALSE	TRUE, FALSE	N
`UndoDataBuffer`	all 5.1-based	unsigned	16M	1M / 4G	N
`UndoIndexBuffer`	all 5.1-based	unsigned	2M	1M / 4G	N

Table 17.2. Multi-Threaded Data Node Configuration Parameters

Name	Effective Version	Type/Units	Default	Minimum/Maximum, Permitted Values	Restart Type
`MaxNoOfExecutionThreads`	NDB 7.0.4	integer	2	2 / 8	N
`ThreadConfig`	NDB 7.1.17	string	''	...	N

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.12, “Adding MySQL Cluster Data Nodes Online”.

Previous / Next / Up / Table of Contents

User Comments

Add your own comment.

Top / Previous / Next / Up / Table of Contents