Skip navigation links
MySQL Cluster :: 3 MySQL Cluster Configuration :: 3.3 Overview of MySQL Cluster Configuration Parameters :: 3.3.1 MySQL Cluster Data Node Configuration Parameters
3.3.2 MySQL Cluster Management Node Configuration Parameters »
Section Navigation      [Toggle]

3.3.1. MySQL Cluster Data Node Configuration Parameters

The summary table in this section 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 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 4.3, “ndbmtd — The MySQL Cluster Data Node Daemon (Multi-Threaded)”.

Restart types.  Changes in MySQL Cluster configuration parameters do not take effect until the cluster is restarted. The type of restart required to change a given parameter is indicated in the summary table as follows:

For more information about restart types, see Section 3.3, “Overview of MySQL Cluster Configuration Parameters”.

Table 3.1. Data Node Configuration Parameters

Name Type/Units Default Min Value Max Value Restart Type
Arbitration {Disabled|Default|WaitExternal} Default     N
ArbitrationTimeout milliseconds 3000 10 4G N
BackupDataBufferSize bytes 2M   4G N
BackupDataDir path FileSystemPath     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
BuildIndexThreads       128  
CompressedBackup   false     N
CompressedLCP   false     N
ConnectCheckIntervalDelay   1500   4G N
CrashOnCorruptedTuple   OFF      
DataDir path .     IN
DataMemory bytes 80M 1M 1024G N
DictTrace bytes undefined   100 N
DiskCheckpointSpeed bytes 10M 1M 4G N
DiskCheckpointSpeedInRestart bytes 100M 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
ExtraSendBufferMemory bytes     32G N
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
HeartbeatOrder       65535 S
HostName name or IP address localhost     S
Id unsigned   1 48 N
IndexMemory bytes 18M 1M 1T N
InitFragmentLogFiles sparse|full       IN
InitialLogFileGroup   [see documentation]     S
InitialNoOfOpenFiles files 27 20 4G N
InitialTablespace   [see documentation]     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
MaxDMLOperationsPerTransaction operations (DML) 4294967295 32 4294967295 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
MaxParallelScansPerFragment bytes 32 1 1G N
MaxStartFailRetries unsigned 3   4G N
MemReportFrequency unsigned     4G N
MinFreePct unsigned 5   100 N
NodeGroup       65536 IS
NodeId unsigned   1 48 N
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
Numa         N
ODirect boolean     1 N
RealtimeScheduler   false     N
RedoBuffer bytes 8M 1M 4G N
RedoOverCommitCounter   3   4G N
RedoOverCommitLimit seconds 20   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
StartFailRetryDelay unsigned     4G N
StartFailureTimeout milliseconds     4G N
StartNoNodeGroupTimeout milliseconds 15000   4294967039 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
ThreadConfig   [none]     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
TwoPassInitialNodeRestart   FALSE     N
UndoDataBuffer unsigned 16M 1M 4G N
UndoIndexBuffer unsigned 2M 1M 4G N
Note

Prior to MySQL Cluster NDB 7.0, 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, starting all data node processes using the --initial option—that is, you must perform a system restart.

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 5.12, “Adding MySQL Cluster Data Nodes Online”.

Copyright © 1997, 2012, Oracle and/or its affiliates. All rights reserved. Legal Notices