Skip navigation links

Additional languages
16.3.5.2 Management Node Configuration Parameters »
Section Navigation      [Toggle]

16.3.5.1. 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 16.3.4.5, “Defining Data Nodes”.

Restart Type Column Values

  • N: Node Restart

  • IN: Initial Node Restart

  • S: System Restart

  • IS: Initial System Restart

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

Parameter Name Type/Units Default Value Minimum Value Maximum Value Restart Type
ArbitrationTimeout milliseconds 3000 10 4294967039 N
BackupDataBufferSize bytes 2M 0 4294967039 N
BackupDataDir string FileSystemPath/BACKUP N/A N/A IN
BackupLogBufferSize bytes 2M 0 4294967039 N
BackupMemory bytes 4M 0 4294967039 N
BackupReportFrequency (Added in MySQL Cluster NDB 6.2.3) seconds 0 0 4294967039 N
BackupWriteSize bytes 32K 2K 4294967039 N
BackupMaxWriteSize bytes 256K 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 /var/lib/mysql-cluster 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
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 value specified for 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 N
IndexMemory bytes 18M 1M 1024G (subject to available system RAM and size of DataMemory) N
InitialNoOfOpenFiles integer 27 20 4294967039 N
LockExecuteThreadToCPU (Added in MySQL Cluster NDB 6.3.4) integer 65535 0 65535 N
LockMaintThreadsToCPU (Added in MySQL Cluster NDB 6.3.4) integer 65535 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 512K 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
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 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 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
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 8M 1M 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
TransactionBufferMemory bytes 1M 1K 4294967039 N
TransactionDeadlockDetectionTimeout milliseconds 1200 50 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.

In MySQL Cluster NDB 6.4, we plan to make it possible to add new data node groups to a running cluster online.