Appendix C. Attribute Summary Tables

This appendix provides tables of configuration attributes, grouped according to their process type or the section of the MySQL Cluster configuration file in which they appear.

Each table provides the following information:

Table C.1. Management Node Configuration Parameters

NameType/UnitsDefaultMin ValueMax ValueRestart Type
ArbitrationDelaymilliseconds  4GN
ArbitrationRank0-21 2N
DataDirpath.  N
ExecuteOnComputername   S
ExtraSendBufferMemorybytes  32GN
HeartbeatThreadPriority     
HostNamename or IP address   S
Idunsigned 163IS
LogDestination{CONSOLE|SYSLOG|FILE}FILE: filename=ndb_nodeid_cluster.log, maxsize=1000000, maxfiles=6  N
MaxNoOfSavedEventsunsigned100 4GN
NodeIdunsigned 163IS
PortNumberunsigned1186 64KN
PortNumberStatsunsigned  64KN
TotalSendBufferMemorybytes256K 4GN
wan false  N

Table C.2. Data Node Configuration Parameters

NameType/UnitsDefaultMin ValueMax ValueRestart Type
Arbitration Default  N
ArbitrationTimeoutmilliseconds3000104GN
BackupDataBufferSizebytes2M 4GN
BackupDataDirpathFileSystemPath  IN
BackupLogBufferSizebytes2M 4GN
BackupMaxWriteSizebytes1M2K4GN
BackupMemorybytes4M 4GN
BackupReportFrequencyseconds  4GN
BackupWriteSizebytes32K2K4GN
BatchSizePerLocalScaninteger641992N
BuildIndexThreads   128 
CompressedBackup false  N
CompressedLCP false  N
ConnectCheckIntervalDelay 1500 4GN
CrashOnCorruptedTuple false   
DataDirpath.  IN
DataMemorybytes80M1M1024GN
DefaultHashMapSizeLDM threads240 3840N
DictTracebytesundefined 100N
DiskCheckpointSpeedbytes10M1M4GN
DiskCheckpointSpeedInRestartbytes100M1M4GN
DiskIOThreadPoolthreads8 4GN
Disklesstrue|false (1|0)false  IS
DiskPageBufferMemorybytes64M4M1TN
DiskSyncSizebytes4M32K4GN
ExecuteOnComputername   S
ExtraSendBufferMemorybytes  32GN
FileSystemPathpathDataDir  IN
FileSystemPathDataFiles FileSystemPathDD  IN
FileSystemPathDD FileSystemPath  IN
FileSystemPathUndoFiles FileSystemPathDD  IN
FragmentLogFileSizebytes16M4M1GIN
HeartbeatIntervalDbApimilliseconds15001004GN
HeartbeatIntervalDbDbmilliseconds1500104GN
HeartbeatOrder   65535S
HostNamename or IP addresslocalhost  S
Idunsigned 148IS
IndexMemorybytes18M1M1TN
InitFragmentLogFiles[see values]SPARSE  IN
InitialLogFileGroup [see documentation]  S
InitialNoOfOpenFilesfiles27204GN
InitialTablespace [see documentation]  S
IOThreadPoolthreads8 4GN
LockExecuteThreadToCPUCPU ID64K 64KN
LockMaintThreadsToCPUCPU ID64K 64KN
LockPagesInMainMemory   2N
LogLevelCheckpointlog level  15N
LogLevelCongestionlevelr  15N
LogLevelConnectioninteger  15N
LogLevelErrorinteger  15N
LogLevelInfointeger  15N
LogLevelNodeRestartinteger  15N
LogLevelShutdowninteger  15N
LogLevelStartupinteger1 15N
LogLevelStatisticinteger  15N
LongMessageBufferbytes1M512K4GN
MaxAllocateunsigned32M1M1GN
MaxBufferedEpochBytesbytes2621440026214400 (0x01900000)4294967039 (0xFFFFFEFF)N
MaxBufferedEpochsepochs100 100000N
MaxDMLOperationsPerTransactionoperations (DML)4294967295324294967295N
MaxLCPStartDelayseconds  600N
MaxNoOfAttributesinteger1000324GN
MaxNoOfConcurrentIndexOperationsinteger8K 4GN
MaxNoOfConcurrentOperationsinteger32K324GN
MaxNoOfConcurrentScansinteger2562500N
MaxNoOfConcurrentSubOperationsunsigned256 4GN
MaxNoOfConcurrentTransactionsinteger4096324GS
MaxNoOfFiredTriggersinteger4000 4GN
MaxNoOfLocalOperationsintegerUNDEFINED324GN
MaxNoOfLocalScansintegerUNDEFINED324GN
MaxNoOfOpenFilesunsigned 204GN
MaxNoOfOrderedIndexesinteger128 4GN
MaxNoOfSavedMessagesinteger25 4GN
MaxNoOfSubscribersunsigned  4GN
MaxNoOfSubscriptionsunsigned  4GN
MaxNoOfTablesinteger128820320N
MaxNoOfTriggersinteger768 4GN
MaxNoOfUniqueHashIndexesinteger64 4GN
MaxParallelScansPerFragmentbytes3211GN
MaxStartFailRetriesunsigned3 4GN
MemReportFrequencyunsigned  4GN
MinFreePctunsigned5 100N
NodeGroup   65536IS
NodeIdunsigned 148IS
NoOfFragmentLogFilesinteger1634GIN
NoOfReplicasinteger 14IS
Numa 1  N
ODirect false  N
RealtimeScheduler false  N
RedoBufferbytes8M1M4GN
RedoOverCommitCounter 3 4GN
RedoOverCommitLimitseconds20 4GN
ReservedSendBufferMemorybytes256K 4GN
RestartOnErrorInserterror code2 4N
SchedulerExecutionTimerµsec50 11000N
SchedulerSpinTimerµsec  500N
ServerPortunsigned 164KN
SharedGlobalMemorybytes20M 64TN
StartFailRetryDelayunsigned  4GN
StartFailureTimeoutmilliseconds  4GN
StartNoNodeGroupTimeoutmilliseconds15000 4294967039N
StartPartialTimeoutmilliseconds30000 4GN
StartPartitionedTimeoutmilliseconds60000 4GN
StartupStatusReportFrequencyseconds   N
StopOnError true  N
StringMemory% or bytes25 4GS
TcpBind_INADDR_ANY false  N
TimeBetweenEpochsmilliseconds100 32000N
TimeBetweenEpochsTimeoutmilliseconds4000 256000N
TimeBetweenGlobalCheckpointsmilliseconds20001032000N
TimeBetweenInactiveTransactionAbortCheckmilliseconds100010004GN
TimeBetweenLocalCheckpointsnumber of 4-byte words, as a base-2 logarithm20 31N
TimeBetweenWatchDogCheckmilliseconds6000704GN
TimeBetweenWatchDogCheckInitialmilliseconds6000704GN
TotalSendBufferMemorybytes256K 4GN
TransactionBufferMemorybytes1M1K4GN
TransactionDeadlockDetectionTimeoutmilliseconds1200504GN
TransactionInactiveTimeoutmilliseconds4G 4GN
TwoPassInitialNodeRestartCopy false  N
UndoDataBufferunsigned16M1M4GN
UndoIndexBufferunsigned2M1M4GN

