MySQL 3.23, 4.0, 4.1 Reference Manual :: 15 MySQL Cluster :: 15.3 MySQL Cluster Configuration :: 15.3.3 Overview of MySQL Cluster Configuration Parameters :: 15.3.3.1 MySQL Cluster Data Node Configuration Parameters

« 15.3.3 Overview of MySQL Cluster Configuration Parameters

15.3.3.2 MySQL Cluster Management Node Configuration Parameters »

Section Navigation [Toggle]

15.3.3 Overview of MySQL Cluster Configuration Parameters
15.3.3.1 MySQL Cluster Data Node Configuration Parameters
15.3.3.2 MySQL Cluster Management Node Configuration Parameters
15.3.3.3 MySQL Cluster SQL Node and API Node Configuration Parameters
15.3.3.4 Other MySQL Cluster Configuration Parameters

15.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 15.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:

N—Node restart: The parameter can be updated using a rolling restart (see Section 15.2.6.1, “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 15.3.3, “Overview of MySQL Cluster Configuration Parameters”.

Table 15.1. Data Node Configuration Parameters

Name	Type/Units	Default	Min Value	Max Value	Restart Type
ArbitrationTimeout	milliseconds	3000	10	4G	N
BackupDataBufferSize	bytes	2M		4G	N
BackupDataDir	path	FileSystemPath			IN
BackupLogBufferSize	bytes	2M		4G	N
BackupMaxWriteSize					N
BackupMemory	bytes	4M		4G	N
BackupWriteSize	bytes	32K	2K	4G	N
BatchSizePerLocalScan	integer	64	1	992	N
DataDir	path	.			IN
DataMemory	bytes	80M	1M	1024G	N
Diskless	true\|false (1\|0)	false			IS
ExecuteOnComputer	name				S
HeartbeatIntervalDbApi	milliseconds	1500	100	4G	N
HeartbeatIntervalDbDb	milliseconds	1500	10	4G	N
HostName	name or IP address	localhost			S
Id	unsigned		1	48	IS
IndexMemory	bytes	18M	1M	1T	N
LockPagesInMainMemory	true\|false (1\|0)			1	N
LogLevelCheckpoint	log level			15	N
LogLevelConnection	integer			15	N
LogLevelError	integer			15	N
LogLevelInfo	integer			15	N
LogLevelNodeRestart	integer			15	N
LogLevelShutdown	integer			15	N
LogLevelStartup	integer	1		15	N
LogLevelStatistic	integer			15	N
LongMessageBuffer	bytes	1M	512K	4G	N
MaxNoOfAttributes	integer	1000	32	4G	N
MaxNoOfConcurrentIndexOperations	integer	8K		4G	N
MaxNoOfConcurrentOperations	integer	32K	32	4G	N
MaxNoOfConcurrentScans	integer	256	2	500	N
MaxNoOfConcurrentTransactions	integer	4096	32	4G	S
MaxNoOfFiredTriggers	integer	4000		4G	N
MaxNoOfLocalOperations	integer	UNDEFINED	32	4G	N
MaxNoOfLocalScans	integer	UNDEFINED	32	4G	N
MaxNoOfOpenFiles					N
MaxNoOfOrderedIndexes	integer	128		4G	N
MaxNoOfSavedMessages	integer	25		4G	N
MaxNoOfTables	integer	128	8	1600	N
MaxNoOfTriggers	integer	768		4G	N
MaxNoOfUniqueHashIndexes	integer	64		4G	N
NoOfDiskPagesToDiskAfterRestartACC	8K pages/100 milliseconds	20	1	4G	N
NoOfDiskPagesToDiskAfterRestartTUP	8K pages/100 milliseconds	40	1	4G	N
NoOfDiskPagesToDiskDuringRestartACC	8K pages/100 milliseconds	20	1	4G	N
NoOfDiskPagesToDiskDuringRestartTUP	8K pages/100 milliseconds	40	1	4G	N
NoOfFragmentLogFiles	integer	8	3	4G	IN
NoOfReplicas	integer		1	4	IS
RedoBuffer	bytes	8M	1M	4G	N
RestartOnErrorInsert	error code	2		4	N
ServerPort	unsigned		1	64K	N
StartFailureTimeout	milliseconds			4G	N
StartPartialTimeout	milliseconds	30000		4G	N
StartPartitionedTimeout	milliseconds	60000		4G	N
StopOnError		true			N
StringMemory	% or bytes			4G	S
TimeBetweenGlobalCheckpoints	milliseconds	2000	10	32000	N
TimeBetweenInactiveTransactionAbortCheck	milliseconds	1000	1000	4G	N
TimeBetweenLocalCheckpoints	number of 4-byte words, as a base-2 logarithm	20		31	N
TimeBetweenWatchDogCheck	milliseconds	6000	70	4G	N
TransactionBufferMemory	bytes	1M	1K	4G	N
TransactionDeadlockDetectionTimeout	milliseconds	1200	50	4G	N
TransactionInactiveTimeout	milliseconds	4G		4G	N
UndoDataBuffer	unsigned	16M	1M	4G	N
UndoIndexBuffer	unsigned	2M	1M	4G	N

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

Previous / Next / Up / Table of Contents

User Comments

Add your own comment.

Top / Previous / Next / Up / Table of Contents