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 {Disabled|Default|WaitExternal} Default     N
ArbitrationTimeout milliseconds 1000 10 4G N
BackupDataBufferSize bytes 2M   4G N
BackupDataDir path FileSystemPath/BACKUP     IN
BackupLogBufferSize bytes 2M   4G N
BackupMaxWriteSize bytes 256K 2K 4G N
BackupMemory bytes 4M   4G N
BackupReportFrequency seconds     4G N
BackupWriteSize bytes 32K 2K 4G N
BatchSizePerLocalScan integer 64 1 992 N
CompressedBackup   false     N
CompressedLCP   false     N
DataDir path .     IN
DataMemory bytes 80M 1M 1024G N
DiskCheckpointSpeed bytes 10M 1M 4G N
DiskCheckpointSpeedInRestart bytes 10M 1M 4G N
DiskIOThreadPool threads 8   4G N
Diskless true|false (1|0)     1 IS
DiskPageBufferMemory bytes 64M 4M 1T N
DiskSyncSize bytes 4M 32K 4G N
ExecuteOnComputer name       S
FileSystemPath path DataDir     IN
FileSystemPathDataFiles   FileSystemPathDD     IN
FileSystemPathDD   FileSystemPath     IN
FileSystemPathUndoFiles   FileSystemPathDD     IN
FragmentLogFileSize bytes 16M 4M 1G IN
HeartbeatIntervalDbApi milliseconds 1500 100 4G N
HeartbeatIntervalDbDb milliseconds 1500 10 4G N
HostName name or IP localhost     S
Id unsigned   1 48 N
IndexMemory bytes 18M 1M 1T N
InitFragmentLogFiles sparse|full       N
InitialLogFileGroup         S
InitialNoOfOpenFiles files 27 20 4G N
InitialTablespace         S
IOThreadPool threads 8   4G N
LockExecuteThreadToCPU CPU ID 64K   64K N
LockMaintThreadsToCPU CPU ID 64K   64K N
LockPagesInMainMemory true|false (1|0)     1 N
LogLevelCheckpoint log level     15 IN
LogLevelCongestion levelr     15 N
LogLevelConnection integer     15 N
LogLevelError integer     15 N
LogLevelInfo integer     15 N
LogLevelNodeRestart integer     15 N
LogLevelShutdown integer     15 N
LogLevelStartup integer 1   15 N
LogLevelStatistic integer     15 N
LongMessageBuffer bytes 1M 512K 4G N
MaxAllocate unsigned 32M 1M 1G N
MaxBufferedEpochs epochs 100   100000 N
MaxLCPStartDelay seconds     600 N
MaxNoOfAttributes integer 1000 32 4G N
MaxNoOfConcurrentIndexOperations integer 8K   4G N
MaxNoOfConcurrentOperations integer 32K 32 4G N
MaxNoOfConcurrentScans integer 256 2 500 N
MaxNoOfConcurrentSubOperations unsigned 256   4G N
MaxNoOfConcurrentTransactions integer 4096 32 4G S
MaxNoOfFiredTriggers integer 4000   4G N
MaxNoOfLocalOperations integer UNDEFINED 32 4G N
MaxNoOfLocalScans integer UNDEFINED 32 4G N
MaxNoOfOpenFiles integer 40 20 4G N
MaxNoOfOrderedIndexes integer 128   4G N
MaxNoOfSavedMessages integer 25   4G N
MaxNoOfSubscribers unsigned     4G N
MaxNoOfSubscriptions unsigned     4G N
MaxNoOfTables integer 128 8 20320 N
MaxNoOfTriggers integer 768   4G N
MaxNoOfUniqueHashIndexes integer 64   4G N
MemReportFrequency unsigned     4G N
NodeGroup       64K 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 integer None 1 4 IS
ODirect boolean     1 N
RealtimeScheduler   false     N
RedoBuffer bytes 8M 1M 4G N
ReservedSendBufferMemory bytes 256K   4G N
RestartOnErrorInsert error code 2   4 N
SchedulerExecutionTimer µsec 50   11000 N
SchedulerSpinTimer µsec     500 N
ServerPort unsigned   1 64K N
SharedGlobalMemory bytes 20M   64T N
StartFailureTimeout milliseconds     4G N
StartPartialTimeout milliseconds 30000   4G N
StartPartitionedTimeout milliseconds 60000   4G N
StartupStatusReportFrequency seconds       N
StopOnError true|false (1|0) true     N
StringMemory % or bytes 5   4G S
TcpBind_INADDR_ANY   false     N
TimeBetweenEpochs milliseconds 100   32000 N
TimeBetweenEpochsTimeout milliseconds 4000   32000 N
TimeBetweenGlobalCheckpoints milliseconds 2000 10 32000 N
TimeBetweenInactiveTransactionAbortCheck milliseconds 1000 1000 4G N
TimeBetweenLocalCheckpoints number of 4-byte words, as a base-2 logarithm 20   31 N
TimeBetweenWatchDogCheck milliseconds 6000 70 4G N
TimeBetweenWatchDogCheckInitial milliseconds 6000 70 4G N
TotalSendBufferMemory bytes 256K   4G N
TransactionBufferMemory bytes 1M 1K 4G N
TransactionDeadlockDetectionTimeout milliseconds 1200 50 4G N
TransactionInactiveTimeout milliseconds 4G   4G N
UndoDataBuffer unsigned 16M 1M 4G N
UndoIndexBuffer unsigned 2M 1M 4G 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.11, “Adding MySQL Cluster Data Nodes Online”.


User Comments

Posted by Andy H on March 30 2010 6:28pm[Delete] [Edit]

Here is the key for the restart types:

N = Node Restart (i.e. rolling restart of all nodes
IN = Initial Node Restart ( rolling restart of all nodes with --initial option to clear out the ndbfs )
S = System Restart (Shutdown all nodes and start all nodes at once)
IS = Initial System Restart (Shutdown all node and start all nodes with --initial to clear out the ndbfs)

The last one basically cleans out all data in the cluster all others preserve the data.


Add your own comment.