Skip navigation links

Additional languages
17.3.5.2 MySQL Cluster Management Node Configuration Parameters »
Section Navigation      [Toggle]

17.3.5.1. MySQL Cluster Data Node Configuration Parameters

The following table 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.4.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.6.3, “ndbmtd — The MySQL Cluster Data Node Daemon (Multi-Threaded)”.

Restart Type Column Values

  • N: Node Restart

  • IN: Initial Node Restart

  • S: System Restart

  • IS: Initial System Restart

See Section 17.3.5, “Overview of MySQL Cluster Configuration Parameters”, for additional explanations of these abbreviations.

Table 17.1. MySQL Cluster Data Node Configuration Parameters

Parameter Name Type/Units Default Value Minimum Value Maximum Value Restart Type
ArbitrationTimeout milliseconds 3000 10 4294967039 N
BackupDataBufferSize bytes MySQL Cluster 6.4.3 and earlier: 2M; MySQL Cluster NDB 7.0.4 and later: 16M 0 4294967039 N
BackupDataDir string FileSystemPath/BACKUP N/A N/A IN
BackupLogBufferSize bytes MySQL Cluster 6.4.3 and earlier: 2M; MySQL Cluster NDB 7.0.4 and later: 16M 0 4294967039 N
BackupMemory bytes MySQL Cluster 6.4.3 and earlier: 4M; MySQL Cluster NDB 7.0.4 and later: 32M 0 4294967039 N
BackupReportFrequency (Added in MySQL Cluster NDB 6.2.3) seconds 0 0 4294967039 N
BackupWriteSize bytes MySQL Cluster 6.4.3 and earlier: 32K; MySQL Cluster NDB 7.0.4 and later: 256K 2K 4294967039 N
BackupMaxWriteSize bytes MySQL Cluster 6.4.3 and earlier: 256K; MySQL Cluster NDB 7.0.4 and later: 1M 2K 4294967039 N
BatchSizePerLocalScan integer 64 1 992 N
CompressedBackup (Added in MySQL Cluster NDB 6.3.7) boolean 0 0 1 N
CompressedLCP (Added in MySQL Cluster NDB 6.3.7) boolean 0 0 1 N
DataDir string . N/A N/A IN
DataMemory bytes 80M 1M 1024G (subject to available system RAM and size of IndexMemory) N
DiskCheckpointSpeed (added in MySQL 5.1.12) integer (number of bytes per second) 10M 1M 4294967039 N
DiskCheckpointSpeedInRestart (added in MySQL 5.1.12) integer (number of bytes per second) 100M 1M 4294967039 N
DiskIOThreadPool (Added in MySQL Cluster NDB 6.4.0; named ThreadPool prior to MySQL Cluster NDB 6.4.3) integer 8 0 4294967039 N
Diskless true|false (1|0) 0 0 1 IS
DiskPageBufferMemory (added in MySQL 5.1.6) bytes 64M 4M 1024G N
DiskSyncSize (added in MySQL 5.1.12) integer (number of bytes) 4M 32K 4294967039 N
ExecuteOnComputer integer        
FileSystemPath (Added in MySQL Cluster NDB 6.1.11) string (directory path) value specified for DataDir N/A N/A IN
FileSystemPathDD (Added in MySQL Cluster NDB 6.2.17, 6.3.22, and 6.4.3) string (directory path) value specified for FilesystemPath, if set; otherwise, value of DataDir N/A N/A IN
FileSystemPathDataFiles (Added in MySQL Cluster NDB 6.2.17, 6.3.22, and 6.4.3) string (directory path) value specified for FilesystemPathDD, if set; otherwise, value specified for FilesystemPath, if set; otherwise, value of DataDir N/A N/A IN
FileSystemPathUndoFiles (Added in MySQL Cluster NDB 6.2.17, 6.3.22, and 6.4.3) string (directory path) value specified for FilesystemPathDD, if set; otherwise, value specified for FilesystemPath, if set; otherwise, value of DataDir N/A N/A IN
FragmentLogFileSize integer (bytes) 16M 4M 1G IN
HeartbeatIntervalDbApi milliseconds 1500 100 4294967039 N
HeartbeatIntervalDbDb milliseconds 1500 10 4294967039 N
HostName string localhost N/A N/A S
Id integer None 1 48 IS
IndexMemory bytes 18M 1M 1024G (subject to available system RAM and size of DataMemory) N
InitFragmentLogFiles (Added in MySQL Cluster NDB 6.3.19) string full sparse sparse IN
InitialLogFileGroup (Added in MySQL Cluster NDB 6.2.17, 6.3.22, and 6.4.3) string (see description for details) none N/A N/A S
InitialNoOfOpenFiles integer 27 20 4294967039 N
InitialTablespace (Added in MySQL Cluster NDB 6.2.17, 6.3.22, and 6.4.3) string (see description for details) none N/A N/A S
LockExecuteThreadToCPU (Added in MySQL Cluster NDB 6.3.4; changed in MySQL Cluster NDB 7.0) MySQL Cluster NDB 6.3 and earlier: integer; MySQL Cluster NDB 7.0 and later: string MySQL Cluster NDB 6.4.3 and earlier: 65535; MySQL Cluster NDB 7.0 and later: N/A MySQL Cluster NDB 6.4.3 and earlier: 0; MySQL Cluster NDB 7.0 and later: N/A MySQL Cluster NDB 6.4.3 and earlier: 65535; MySQL Cluster NDB 7.0 and later: N/A N
LockMaintThreadsToCPU (Added in MySQL Cluster NDB 6.3.4) integer MySQL Cluster NDB 6.3: 65535; MySQL Cluster NDB 7.0 and later: N/A 0 65535 N
LockPagesInMainMemory As of MySQL 5.1.15 and MySQL Cluster NDB 6.1.1: integer; previously: true|false (1|0) 0 0 As of MySQL 5.1.15 and MySQL Cluster NDB 6.1.1: 2; previously: 1 N
LogLevelCheckpoint integer 0 0 15 IN
LogLevelCongestion integer 0 0 15 N
LogLevelConnection integer 0 0 15 N
LogLevelError integer 0 0 15 N
LogLevelInfo integer 0 0 15 N
LogLevelNodeRestart integer 0 0 15 N
LogLevelShutdown integer 0 0 15 N
LogLevelStartup integer 1 0 15 N
LogLevelStatistic integer 0 0 15 N
LongMessageBuffer bytes 1M MySQL Cluster 6.4.3 and earlier: 1M; MySQL Cluster NDB 7.0.4 and later: 4M 4294967039 N
MaxAllocate (Added in MySQL Cluster NDB 6.1.12 and MySQL Cluster NDB 6.2.3) integer (bytes) 32M 1M 1G N
MaxBufferedEpochs (Added in MySQL Cluster NDB 6.2.14) integer 100 0 100000 N
MaxLCPStartDelay (Added in MySQL Cluster NDB 6.3.23 and MySQL Cluster NDB 6.4.3) integer (seconds) 0 0 600 N
MaxNoOfAttributes integer 1000 32 4294967039 N
MaxNoOfConcurrentIndexOperations integer 8K 0 4294967039 N
MaxNoOfConcurrentOperations integer 32768 32 4294967039 N
MaxNoOfConcurrentScans integer 256 2 500 N
MaxNoOfConcurrentTransactions integer 4096 32 4294967039 S
MaxNoOfExecutionThreads (added in MySQL Cluster NDB 6.4.0; applies to ndbmtd only) integer (as of MySQL Cluster NDB 7.0.4:) 2 (previously: none) 2 8 N
MaxNoOfFiredTriggers integer 4000 0 4294967039 N
MaxNoOfIndexes (DEPRECATED — use MaxNoOfOrderedIndexes or MaxNoOfUniqueHashIndexes instead) integer 128 0 4294967039 N
MaxNoOfLocalOperations integer UNDEFINED 32 4294967039 N
MaxNoOfLocalScans integer UNDEFINED (see description) 32 4294967039 N
MaxNoOfOpenFiles integer 0 (prior to MySQL 5.1.16: 40) 20 4294967039 N
MaxNoOfOrderedIndexes integer 128 0 4294967039 N
MaxNoOfSavedMessages integer 25 0 4294967039 N
MaxNoOfTables integer 128 8 4294967039 N
MaxNoOfTriggers integer 768 0 4294967039 N
MaxNoOfUniqueHashIndexes integer 64 0 4294967039 N
MemReportFrequency (Added in MySQL 5.1.16 and MySQL Cluster NDB 6.1.0) integer (seconds) 0 0 4294967039 N
NodeGroup (Added in MySQL Cluster NDB 6.4.0) integer UNDEFINED (normally determined by management server) 0 65535 SI
NoOfDiskPagesToDiskAfterRestartACC (DEPRECATED as of MySQL 5.1.6) integer (number of 8KB pages per 100 milliseconds) 20 (= 20 * 80KB = 1.6MB/second) 1 4294967039 N
NoOfDiskPagesToDiskAfterRestartTUP (DEPRECATED as of MySQL 5.1.6) integer (number of 8KB pages per 100 milliseconds) 40 (= 40 * 80KB = 3.2MB/second) 1 4294967039 N
NoOfDiskPagesToDiskDuringRestartACC (DEPRECATED as of MySQL 5.1.6) integer (number of 8KB pages per 100 milliseconds) 20 (= 20 * 80KB = 1.6MB/second) 1 4294967039 N
NoOfDiskPagesToDiskDuringRestartTUP (DEPRECATED as of MySQL 5.1.6) integer (number of 8KB pages per 100 milliseconds) 40 (= 40 * 80KB = 3.2MB/second) 1 4294967039 N
NoOfFragmentLogFiles integer 16 3 4294967039 IN
NoOfReplicas integer None 1 4 (theoretical); 2 (supported) IS
ODirect boolean 0 0 1 N
RealTimeScheduler (Added in MySQL Cluster NDB 6.3.4) boolean 0 0 1 N
RedoBuffer bytes MySQL Cluster 6.4.3 and earlier: 8M; MySQL Cluster NDB 7.0.4 and later: 32M 1M 4294967039 N
ReservedSendBufferMemory (added in MySQL Cluster NDB 6.4.0) bytes None 256K 4294967039 N
RestartOnErrorInsert (DEBUG BUILDS ONLY) true|false (1|0) 0 0 1 N
SchedulerExecutionTimer (added in MySQL Cluster NDB 6.3.4) μseconds (integer) 50 0 11000 N
SchedulerSpinTimer (added in MySQL Cluster NDB 6.3.4) μseconds (integer) 0 0 500 N
ServerPort (OBSOLETE) integer 1186 0 4294967039 N
SharedGlobalmemory (added in MySQL 5.1.6) bytes 20M 0 65536G N
StartFailureTimeout milliseconds 0 0 4294967039 N
StartPartialTimeout milliseconds 30000 0 4294967039 N
StartPartitionedTimeout milliseconds 60000 0 4294967039 N
StopOnError true|false (1|0) 1 0 1 N
StringMemory integer or percentage (see description for details) 0 0 4294967039 S
TcpBind_INADDR_ANY (Added in MySQL Cluster NDB 6.2.0) true|false (1|0) 1 0 0 N
TimeBetweenEpochs (Added in MySQL Cluster NDB 6.2.5 and MySQL Cluster NDB 6.3.2) milliseconds 100 0 32000 N
TimeBetweenEpochsTimeout (Added in MySQL Cluster NDB 6.2.7 and MySQL Cluster NDB 6.3.4) milliseconds 4000 0 32000 N
TimeBetweenGlobalCheckpoints milliseconds 2000 10 32000 N
TimeBetweenInactiveTransactionAbortCheck milliseconds 1000 1000 4294967039 N
TimeBetweenLocalCheckpoints integer (number of 4-byte words as a base-2 logarithm) 20 (= 4 * 220 = 4MB write operations) 0 31 N
TimeBetweenWatchDogCheck milliseconds 6000 70 4294967039 N
TimeBetweenWatchDogCheckInitial (added in MySQL 5.1.20) milliseconds 6000 70 4294967039 N
TotalSendBufferMemory (added in MySQL Cluster NDB 6.4.0) bytes None 256K 4294967039 N
TransactionBufferMemory bytes 1M 1K 4294967039 N
TransactionDeadlockDetectionTimeout milliseconds 1200 50 (Note: Prior to MySQL Cluster NDB 6.2.18/6.3.24/7.0.5, 100 was the effective minimum.) 4294967039 N
TransactionInactiveTimeout milliseconds 0 0 4294967039 N
UndoDataBuffer (OBSOLETE) bytes 16M 1M 4294967039 N
UndoIndexBuffer (OBSOLETE) bytes 2M 1M 4294967039 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 (that is, you must perform a system restart). All data node processes must be started with the --initial option.

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