Table C.3. API Node Configuration Parameters

NameType/UnitsDefaultMin ValueMax ValueRestart Type
ArbitrationDelaymilliseconds  4GN
ArbitrationRank0-2  2N
AutoReconnect false  N
BatchByteSizebytes32K10241MN
BatchSizerecords641992N
ConnectionMap    N
DefaultHashMapSizeLDM threads240 3840N
DefaultOperationRedoProblemAction ABORT   
ExecuteOnComputername   S
ExtraSendBufferMemorybytes  32GN
HeartbeatThreadPriority     
HostNamename or IP address   S
Idunsigned 163IS
MaxScanBatchSizebytes256K32K16MN
NodeIdunsigned 163IS
TotalSendBufferMemorybytes256K 4GN
wan false  N

Table C.4. MySQL Server Option and Variable Reference for MySQL Cluster

NameCmd-LineOption fileSystem VarStatus VarVar ScopeDynamic
Com_show_ndb_status   YesBothNo
Handler_discover   YesBothNo
have_ndbcluster  Yes GlobalNo
Ndb_api_bytes_received_count   YesGlobalNo
Ndb_api_bytes_received_count_session   YesSessionNo
Ndb_api_bytes_received_count_slave   YesGlobalNo
Ndb_api_bytes_sent_count   YesGlobalNo
Ndb_api_bytes_sent_count_session   YesSessionNo
Ndb_api_bytes_sent_count_slave   YesGlobalNo
Ndb_api_event_bytes_count   YesGlobalNo
Ndb_api_event_bytes_count_injector   YesGlobalNo
Ndb_api_event_data_count   YesGlobalNo
Ndb_api_event_data_count_injector   YesGlobalNo
Ndb_api_event_nondata_count   YesGlobalNo
Ndb_api_event_nondata_count_injector   YesGlobalNo
Ndb_api_pk_op_count   YesGlobalNo
Ndb_api_pk_op_count_session   YesSessionNo
Ndb_api_pk_op_count_slave   YesGlobalNo
Ndb_api_pruned_scan_count   YesGlobalNo
Ndb_api_pruned_scan_count_session   YesSessionNo
Ndb_api_pruned_scan_count_slave   YesGlobalNo
Ndb_api_range_scan_count   YesGlobalNo
Ndb_api_range_scan_count_session   YesSessionNo
Ndb_api_range_scan_count_slave   YesGlobalNo
Ndb_api_read_row_count   YesGlobalNo
Ndb_api_read_row_count_session   YesSessionNo
Ndb_api_read_row_count_slave   YesGlobalNo
Ndb_api_scan_batch_count   YesGlobalNo
Ndb_api_scan_batch_count_session   YesSessionNo
Ndb_api_scan_batch_count_slave   YesGlobalNo
Ndb_api_table_scan_count   YesGlobalNo
Ndb_api_table_scan_count_session   YesSessionNo
Ndb_api_table_scan_count_slave   YesGlobalNo
Ndb_api_trans_abort_count   YesGlobalNo
Ndb_api_trans_abort_count_session   YesSessionNo
Ndb_api_trans_abort_count_slave   YesGlobalNo
Ndb_api_trans_close_count   YesGlobalNo
Ndb_api_trans_close_count_session   YesSessionNo
Ndb_api_trans_close_count_slave   YesGlobalNo
Ndb_api_trans_commit_count   YesGlobalNo
Ndb_api_trans_commit_count_session   YesSessionNo
Ndb_api_trans_commit_count_slave   YesGlobalNo
Ndb_api_trans_local_read_row_count   YesGlobalNo
Ndb_api_trans_local_read_row_count_session   YesSessionNo
Ndb_api_trans_local_read_row_count_slave   YesGlobalNo
Ndb_api_trans_start_count   YesGlobalNo
Ndb_api_trans_start_count_session   YesSessionNo
Ndb_api_trans_start_count_slave   YesGlobalNo
Ndb_api_uk_op_count   YesGlobalNo
Ndb_api_uk_op_count_session   YesSessionNo
Ndb_api_uk_op_count_slave   YesGlobalNo
Ndb_api_wait_exec_complete_count   YesGlobalNo
Ndb_api_wait_exec_complete_count_session   YesSessionNo
Ndb_api_wait_exec_complete_count_slave   YesGlobalNo
Ndb_api_wait_meta_request_count   YesGlobalNo
Ndb_api_wait_meta_request_count_session   YesSessionNo
Ndb_api_wait_meta_request_count_slave   YesGlobalNo
Ndb_api_wait_nanos_count   YesGlobalNo
Ndb_api_wait_nanos_count_session   YesSessionNo
Ndb_api_wait_nanos_count_slave   YesGlobalNo
Ndb_api_wait_scan_result_count   YesGlobalNo
Ndb_api_wait_scan_result_count_session   YesSessionNo
Ndb_api_wait_scan_result_count_slave   YesGlobalNo
ndb_autoincrement_prefetch_szYesYesYes BothYes
ndb-batch-sizeYesYesYes GlobalNo
ndb-blob-read-batch-bytesYesYesYes BothYes
ndb-blob-write-batch-bytesYesYesYes BothYes
ndb_cache_check_timeYesYesYes GlobalYes
ndb-cluster-connection-poolYesYesYesYesGlobalNo
Ndb_cluster_node_id   YesBothNo
Ndb_config_from_host   YesBothNo
Ndb_config_from_port   YesBothNo
Ndb_conflict_fn_epoch   YesGlobalNo
Ndb_conflict_fn_epoch_trans   YesGlobalNo
Ndb_conflict_fn_max   YesGlobalNo
Ndb_conflict_fn_old   YesGlobalNo
Ndb_conflict_trans_conflict_commit_count   YesGlobalNo
Ndb_conflict_trans_detect_iter_count   YesGlobalNo
Ndb_conflict_trans_reject_count   YesGlobalNo
Ndb_conflict_trans_row_conflict_count   YesGlobalNo
Ndb_conflict_trans_row_reject_count   YesGlobalNo
ndb-connectstringYesYes    
ndb-deferred-constraintsYesYes  BothYes
- Variable: ndb_deferred_constraints  Yes BothYes
ndb_deferred_constraintsYesYesYes BothYes
ndb_distributionYesYesYes BothYes
ndb-distributionYesYes  BothYes
- Variable: ndb_distribution  Yes BothYes
ndb_execute_count   YesGlobalNo
ndb_extra_loggingYesYesYes GlobalYes
ndb_force_sendYesYesYes BothYes
ndb_index_stat_cache_entriesYesYes    
ndb_index_stat_enableYesYes    
ndb_index_stat_update_freqYesYes    
ndb_join_pushdown  Yes GlobalNo
ndb-log-apply-statusYesYes  GlobalNo
- Variable: ndb_log_apply_status  Yes GlobalNo
ndb_log_binYes Yes BothYes
ndb_log_binlog_indexYes Yes GlobalYes
ndb_log_empty_epochsYesYesYes GlobalYes
ndb-log-empty-epochsYesYesYes GlobalYes
ndb-log-origYesYes  GlobalNo
- Variable: ndb_log_orig  Yes GlobalNo
ndb-log-transaction-idYesYes  GlobalNo
- Variable: ndb_log_transaction_id  Yes GlobalNo
ndb_log_transaction_id  Yes GlobalNo
ndb-log-update-as-writeYesYesYes GlobalYes
ndb_log_updated_onlyYesYesYes GlobalYes
ndb-mgmd-hostYesYes    
ndb-nodeidYesYes YesGlobalNo
Ndb_number_of_data_nodes   YesGlobalNo
ndb_optimization_delay  Yes GlobalYes
ndb_optimized_node_selectionYesYes    
ndb_pruned_scan_count   YesGlobalNo
Ndb_pushed_queries_defined   YesGlobalNo
Ndb_pushed_queries_dropped   YesGlobalNo
Ndb_pushed_queries_executed   YesGlobalNo
ndb_pushed_reads   YesGlobalNo
ndb_report_thresh_binlog_epoch_slipYesYes    
ndb_report_thresh_binlog_mem_usageYesYes    
ndb_scan_count   YesGlobalNo
ndb_table_no_logging  Yes SessionYes
ndb_table_temporary  Yes SessionYes
ndb-transid-mysql-connection-mapYes     
ndb_use_copying_alter_table  Yes BothNo
ndb_use_exact_count  Yes BothYes
ndb_use_transactionsYesYesYes BothYes
ndb-wait-connectedYesYesYes GlobalNo
ndb-wait-setupYesYesYes GlobalNo
ndbclusterYesYes    
- Variable: have_ndbcluster      
ndbinfo_database  Yes GlobalNo
ndbinfo_max_bytesYes Yes BothYes
ndbinfo_max_rowsYes Yes BothYes
ndbinfo_show_hiddenYes Yes BothYes
ndbinfo_table_prefixYes Yes BothYes
ndbinfo_version  Yes GlobalNo
server-id-bitsYesYes  GlobalNo
- Variable: server_id_bits  Yes GlobalNo
skip-ndbclusterYesYes    
transaction_allow_batching  Yes SessionYes

