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.5, “Defining MySQL Cluster Data Nodes”.

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 1000 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
BackupWriteSize bytes 32K 2K 4294967039 N
BackupMaxWriteSize bytes 256K 2K 4294967039 N
BatchSizePerLocalScan integer 64 1 992 N
DataDir string . N/A N/A IN
DataMemory bytes 80M 1M 1024G (subject to available system RAM and size of IndexMemory) N
Diskless true|false (1|0) 0 0 1 IS
ExecuteOnComputer integer        
FileSystemPath string value specified for DataDir N/A N/A 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
LockPagesInMainMemory As of MySQL 5.0.36: integer; previously: true|false (1|0) 0 0 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
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
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
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
NoOfDiskPagesToDiskAfterRestartACC integer (number of 8KB pages per 100 milliseconds) 20 (= 20 * 80KB = 1.6MB/second) 1 4294967039 N
NoOfDiskPagesToDiskAfterRestartTUP integer (number of 8KB pages per 100 milliseconds) 40 (= 40 * 80KB = 3.2MB/second) 1 4294967039 N
NoOfDiskPagesToDiskDuringRestartACC integer (number of 8KB pages per 100 milliseconds) 20 (= 20 * 80KB = 1.6MB/second) 1 4294967039 N
NoOfDiskPagesToDiskDuringRestartTUP integer (number of 8KB pages per 100 milliseconds) 40 (= 40 * 80KB = 3.2MB/second) 1 4294967039 N
NoOfFragmentLogFiles integer 8 1 4294967039 IN
NoOfReplicas integer None 1 4 (theoretical); 2 (supported) IS
RedoBuffer bytes 8M 1M 4294967039 N
RestartOnErrorInsert (DEBUG BUILDS ONLY) true|false (1|0) 0 0 1 N
ServerPort (OBSOLETE) integer 1186 0 4294967039 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
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 4000 70 4294967039 N
TransactionBufferMemory bytes 1M 1K 4294967039 N
TransactionDeadlockDetectionTimeout milliseconds 1200 100 (Can actually be set as low as 50, but any value less than 100 is treated as 100.) 4294967039 N
TransactionInactiveTimeout milliseconds 0 0 4294967039 N
UndoDataBuffer bytes 16M 1M 4294967039 N
UndoIndexBuffer 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.

We are working to make it possible to add new data node groups to a running cluster online in a future release; however, we do not plan to implement this change in MySQL 5.0.