Additional languages
« 15.4.5 Overview of Cluster Configuration Parameters
15.4.5.2 Management Node Configuration Parameters »
Section Navigation      [Toggle]

15.4.5.1. Data Node Configuration Parameters

The following table provides information about parameters used in the [NDBD] or [NDB_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.4.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 15.4.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 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 /var/lib/mysql-cluster 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 63 N
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
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 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
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 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 50 4294967039 N
TransactionInactiveTimeout milliseconds 0 0 4294967039 N
UndoDataBuffer bytes 16M 1M 4294967039 N
UndoIndexBuffer bytes 2M 1M 4294967039 N