Table C.5. COMPUTER Configuration Parameters

NameType/UnitsDefaultMin ValueMax ValueRestart Type
HostNamename or IP address   S
Idstring   IS

Table C.6. TCP Configuration Parameters

NameType/UnitsDefaultMin ValueMax ValueRestart Type
Checksum false  N
Groupunsigned55 200N
NodeId1    N
NodeId2    N
NodeIdServer    N
OverloadLimitbytes  4GN
PortNumberunsigned  64KN
Proxy    N
ReceiveBufferMemorybytes64K16K4GN
SendBufferMemoryunsigned256K64K4GN
SendSignalId false (debug builds: true)  N
TCP_MAXSEG_SIZEunsigned  2GN
TCP_RCV_BUF_SIZEunsigned7008012GN
TCP_SND_BUF_SIZEunsigned7154012GN
TcpBind_INADDR_ANY false  N

Table C.7. SHM Configuration Parameters

NameType/UnitsDefaultMin ValueMax ValueRestart Type
Checksum true  N
Groupunsigned35 200N
NodeId1    N
NodeId2    N
NodeIdServer    N
OverloadLimitbytes  4GN
PortNumberunsigned  64KN
SendSignalId false  N
ShmKeyunsigned  4GN
ShmSizebytes1M64K4GN
Signumunsigned  4GN

Table C.8. SCI Configuration Parameters

NameType/UnitsDefaultMin ValueMax ValueRestart Type
Checksum false  N
Groupunsigned15 200N
Host1SciId0unsigned  4GN
Host1SciId1unsigned  4GN
Host2SciId0unsigned  4GN
Host2SciId1unsigned  4GN
NodeId1    N
NodeId2    N
NodeIdServer    N
OverloadLimitbytes  4GN
PortNumberunsigned  64KN
SendLimitunsigned8K12832KN
SendSignalId true  N
SharedBufferSizeunsigned10M64K4GN