Skip navigation links
17.3.3.2 MySQL Cluster Management Node Configuration Parameters »
Section Navigation      [Toggle]

17.3.3.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.2.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.4.3, “ndbmtd — The MySQL Cluster Data Node Daemon (Multi-Threaded)”.

Table 17.1. Data Node Configuration Parameters

Name Type/Units Default Min Value Max Value Restart Type
Arbitration         N
ArbitrationTimeout         N
BackupDataBufferSize         N
BackupDataDir         IN
BackupLogBufferSize         N
BackupMaxWriteSize         N
BackupMemory         N
BackupReportFrequency         N
BackupWriteSize         N
BatchSizePerLocalScan         N
CompressedBackup   false     N
CompressedLCP   false     N
DataDir         IN
DataMemory         N
DiskCheckpointSpeed bytes 10M 1M 4G N
DiskCheckpointSpeedInRestart bytes 10M 1M 4G N
DiskIOThreadPool         N
Diskless         IS
DiskPageBufferMemory bytes 64M 4M 1T N
DiskSyncSize bytes 4M 32K 4G N
ExecuteOnComputer         S
FileSystemPath path DataDir     IN
FileSystemPathDataFiles   FileSystemPathDD     IN
FileSystemPathDD   FileSystemPath     IN
FileSystemPathUndoFiles   FileSystemPathDD     IN
FragmentLogFileSize bytes 16M 4M 1G IN
HeartbeatIntervalDbApi         N
HeartbeatIntervalDbDb         N
HostName         IN
Id         N
IndexMemory         N
InitFragmentLogFiles         N
InitialLogFileGroup         S
InitialNoOfOpenFiles files 27 20 4G N
InitialTablespace         S
IOThreadPool         N
LockExecuteThreadToCPU         N
LockMaintThreadsToCPU         N
LockPagesInMainMemory true|false (1|0)     1 N
LogLevelCheckpoint         IN
LogLevelCongestion         N
LogLevelConnection         N
LogLevelError         N
LogLevelInfo         N
LogLevelNodeRestart         N
LogLevelShutdown         N
LogLevelStartup         N
LogLevelStatistic         N
LongMessageBuffer         N
MaxAllocate unsigned 32M 1M 1G N
MaxBufferedEpochs         N
MaxLCPStartDelay         N
MaxNoOfAttributes         N
MaxNoOfConcurrentIndexOperations         N
MaxNoOfConcurrentOperations         N
MaxNoOfConcurrentScans         N
MaxNoOfConcurrentSubOperations         N
MaxNoOfConcurrentTransactions         S
MaxNoOfFiredTriggers         N
MaxNoOfLocalOperations         N
MaxNoOfLocalScans         N
MaxNoOfOpenFiles integer 40 20 4G N
MaxNoOfOrderedIndexes         N
MaxNoOfSavedMessages         N
MaxNoOfSubscribers         N
MaxNoOfSubscriptions         N
MaxNoOfTables         N
MaxNoOfTriggers         N
MaxNoOfUniqueHashIndexes         N
MemReportFrequency unsigned     4G N
NodeGroup         IS
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 16 3 4G IN
NoOfReplicas         IS
ODirect         N
RealtimeScheduler         N
RedoBuffer         N
ReservedSendBufferMemory         N
RestartOnErrorInsert         N
SchedulerExecutionTimer         N
SchedulerSpinTimer         N
ServerPort         N
SharedGlobalMemory bytes 20M   64T N
StartFailureTimeout         N
StartPartialTimeout         N
StartPartitionedTimeout         N
StartupStatusReportFrequency         N
StopOnError         N
StringMemory % or bytes 5   4G S
TcpBind_INADDR_ANY         N
TimeBetweenEpochs         N
TimeBetweenEpochsTimeout         N
TimeBetweenGlobalCheckpoints         N
TimeBetweenInactiveTransactionAbortCheck         N
TimeBetweenLocalCheckpoints         N
TimeBetweenWatchDogCheck         N
TimeBetweenWatchDogCheckInitial milliseconds 6000 70 4G N
TotalSendBufferMemory         N
TransactionBufferMemory         N
TransactionDeadlockDetectionTimeout         N
TransactionInactiveTimeout         N
UndoDataBuffer         N
UndoIndexBuffer         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.5.10, “Adding MySQL Cluster Data Nodes Online”.