****** SYSTEM ****** Name (String) Name of system (NDB Cluster) MANDATORY PrimaryMGMNode (Non-negative Integer) Node id of Primary ndb_mgmd(MGM) node Default: 0 (Min: 0, Max: 4294967039) ConfigGenerationNumber (Non-negative Integer) Configuration generation number Default: 0 (Min: 0, Max: 4294967039) ****** DB ****** MaxNoOfSubscriptions (Non-negative Integer) Max no of subscriptions (default 0 == MaxNoOfTables) Default: 0 (Min: 0, Max: 4294967039) MaxNoOfSubscribers (Non-negative Integer) Max no of subscribers (default 0 == 2 * MaxNoOfTables) Default: 0 (Min: 0, Max: 4294967039) MaxNoOfConcurrentSubOperations (Non-negative Integer) Max no of concurrent subscriber operations Default: 256 (Min: 0, Max: 4294967039) TcpBind_INADDR_ANY (Boolean value) Bind IP_ADDR_ANY so that connections can be made from anywhere (for autogenerated connections) Default: N (Legal values: Y, N) HostName (String) Name of computer for this node Default: localhost NodeId (Non-negative Integer) Number identifying the database node (ndbd(DB)) MANDATORY (Min: 1, Max: 48) ServerPort (Non-negative Integer) Port used to setup transporter for incoming connections from API nodes (Min: 1, Max: 65535) NoOfReplicas (Non-negative Integer) Number of copies of all data in the database (1-4) Default: 2 (Min: 1, Max: 4) system, initial MaxNoOfAttributes (Non-negative Integer) Total number of attributes stored in database. I.e. sum over all tables Default: 1000 (Min: 32, Max: 4294967039) MaxNoOfTables (Non-negative Integer) Total number of tables stored in the database Default: 128 (Min: 8, Max: 20320) MaxNoOfOrderedIndexes (Non-negative Integer) Total number of ordered indexes that can be defined in the system Default: 128 (Min: 0, Max: 4294967039) MaxNoOfUniqueHashIndexes (Non-negative Integer) Total number of unique hash indexes that can be defined in the system Default: 64 (Min: 0, Max: 4294967039) MaxNoOfConcurrentIndexOperations (Non-negative Integer) Total number of index operations that can execute simultaneously on one ndbd(DB) node Default: 8192 (Min: 0, Max: 4294967039) MaxNoOfTriggers (Non-negative Integer) Total number of triggers that can be defined in the system Default: 768 (Min: 0, Max: 4294967039) MaxNoOfFiredTriggers (Non-negative Integer) Total number of triggers that can fire simultaneously in one ndbd(DB) node Default: 4000 (Min: 0, Max: 4294967039) ExecuteOnComputer (String) String referencing an earlier defined COMPUTER MaxNoOfSavedMessages (Non-negative Integer) Max number of error messages in error log and max number of trace files Default: 25 (Min: 0, Max: 4294967039) LockExecuteThreadToCPU (String) CPU list indicating which CPU will run the execution thread(s) LockMaintThreadsToCPU (Non-negative Integer) CPU ID indicating which CPU will run the maintenance threads (Min: 0, Max: 65535) RealtimeScheduler (Boolean value) If yes, then NDB Cluster threads will be scheduled as real-time threads Default: N (Legal values: Y, N) LockPagesInMainMemory (Non-negative Integer) If set to yes, then NDB Cluster data will not be swapped out to disk Default: 0 (Min: 0, Max: 2) TimeBetweenWatchDogCheck (Non-negative Integer) Time between execution checks inside a database node Default: 6000 (Min: 70, Max: 4294967039) SchedulerExecutionTimer (Non-negative Integer) Number of microseconds to execute in scheduler before sending Default: 50 (Min: 0, Max: 11000) SchedulerSpinTimer (Non-negative Integer) Number of microseconds to execute in scheduler before sleeping Default: 0 (Min: 0, Max: 500) TimeBetweenWatchDogCheckInitial (Non-negative Integer) Time between execution checks inside a database node in the early start phases when memory is allocated Default: 6000 (Min: 70, Max: 4294967039) StopOnError (Boolean value) If set to N, ndbd(DB) automatically restarts/recovers in case of node failure Default: Y (Legal values: Y, N) MaxNoOfConcurrentOperations (Non-negative Integer) Max number of operation records in transaction coordinator Default: 32768 (Min: 32, Max: 4294967039) MaxDMLOperationsPerTransaction (Non-negative Integer) Max DML-operations in one transaction (0 == no limit) Default: 4294967295 (Min: 32, Max: 4294967295) MaxNoOfLocalOperations (Non-negative Integer) Max number of operation records defined in the local storage node (Min: 32, Max: 4294967039) MaxNoOfLocalScans (Non-negative Integer) Max number of fragment scans in parallel in the local storage node (Min: 32, Max: 4294967039) BatchSizePerLocalScan (Non-negative Integer) Used to calculate the number of lock records for scan with hold lock Default: 256 (Min: 1, Max: 992) MaxNoOfConcurrentTransactions (Non-negative Integer) Max number of transaction executing concurrently on the ndbd(DB) node Default: 4096 (Min: 32, Max: 4294967039) MaxNoOfConcurrentScans (Non-negative Integer) Max number of scans executing concurrently on the ndbd(DB) node Default: 256 (Min: 2, Max: 500) TransactionBufferMemory (Non-negative Integer) Dynamic buffer space (in bytes) for key and attribute data allocated for each ndbd(DB) node Default: 1048576 (Min: 1024, Max: 4294967039) IndexMemory (Non-negative Integer) Number bytes on each ndbd(DB) node allocated for storing indexes Default: 18874368 (Min: 1048576, Max: 1099511627776) DataMemory (Non-negative Integer) Number bytes on each ndbd(DB) node allocated for storing data Default: 83886080 (Min: 1048576, Max: 1099511627776) UndoIndexBuffer (Non-negative Integer) Number bytes on each ndbd(DB) node allocated for writing UNDO logs for index part Default: 2097152 (Min: 1048576, Max: 4294967039) UndoDataBuffer (Non-negative Integer) Number bytes on each ndbd(DB) node allocated for writing UNDO logs for data part Default: 16777216 (Min: 1048576, Max: 4294967039) RedoBuffer (Non-negative Integer) Number bytes on each ndbd(DB) node allocated for writing REDO logs Default: 33554432 (Min: 1048576, Max: 4294967039) LongMessageBuffer (Non-negative Integer) Number bytes on each ndbd(DB) node allocated for internal long messages Default: 4194304 (Min: 524288, Max: 4294967039) DiskPageBufferMemory (Non-negative Integer) Number bytes on each ndbd(DB) node allocated for disk page buffer cache Default: 67108864 (Min: 4194304, Max: 1099511627776) SharedGlobalMemory (Non-negative Integer) Total number bytes on each ndbd(DB) node allocated for any use Default: 134217728 (Min: 0, Max: 70368744177664) StartPartialTimeout (Non-negative Integer) Time to wait before trying to start wo/ all nodes. 0=Wait forever Default: 30000 (Min: 0, Max: 4294967039) StartPartitionedTimeout (Non-negative Integer) Time to wait before trying to start partitioned. 0=Wait forever Default: 60000 (Min: 0, Max: 4294967039) StartFailureTimeout (Non-negative Integer) Time to wait before terminating. 0=Wait forever Default: 0 (Min: 0, Max: 4294967039) StartNoNodegroupTimeout (Non-negative Integer) Time to wait for nodes wo/ nodegroup before trying to start (0=forever) Default: 15000 (Min: 0, Max: 4294967039) HeartbeatIntervalDbDb (Non-negative Integer) Time between ndbd(DB)-ndbd(DB) heartbeats. ndbd(DB) considered dead after 3 missed HBs Default: 5000 (Min: 10, Max: 4294967039) ConnectCheckIntervalDelay (Non-negative Integer) Time between ndbd(DB) connectivity check stages. ndbd(DB) considered suspect after 1 and dead after 2 intervals. Default: 0 (Min: 0, Max: 4294967039) HeartbeatIntervalDbApi (Non-negative Integer) Time between mysqld(API)-ndbd(DB) heartbeats. mysqld(API) connection closed after 3 missed HBs Default: 1500 (Min: 100, Max: 4294967039) TimeBetweenLocalCheckpoints (Non-negative Integer) Time between taking snapshots of the database (expressed in 2log of bytes) Default: 20 (Min: 0, Max: 31) TimeBetweenGlobalCheckpoints (Non-negative Integer) Time between doing group commit of transactions to disk Default: 2000 (Min: 20, Max: 32000) TimeBetweenEpochs (Non-negative Integer) Time between epochs (syncronization used e.g for replication) Default: 100 (Min: 0, Max: 32000) TimeBetweenEpochsTimeout (Non-negative Integer) Timeout for time between epochs. Exceeding will cause node shutdown. Default: 0 (Min: 0, Max: 256000) MaxBufferedEpochs (Non-negative Integer) Allowed numbered of epochs that a subscribing node can lag behind (unprocessed epochs). Exceeding will cause lagging subscribers to be disconnected. Default: 100 (Min: 1, Max: 100000) MaxBufferedEpochBytes (Non-negative Integer) Total number of bytes allocated for buffering epochs. Default: 26214400 (Min: 26214400, Max: 4294967039) NoOfFragmentLogParts (Non-negative Integer) Number of file groups of redo log files belonging to ndbd(DB) node Default: 4 (Min: 4, Max: 16) initial NoOfFragmentLogFiles (Non-negative Integer) No of Redo log files in each of the file group belonging to ndbd(DB) node Default: 16 (Min: 3, Max: 4294967039) initial FragmentLogFileSize (Non-negative Integer) Size of each Redo log file Default: 16777216 (Min: 4194304, Max: 1073741824) initial InitFragmentLogFiles (String) Initialize fragment logfiles (sparse/full) Default: sparse initial DiskIOThreadPool (Non-negative Integer) No of unbound threads for file access (currently only for DD) Default: 2 (Min: 0, Max: 4294967039) MaxNoOfOpenFiles (Non-negative Integer) Max number of files open per ndbd(DB) node.(One thread is created per file) (Min: 20, Max: 4294967039) InitialNoOfOpenFiles (Non-negative Integer) Initial number of files open per ndbd(DB) node.(One thread is created per file) Default: 27 (Min: 20, Max: 4294967039) TimeBetweenInactiveTransactionAbortCheck (Non-negative Integer) Time between inactive transaction checks Default: 1000 (Min: 1000, Max: 4294967039) TransactionInactiveTimeout (Non-negative Integer) Time application can wait before executing another transaction part (ms). This is the time the transaction coordinator waits for the application to execute or send another part (query, statement) of the transaction. If the application takes too long time, the transaction gets aborted. Timeout set to 0 means that we don't timeout at all on application wait. Default: 4294967039 (Min: 0, Max: 4294967039) TransactionDeadlockDetectionTimeout (Non-negative Integer) Time transaction can be executing in a DB node (ms). This is the time the transaction coordinator waits for each database node of the transaction to execute a request. If the database node takes too long time, the transaction gets aborted. Default: 1200 (Min: 50, Max: 4294967039) Diskless (Boolean value) Run wo/ disk Default: N (Legal values: Y, N) system, initial ArbitrationTimeout (Non-negative Integer) Max time (milliseconds) database partion waits for arbitration signal Default: 7500 (Min: 10, Max: 4294967039) Arbitration (String) How to perform arbitration to avoid split-brain issue when node(s) fail Default: Default DataDir (String) Data directory for this node Default: . writable, initial FileSystemPath (String) Path to directory where the ndbd(DB) node stores its data (directory must exist) writable, initial LogLevelStartup (Non-negative Integer) Node startup info printed on stdout Default: 1 (Min: 0, Max: 15) LogLevelShutdown (Non-negative Integer) Node shutdown info printed on stdout Default: 0 (Min: 0, Max: 15) LogLevelStatistic (Non-negative Integer) Transaction, operation, transporter info printed on stdout Default: 0 (Min: 0, Max: 15) LogLevelCheckpoint (Non-negative Integer) Local and Global checkpoint info printed on stdout Default: 0 (Min: 0, Max: 15) LogLevelNodeRestart (Non-negative Integer) Node restart, node failure info printed on stdout Default: 0 (Min: 0, Max: 15) LogLevelConnection (Non-negative Integer) Node connect/disconnect info printed on stdout Default: 0 (Min: 0, Max: 15) LogLevelCongestion (Non-negative Integer) Congestion info printed on stdout Default: 0 (Min: 0, Max: 15) LogLevelError (Non-negative Integer) Transporter, heartbeat errors printed on stdout Default: 0 (Min: 0, Max: 15) LogLevelInfo (Non-negative Integer) Heartbeat and log info printed on stdout Default: 0 (Min: 0, Max: 15) BackupDataDir (String) Path to where to store backups writable, initial DiskSyncSize (Non-negative Integer) Data written to a file before a synch is forced Default: 4194304 (Min: 32768, Max: 4294967039) DiskCheckpointSpeed (Non-negative Integer) Bytes per second allowed to be written by checkpoint Default: 10485760 (Min: 1048576, Max: 4294967039) DiskCheckpointSpeedInRestart (Non-negative Integer) Bytes per second allowed to be written by checkpoint during restart Default: 104857600 (Min: 1048576, Max: 4294967039) BackupMemory (Non-negative Integer) Total memory allocated for backups per node (in bytes) Default: 33554432 (Min: 0, Max: 4294967039) BackupDataBufferSize (Non-negative Integer) Default size of databuffer for a backup (in bytes) Default: 16777216 (Min: 0, Max: 4294967039) BackupLogBufferSize (Non-negative Integer) Default size of logbuffer for a backup (in bytes) Default: 16777216 (Min: 0, Max: 4294967039) BackupWriteSize (Non-negative Integer) Default size of filesystem writes made by backup (in bytes) Default: 262144 (Min: 2048, Max: 4294967039) BackupMaxWriteSize (Non-negative Integer) Max size of filesystem writes made by backup (in bytes) Default: 1048576 (Min: 2048, Max: 4294967039) StringMemory (Non-negative Integer) Default size of string memory (1-100 -> %of max, >100 -> actual bytes) Default: 25 (Min: 0, Max: 4294967039) MaxAllocate (Non-negative Integer) Maximum size of allocation to use when allocating memory for tables Default: 33554432 (Min: 1048576, Max: 1073741824) MemReportFrequency (Non-negative Integer) Frequency of mem reports in seconds, 0 = only when passing %-limits Default: 0 (Min: 0, Max: 4294967039) BackupReportFrequency (Non-negative Integer) Frequency of backup status reports during backup in seconds Default: 0 (Min: 0, Max: 4294967039) StartupStatusReportFrequency (Non-negative Integer) Frequency of various status reports during startup in seconds Default: 0 (Min: 0, Max: 4294967039) ODirect (Boolean value) Use O_DIRECT file write/read when possible Default: N (Legal values: Y, N) CompressedBackup (Boolean value) Use zlib to compress BACKUPs as they are written Default: N (Legal values: Y, N) CompressedLCP (Boolean value) Write compressed LCPs using zlib Default: N (Legal values: Y, N) initial ExtraSendBufferMemory (Non-negative Integer) Extra send buffer memory to use for send buffers in all transporters Default: 0 (Min: 0, Max: 34359738368) TotalSendBufferMemory (Non-negative Integer) Total memory to use for send buffers in all transporters Default: 0 (Min: 262144, Max: 4294967039) Nodegroup (Non-negative Integer) Nodegroup for node, only used during initial cluster start (Min: 0, Max: 65536) MaxNoOfExecutionThreads (Non-negative Integer) For ndbmtd, specify max no of execution threads Default: 0 (Min: 2, Max: 36) __ndbmt_lqh_workers (Non-negative Integer) For ndbmtd specify no of lqh workers (Min: 1, Max: 4) __ndbmt_lqh_threads (Non-negative Integer) For ndbmtd specify no of lqh threads (Min: 1, Max: 4) __ndbmt_classic (Boolean value) For ndbmtd use mt-classic ThreadConfig (String) Thread configuration FileSystemPathDD (String) Path to directory where the ndbd(DB) node stores its disk-data/undo-files writable, initial FileSystemPathDataFiles (String) Path to directory where the ndbd(DB) node stores its disk-data-files writable, initial FileSystemPathUndoFiles (String) Path to directory where the ndbd(DB) node stores its disk-undo-files writable, initial InitialLogfileGroup (String) Logfile group that will be created during initial start system, initial InitialTablespace (String) Tablespace that will be created during initial start system, initial MaxLCPStartDelay (Non-negative Integer) Time in seconds that LCP will poll for checkpoint mutex, before putting it self in lock-queue Default: 0 (Min: 0, Max: 600) BuildIndexThreads (Non-negative Integer) No of threads to use for building ordered indexes during system/node restart Default: 0 (Min: 0, Max: 128) HeartbeatOrder (Non-negative Integer) Heartbeat circle is ordered by the given values which must be non-zero and distinct Default: 0 (Min: 0, Max: 65535) DictTrace (Non-negative Integer) Tracelevel for ndbd's dictionary (Min: 0, Max: 100) MaxStartFailRetries (Non-negative Integer) Maximum retries when Ndbd fails in startup, requires StopOnError=0. 0 is infinite. Default: 3 (Min: 0, Max: 4294967039) StartFailRetryDelay (Non-negative Integer) Delay in seconds after start failure prior to retry. Requires StopOnError= 0 Default: 0 (Min: 0, Max: 4294967039) EventLogBufferSize (Non-negative Integer) Size of circular buffer of ndb_logevent (inside datanodes) Default: 8192 (Min: 0, Max: 65536) Numa (Non-negative Integer) Enable/disable numa support (currently linux only) Default: 1 (Min: 0, Max: 1) RedoOverCommitLimit (Non-negative Integer) Limit for how long it will take to flush current RedoBuffer before action is taken (in seconds) Default: 20 (Min: 0, Max: 4294967039) RedoOverCommitCounter (Non-negative Integer) If RedoOverCommitLimit has been reached RedoOverCommitCounter in a row times, transactions will be aborted Default: 3 (Min: 0, Max: 4294967039) LateAlloc (Non-negative Integer) Allocate memory after connection to ndb_mgmd has been established Default: 1 (Min: 0, Max: 1) TwoPassInitialNodeRestartCopy (Boolean value) Copy data in 2 passes for initial node restart, this enables multi-threaded-ordered index build for initial node restart Default: N (Legal values: Y, N) MaxParallelScansPerFragment (Non-negative Integer) Max parallel scans per fragment (tup or tux). If this limit is reached scans will be serialized using a queue. Default: 256 (Min: 1, Max: 4294967039) IndexStatAutoCreate (Non-negative Integer) Make create index also create initial index stats Default: 0 (Min: 0, Max: 1) IndexStatAutoUpdate (Non-negative Integer) Monitor each index for changes and trigger automatic stats updates. See IndexStatTrigger options Default: 0 (Min: 0, Max: 1) IndexStatSaveSize (Non-negative Integer) Maximum bytes allowed for the saved stats of one index. At least 1 sample is produced regardless of size limit. The size is scaled up by a factor from IndexStatSaveScale. The value affects size of stats saved in NDB system tables and in mysqld memory cache Default: 32768 (Min: 0, Max: 4294967039) IndexStatSaveScale (Non-negative Integer) Factor to scale up IndexStatSaveSize for a large index. Given in units of 0.01. Multiplied by a logarithmic index size. Value 0 disables scaling Default: 100 (Min: 0, Max: 4294967039) IndexStatTriggerPct (Non-negative Integer) Percent change (in DML ops) to schedule index stats update. The value is scaled down by a factor from IndexStatTriggerScale. Value 0 disables the trigger Default: 100 (Min: 0, Max: 4294967039) IndexStatTriggerScale (Non-negative Integer) Factor to scale down IndexStatTriggerPct for a large index. Given in units of 0.01. Multiplied by a logarithmic index size. Value 0 disables scaling Default: 100 (Min: 0, Max: 4294967039) IndexStatUpdateDelay (Non-negative Integer) Minimum delay in seconds between automatic index stats updates for a given index. Value 0 means no delay Default: 60 (Min: 0, Max: 4294967039) CrashOnCorruptedTuple (Boolean value) To be failfast or not, when checksum indicates corruption. Default: Y (Legal values: Y, N) MinFreePct (Non-negative Integer) Keep 5% of database free to ensure that we don't get out of memory during restart Default: 5 (Min: 0, Max: 100) DefaultHashmapSize (Non-negative Integer) Hashmap size to use for new tables. Normally this should be left unset, but can be set to aid downgrade to older versions not supporting as big hashmaps as current version or to use special hashmap size to gain better balance for some number of nodes and ldm-threads. Default: 0 (Min: 0, Max: 3840) ****** DB ****** MaxNoOfSubscriptions (Non-negative Integer) Max no of subscriptions (default 0 == MaxNoOfTables) Default: 0 (Min: 0, Max: 4294967039) MaxNoOfSubscribers (Non-negative Integer) Max no of subscribers (default 0 == 2 * MaxNoOfTables) Default: 0 (Min: 0, Max: 4294967039) MaxNoOfConcurrentSubOperations (Non-negative Integer) Max no of concurrent subscriber operations Default: 256 (Min: 0, Max: 4294967039) TcpBind_INADDR_ANY (Boolean value) Bind IP_ADDR_ANY so that connections can be made from anywhere (for autogenerated connections) Default: N (Legal values: Y, N) HostName (String) Name of computer for this node Default: localhost NodeId (Non-negative Integer) Number identifying the database node (ndbd(DB)) MANDATORY (Min: 1, Max: 48) ServerPort (Non-negative Integer) Port used to setup transporter for incoming connections from API nodes (Min: 1, Max: 65535) NoOfReplicas (Non-negative Integer) Number of copies of all data in the database (1-4) Default: 2 (Min: 1, Max: 4) system, initial MaxNoOfAttributes (Non-negative Integer) Total number of attributes stored in database. I.e. sum over all tables Default: 1000 (Min: 32, Max: 4294967039) MaxNoOfTables (Non-negative Integer) Total number of tables stored in the database Default: 128 (Min: 8, Max: 20320) MaxNoOfOrderedIndexes (Non-negative Integer) Total number of ordered indexes that can be defined in the system Default: 128 (Min: 0, Max: 4294967039) MaxNoOfUniqueHashIndexes (Non-negative Integer) Total number of unique hash indexes that can be defined in the system Default: 64 (Min: 0, Max: 4294967039) MaxNoOfConcurrentIndexOperations (Non-negative Integer) Total number of index operations that can execute simultaneously on one ndbd(DB) node Default: 8192 (Min: 0, Max: 4294967039) MaxNoOfTriggers (Non-negative Integer) Total number of triggers that can be defined in the system Default: 768 (Min: 0, Max: 4294967039) MaxNoOfFiredTriggers (Non-negative Integer) Total number of triggers that can fire simultaneously in one ndbd(DB) node Default: 4000 (Min: 0, Max: 4294967039) ExecuteOnComputer (String) String referencing an earlier defined COMPUTER MaxNoOfSavedMessages (Non-negative Integer) Max number of error messages in error log and max number of trace files Default: 25 (Min: 0, Max: 4294967039) LockExecuteThreadToCPU (String) CPU list indicating which CPU will run the execution thread(s) LockMaintThreadsToCPU (Non-negative Integer) CPU ID indicating which CPU will run the maintenance threads (Min: 0, Max: 65535) RealtimeScheduler (Boolean value) If yes, then NDB Cluster threads will be scheduled as real-time threads Default: N (Legal values: Y, N) LockPagesInMainMemory (Non-negative Integer) If set to yes, then NDB Cluster data will not be swapped out to disk Default: 0 (Min: 0, Max: 2) TimeBetweenWatchDogCheck (Non-negative Integer) Time between execution checks inside a database node Default: 6000 (Min: 70, Max: 4294967039) SchedulerExecutionTimer (Non-negative Integer) Number of microseconds to execute in scheduler before sending Default: 50 (Min: 0, Max: 11000) SchedulerSpinTimer (Non-negative Integer) Number of microseconds to execute in scheduler before sleeping Default: 0 (Min: 0, Max: 500) TimeBetweenWatchDogCheckInitial (Non-negative Integer) Time between execution checks inside a database node in the early start phases when memory is allocated Default: 6000 (Min: 70, Max: 4294967039) StopOnError (Boolean value) If set to N, ndbd(DB) automatically restarts/recovers in case of node failure Default: Y (Legal values: Y, N) MaxNoOfConcurrentOperations (Non-negative Integer) Max number of operation records in transaction coordinator Default: 32768 (Min: 32, Max: 4294967039) MaxDMLOperationsPerTransaction (Non-negative Integer) Max DML-operations in one transaction (0 == no limit) Default: 4294967295 (Min: 32, Max: 4294967295) MaxNoOfLocalOperations (Non-negative Integer) Max number of operation records defined in the local storage node (Min: 32, Max: 4294967039) MaxNoOfLocalScans (Non-negative Integer) Max number of fragment scans in parallel in the local storage node (Min: 32, Max: 4294967039) BatchSizePerLocalScan (Non-negative Integer) Used to calculate the number of lock records for scan with hold lock Default: 256 (Min: 1, Max: 992) MaxNoOfConcurrentTransactions (Non-negative Integer) Max number of transaction executing concurrently on the ndbd(DB) node Default: 4096 (Min: 32, Max: 4294967039) MaxNoOfConcurrentScans (Non-negative Integer) Max number of scans executing concurrently on the ndbd(DB) node Default: 256 (Min: 2, Max: 500) TransactionBufferMemory (Non-negative Integer) Dynamic buffer space (in bytes) for key and attribute data allocated for each ndbd(DB) node Default: 1048576 (Min: 1024, Max: 4294967039) IndexMemory (Non-negative Integer) Number bytes on each ndbd(DB) node allocated for storing indexes Default: 18874368 (Min: 1048576, Max: 1099511627776) DataMemory (Non-negative Integer) Number bytes on each ndbd(DB) node allocated for storing data Default: 83886080 (Min: 1048576, Max: 1099511627776) UndoIndexBuffer (Non-negative Integer) Number bytes on each ndbd(DB) node allocated for writing UNDO logs for index part Default: 2097152 (Min: 1048576, Max: 4294967039) UndoDataBuffer (Non-negative Integer) Number bytes on each ndbd(DB) node allocated for writing UNDO logs for data part Default: 16777216 (Min: 1048576, Max: 4294967039) RedoBuffer (Non-negative Integer) Number bytes on each ndbd(DB) node allocated for writing REDO logs Default: 33554432 (Min: 1048576, Max: 4294967039) LongMessageBuffer (Non-negative Integer) Number bytes on each ndbd(DB) node allocated for internal long messages Default: 4194304 (Min: 524288, Max: 4294967039) DiskPageBufferMemory (Non-negative Integer) Number bytes on each ndbd(DB) node allocated for disk page buffer cache Default: 67108864 (Min: 4194304, Max: 1099511627776) SharedGlobalMemory (Non-negative Integer) Total number bytes on each ndbd(DB) node allocated for any use Default: 134217728 (Min: 0, Max: 70368744177664) StartPartialTimeout (Non-negative Integer) Time to wait before trying to start wo/ all nodes. 0=Wait forever Default: 30000 (Min: 0, Max: 4294967039) StartPartitionedTimeout (Non-negative Integer) Time to wait before trying to start partitioned. 0=Wait forever Default: 60000 (Min: 0, Max: 4294967039) StartFailureTimeout (Non-negative Integer) Time to wait before terminating. 0=Wait forever Default: 0 (Min: 0, Max: 4294967039) StartNoNodegroupTimeout (Non-negative Integer) Time to wait for nodes wo/ nodegroup before trying to start (0=forever) Default: 15000 (Min: 0, Max: 4294967039) HeartbeatIntervalDbDb (Non-negative Integer) Time between ndbd(DB)-ndbd(DB) heartbeats. ndbd(DB) considered dead after 3 missed HBs Default: 5000 (Min: 10, Max: 4294967039) ConnectCheckIntervalDelay (Non-negative Integer) Time between ndbd(DB) connectivity check stages. ndbd(DB) considered suspect after 1 and dead after 2 intervals. Default: 0 (Min: 0, Max: 4294967039) HeartbeatIntervalDbApi (Non-negative Integer) Time between mysqld(API)-ndbd(DB) heartbeats. mysqld(API) connection closed after 3 missed HBs Default: 1500 (Min: 100, Max: 4294967039) TimeBetweenLocalCheckpoints (Non-negative Integer) Time between taking snapshots of the database (expressed in 2log of bytes) Default: 20 (Min: 0, Max: 31) TimeBetweenGlobalCheckpoints (Non-negative Integer) Time between doing group commit of transactions to disk Default: 2000 (Min: 20, Max: 32000) TimeBetweenEpochs (Non-negative Integer) Time between epochs (syncronization used e.g for replication) Default: 100 (Min: 0, Max: 32000) TimeBetweenEpochsTimeout (Non-negative Integer) Timeout for time between epochs. Exceeding will cause node shutdown. Default: 0 (Min: 0, Max: 256000) MaxBufferedEpochs (Non-negative Integer) Allowed numbered of epochs that a subscribing node can lag behind (unprocessed epochs). Exceeding will cause lagging subscribers to be disconnected. Default: 100 (Min: 1, Max: 100000) MaxBufferedEpochBytes (Non-negative Integer) Total number of bytes allocated for buffering epochs. Default: 26214400 (Min: 26214400, Max: 4294967039) NoOfFragmentLogParts (Non-negative Integer) Number of file groups of redo log files belonging to ndbd(DB) node Default: 4 (Min: 4, Max: 16) initial NoOfFragmentLogFiles (Non-negative Integer) No of Redo log files in each of the file group belonging to ndbd(DB) node Default: 16 (Min: 3, Max: 4294967039) initial FragmentLogFileSize (Non-negative Integer) Size of each Redo log file Default: 16777216 (Min: 4194304, Max: 1073741824) initial InitFragmentLogFiles (String) Initialize fragment logfiles (sparse/full) Default: sparse initial DiskIOThreadPool (Non-negative Integer) No of unbound threads for file access (currently only for DD) Default: 2 (Min: 0, Max: 4294967039) MaxNoOfOpenFiles (Non-negative Integer) Max number of files open per ndbd(DB) node.(One thread is created per file) (Min: 20, Max: 4294967039) InitialNoOfOpenFiles (Non-negative Integer) Initial number of files open per ndbd(DB) node.(One thread is created per file) Default: 27 (Min: 20, Max: 4294967039) TimeBetweenInactiveTransactionAbortCheck (Non-negative Integer) Time between inactive transaction checks Default: 1000 (Min: 1000, Max: 4294967039) TransactionInactiveTimeout (Non-negative Integer) Time application can wait before executing another transaction part (ms). This is the time the transaction coordinator waits for the application to execute or send another part (query, statement) of the transaction. If the application takes too long time, the transaction gets aborted. Timeout set to 0 means that we don't timeout at all on application wait. Default: 4294967039 (Min: 0, Max: 4294967039) TransactionDeadlockDetectionTimeout (Non-negative Integer) Time transaction can be executing in a DB node (ms). This is the time the transaction coordinator waits for each database node of the transaction to execute a request. If the database node takes too long time, the transaction gets aborted. Default: 1200 (Min: 50, Max: 4294967039) Diskless (Boolean value) Run wo/ disk Default: N (Legal values: Y, N) system, initial ArbitrationTimeout (Non-negative Integer) Max time (milliseconds) database partion waits for arbitration signal Default: 7500 (Min: 10, Max: 4294967039) Arbitration (String) How to perform arbitration to avoid split-brain issue when node(s) fail Default: Default DataDir (String) Data directory for this node Default: . writable, initial FileSystemPath (String) Path to directory where the ndbd(DB) node stores its data (directory must exist) writable, initial LogLevelStartup (Non-negative Integer) Node startup info printed on stdout Default: 1 (Min: 0, Max: 15) LogLevelShutdown (Non-negative Integer) Node shutdown info printed on stdout Default: 0 (Min: 0, Max: 15) LogLevelStatistic (Non-negative Integer) Transaction, operation, transporter info printed on stdout Default: 0 (Min: 0, Max: 15) LogLevelCheckpoint (Non-negative Integer) Local and Global checkpoint info printed on stdout Default: 0 (Min: 0, Max: 15) LogLevelNodeRestart (Non-negative Integer) Node restart, node failure info printed on stdout Default: 0 (Min: 0, Max: 15) LogLevelConnection (Non-negative Integer) Node connect/disconnect info printed on stdout Default: 0 (Min: 0, Max: 15) LogLevelCongestion (Non-negative Integer) Congestion info printed on stdout Default: 0 (Min: 0, Max: 15) LogLevelError (Non-negative Integer) Transporter, heartbeat errors printed on stdout Default: 0 (Min: 0, Max: 15) LogLevelInfo (Non-negative Integer) Heartbeat and log info printed on stdout Default: 0 (Min: 0, Max: 15) BackupDataDir (String) Path to where to store backups writable, initial DiskSyncSize (Non-negative Integer) Data written to a file before a synch is forced Default: 4194304 (Min: 32768, Max: 4294967039) DiskCheckpointSpeed (Non-negative Integer) Bytes per second allowed to be written by checkpoint Default: 10485760 (Min: 1048576, Max: 4294967039) DiskCheckpointSpeedInRestart (Non-negative Integer) Bytes per second allowed to be written by checkpoint during restart Default: 104857600 (Min: 1048576, Max: 4294967039) BackupMemory (Non-negative Integer) Total memory allocated for backups per node (in bytes) Default: 33554432 (Min: 0, Max: 4294967039) BackupDataBufferSize (Non-negative Integer) Default size of databuffer for a backup (in bytes) Default: 16777216 (Min: 0, Max: 4294967039) BackupLogBufferSize (Non-negative Integer) Default size of logbuffer for a backup (in bytes) Default: 16777216 (Min: 0, Max: 4294967039) BackupWriteSize (Non-negative Integer) Default size of filesystem writes made by backup (in bytes) Default: 262144 (Min: 2048, Max: 4294967039) BackupMaxWriteSize (Non-negative Integer) Max size of filesystem writes made by backup (in bytes) Default: 1048576 (Min: 2048, Max: 4294967039) StringMemory (Non-negative Integer) Default size of string memory (1-100 -> %of max, >100 -> actual bytes) Default: 25 (Min: 0, Max: 4294967039) MaxAllocate (Non-negative Integer) Maximum size of allocation to use when allocating memory for tables Default: 33554432 (Min: 1048576, Max: 1073741824) MemReportFrequency (Non-negative Integer) Frequency of mem reports in seconds, 0 = only when passing %-limits Default: 0 (Min: 0, Max: 4294967039) BackupReportFrequency (Non-negative Integer) Frequency of backup status reports during backup in seconds Default: 0 (Min: 0, Max: 4294967039) StartupStatusReportFrequency (Non-negative Integer) Frequency of various status reports during startup in seconds Default: 0 (Min: 0, Max: 4294967039) ODirect (Boolean value) Use O_DIRECT file write/read when possible Default: N (Legal values: Y, N) CompressedBackup (Boolean value) Use zlib to compress BACKUPs as they are written Default: N (Legal values: Y, N) CompressedLCP (Boolean value) Write compressed LCPs using zlib Default: N (Legal values: Y, N) initial ExtraSendBufferMemory (Non-negative Integer) Extra send buffer memory to use for send buffers in all transporters Default: 0 (Min: 0, Max: 34359738368) TotalSendBufferMemory (Non-negative Integer) Total memory to use for send buffers in all transporters Default: 0 (Min: 262144, Max: 4294967039) Nodegroup (Non-negative Integer) Nodegroup for node, only used during initial cluster start (Min: 0, Max: 65536) MaxNoOfExecutionThreads (Non-negative Integer) For ndbmtd, specify max no of execution threads Default: 0 (Min: 2, Max: 36) __ndbmt_lqh_workers (Non-negative Integer) For ndbmtd specify no of lqh workers (Min: 1, Max: 4) __ndbmt_lqh_threads (Non-negative Integer) For ndbmtd specify no of lqh threads (Min: 1, Max: 4) __ndbmt_classic (Boolean value) For ndbmtd use mt-classic ThreadConfig (String) Thread configuration FileSystemPathDD (String) Path to directory where the ndbd(DB) node stores its disk-data/undo-files writable, initial FileSystemPathDataFiles (String) Path to directory where the ndbd(DB) node stores its disk-data-files writable, initial FileSystemPathUndoFiles (String) Path to directory where the ndbd(DB) node stores its disk-undo-files writable, initial InitialLogfileGroup (String) Logfile group that will be created during initial start system, initial InitialTablespace (String) Tablespace that will be created during initial start system, initial MaxLCPStartDelay (Non-negative Integer) Time in seconds that LCP will poll for checkpoint mutex, before putting it self in lock-queue Default: 0 (Min: 0, Max: 600) BuildIndexThreads (Non-negative Integer) No of threads to use for building ordered indexes during system/node restart Default: 0 (Min: 0, Max: 128) HeartbeatOrder (Non-negative Integer) Heartbeat circle is ordered by the given values which must be non-zero and distinct Default: 0 (Min: 0, Max: 65535) DictTrace (Non-negative Integer) Tracelevel for ndbd's dictionary (Min: 0, Max: 100) MaxStartFailRetries (Non-negative Integer) Maximum retries when Ndbd fails in startup, requires StopOnError=0. 0 is infinite. Default: 3 (Min: 0, Max: 4294967039) StartFailRetryDelay (Non-negative Integer) Delay in seconds after start failure prior to retry. Requires StopOnError= 0 Default: 0 (Min: 0, Max: 4294967039) EventLogBufferSize (Non-negative Integer) Size of circular buffer of ndb_logevent (inside datanodes) Default: 8192 (Min: 0, Max: 65536) Numa (Non-negative Integer) Enable/disable numa support (currently linux only) Default: 1 (Min: 0, Max: 1) RedoOverCommitLimit (Non-negative Integer) Limit for how long it will take to flush current RedoBuffer before action is taken (in seconds) Default: 20 (Min: 0, Max: 4294967039) RedoOverCommitCounter (Non-negative Integer) If RedoOverCommitLimit has been reached RedoOverCommitCounter in a row times, transactions will be aborted Default: 3 (Min: 0, Max: 4294967039) LateAlloc (Non-negative Integer) Allocate memory after connection to ndb_mgmd has been established Default: 1 (Min: 0, Max: 1) TwoPassInitialNodeRestartCopy (Boolean value) Copy data in 2 passes for initial node restart, this enables multi-threaded-ordered index build for initial node restart Default: N (Legal values: Y, N) MaxParallelScansPerFragment (Non-negative Integer) Max parallel scans per fragment (tup or tux). If this limit is reached scans will be serialized using a queue. Default: 256 (Min: 1, Max: 4294967039) IndexStatAutoCreate (Non-negative Integer) Make create index also create initial index stats Default: 0 (Min: 0, Max: 1) IndexStatAutoUpdate (Non-negative Integer) Monitor each index for changes and trigger automatic stats updates. See IndexStatTrigger options Default: 0 (Min: 0, Max: 1) IndexStatSaveSize (Non-negative Integer) Maximum bytes allowed for the saved stats of one index. At least 1 sample is produced regardless of size limit. The size is scaled up by a factor from IndexStatSaveScale. The value affects size of stats saved in NDB system tables and in mysqld memory cache Default: 32768 (Min: 0, Max: 4294967039) IndexStatSaveScale (Non-negative Integer) Factor to scale up IndexStatSaveSize for a large index. Given in units of 0.01. Multiplied by a logarithmic index size. Value 0 disables scaling Default: 100 (Min: 0, Max: 4294967039) IndexStatTriggerPct (Non-negative Integer) Percent change (in DML ops) to schedule index stats update. The value is scaled down by a factor from IndexStatTriggerScale. Value 0 disables the trigger Default: 100 (Min: 0, Max: 4294967039) IndexStatTriggerScale (Non-negative Integer) Factor to scale down IndexStatTriggerPct for a large index. Given in units of 0.01. Multiplied by a logarithmic index size. Value 0 disables scaling Default: 100 (Min: 0, Max: 4294967039) IndexStatUpdateDelay (Non-negative Integer) Minimum delay in seconds between automatic index stats updates for a given index. Value 0 means no delay Default: 60 (Min: 0, Max: 4294967039) CrashOnCorruptedTuple (Boolean value) To be failfast or not, when checksum indicates corruption. Default: Y (Legal values: Y, N) MinFreePct (Non-negative Integer) Keep 5% of database free to ensure that we don't get out of memory during restart Default: 5 (Min: 0, Max: 100) DefaultHashmapSize (Non-negative Integer) Hashmap size to use for new tables. Normally this should be left unset, but can be set to aid downgrade to older versions not supporting as big hashmaps as current version or to use special hashmap size to gain better balance for some number of nodes and ldm-threads. Default: 0 (Min: 0, Max: 3840) ****** API ****** wan (Boolean value) Use WAN TCP setting as default Default: N (Legal values: Y, N) HostName (String) Name of computer for this node Default: NodeId (Non-negative Integer) Number identifying application node (mysqld(API)) MANDATORY (Min: 1, Max: 255) ExecuteOnComputer (String) String referencing an earlier defined COMPUTER ArbitrationRank (Non-negative Integer) If 0, then mysqld(API) is not arbitrator. Kernel selects arbitrators in order 1, 2 Default: 0 (Min: 0, Max: 2) ArbitrationDelay (Non-negative Integer) When asked to arbitrate, arbitrator waits this long before voting (msec) Default: 0 (Min: 0, Max: 4294967039) MaxScanBatchSize (Non-negative Integer) The maximum collective batch size for one scan Default: 262144 (Min: 32768, Max: 16777216) BatchByteSize (Non-negative Integer) The default batch size in bytes Default: 16384 (Min: 1024, Max: 1048576) BatchSize (Non-negative Integer) The default batch size in number of records Default: 256 (Min: 1, Max: 992) ConnectionMap (String) Specifies which DB nodes to connect ExtraSendBufferMemory (Non-negative Integer) Extra send buffer memory to use for send buffers in all transporters Default: 0 (Min: 0, Max: 34359738368) TotalSendBufferMemory (Non-negative Integer) Total memory to use for send buffers in all transporters Default: 0 (Min: 262144, Max: 4294967039) AutoReconnect (Boolean value) Specifies if an api node should reconnect when fully disconnected from cluster Default: Y (Legal values: Y, N) HeartbeatThreadPriority (String) Specify thread properties of heartbeat thread DefaultOperationRedoProblemAction (String) If Redo-log is having problem, should operation default (unless overridden on transaction/operation level) abort or be put on queue Default: queue DefaultHashmapSize (Non-negative Integer) Hashmap size to use for new tables. Normally this should be left unset, but can be set to aid downgrade to older versions not supporting as big hashmaps as current version or to use special hashmap size to gain better balance for some number of nodes and ldm-threads. Default: 0 (Min: 0, Max: 3840) ****** API ****** wan (Boolean value) Use WAN TCP setting as default Default: N (Legal values: Y, N) HostName (String) Name of computer for this node Default: NodeId (Non-negative Integer) Number identifying application node (mysqld(API)) MANDATORY (Min: 1, Max: 255) ExecuteOnComputer (String) String referencing an earlier defined COMPUTER ArbitrationRank (Non-negative Integer) If 0, then mysqld(API) is not arbitrator. Kernel selects arbitrators in order 1, 2 Default: 0 (Min: 0, Max: 2) ArbitrationDelay (Non-negative Integer) When asked to arbitrate, arbitrator waits this long before voting (msec) Default: 0 (Min: 0, Max: 4294967039) MaxScanBatchSize (Non-negative Integer) The maximum collective batch size for one scan Default: 262144 (Min: 32768, Max: 16777216) BatchByteSize (Non-negative Integer) The default batch size in bytes Default: 16384 (Min: 1024, Max: 1048576) BatchSize (Non-negative Integer) The default batch size in number of records Default: 256 (Min: 1, Max: 992) ConnectionMap (String) Specifies which DB nodes to connect ExtraSendBufferMemory (Non-negative Integer) Extra send buffer memory to use for send buffers in all transporters Default: 0 (Min: 0, Max: 34359738368) TotalSendBufferMemory (Non-negative Integer) Total memory to use for send buffers in all transporters Default: 0 (Min: 262144, Max: 4294967039) AutoReconnect (Boolean value) Specifies if an api node should reconnect when fully disconnected from cluster Default: Y (Legal values: Y, N) HeartbeatThreadPriority (String) Specify thread properties of heartbeat thread DefaultOperationRedoProblemAction (String) If Redo-log is having problem, should operation default (unless overridden on transaction/operation level) abort or be put on queue Default: queue DefaultHashmapSize (Non-negative Integer) Hashmap size to use for new tables. Normally this should be left unset, but can be set to aid downgrade to older versions not supporting as big hashmaps as current version or to use special hashmap size to gain better balance for some number of nodes and ldm-threads. Default: 0 (Min: 0, Max: 3840) ****** MGM ****** wan (Boolean value) Use WAN TCP setting as default Default: N (Legal values: Y, N) HostName (String) Name of computer for this node Default: DataDir (String) Data directory for this node Default: writable NodeId (Non-negative Integer) Number identifying the management server node (ndb_mgmd(MGM)) MANDATORY (Min: 1, Max: 255) LogDestination (String) String describing where logmessages are sent ExecuteOnComputer (String) String referencing an earlier defined COMPUTER MaxNoOfSavedEvents (Non-negative Integer) Default: 100 (Min: 0, Max: 4294967039) PortNumber (Non-negative Integer) Port number to give commands to/fetch configurations from management server Default: 1186 (Min: 0, Max: 65535) PortNumberStats (Non-negative Integer) Port number used to get statistical information from a management server (Min: 0, Max: 65535) ArbitrationRank (Non-negative Integer) If 0, then ndb_mgmd(MGM) is not arbitrator. Kernel selects arbitrators in order 1, 2 Default: 1 (Min: 0, Max: 2) ArbitrationDelay (Non-negative Integer) Default: 0 (Min: 0, Max: 4294967039) ExtraSendBufferMemory (Non-negative Integer) Extra send buffer memory to use for send buffers in all transporters Default: 0 (Min: 0, Max: 34359738368) TotalSendBufferMemory (Non-negative Integer) Total memory to use for send buffers in all transporters Default: 0 (Min: 262144, Max: 4294967039) HeartbeatThreadPriority (String) Specify thread properties of heartbeat thread ****** MGM ****** wan (Boolean value) Use WAN TCP setting as default Default: N (Legal values: Y, N) HostName (String) Name of computer for this node Default: DataDir (String) Data directory for this node Default: writable NodeId (Non-negative Integer) Number identifying the management server node (ndb_mgmd(MGM)) MANDATORY (Min: 1, Max: 255) LogDestination (String) String describing where logmessages are sent ExecuteOnComputer (String) String referencing an earlier defined COMPUTER MaxNoOfSavedEvents (Non-negative Integer) Default: 100 (Min: 0, Max: 4294967039) PortNumber (Non-negative Integer) Port number to give commands to/fetch configurations from management server Default: 1186 (Min: 0, Max: 65535) PortNumberStats (Non-negative Integer) Port number used to get statistical information from a management server (Min: 0, Max: 65535) ArbitrationRank (Non-negative Integer) If 0, then ndb_mgmd(MGM) is not arbitrator. Kernel selects arbitrators in order 1, 2 Default: 1 (Min: 0, Max: 2) ArbitrationDelay (Non-negative Integer) Default: 0 (Min: 0, Max: 4294967039) ExtraSendBufferMemory (Non-negative Integer) Extra send buffer memory to use for send buffers in all transporters Default: 0 (Min: 0, Max: 34359738368) TotalSendBufferMemory (Non-negative Integer) Total memory to use for send buffers in all transporters Default: 0 (Min: 262144, Max: 4294967039) HeartbeatThreadPriority (String) Specify thread properties of heartbeat thread ****** TCP ****** HostName1 (String) Name/IP of computer on one side of the connection HostName2 (String) Name/IP of computer on one side of the connection NodeId1 (String) Id of node (ndbd(DB), mysqld(API) or ndb_mgmd(MGM)) on one side of the connection MANDATORY NodeId2 (String) Id of node (ndbd(DB), mysqld(API) or ndb_mgmd(MGM)) on one side of the connection MANDATORY Group (Non-negative Integer) Default: 55 (Min: 0, Max: 200) NodeIdServer (Non-negative Integer) MANDATORY (Min: 1, Max: 63) SendSignalId (Boolean value) Sends id in each signal. Used in trace files. Default: Y (Legal values: Y, N) Checksum (Boolean value) If checksum is enabled, all signals between nodes are checked for errors Default: N (Legal values: Y, N) SendBufferMemory (Non-negative Integer) Bytes of buffer for signals sent from this node Default: 2097152 (Min: 65536, Max: 4294967039) ReceiveBufferMemory (Non-negative Integer) Bytes of buffer for signals received by this node Default: 2097152 (Min: 16384, Max: 4294967039) Proxy (String) TCP_SND_BUF_SIZE (Non-negative Integer) Value used for SO_SNDBUF Default: 0 (Min: 0, Max: 2147483648) TCP_RCV_BUF_SIZE (Non-negative Integer) Value used for SO_RCVBUF Default: 0 (Min: 0, Max: 2147483648) TCP_MAXSEG_SIZE (Non-negative Integer) Value used for TCP_MAXSEG Default: 0 (Min: 0, Max: 2147483648) TcpBind_INADDR_ANY (Boolean value) Bind InAddrAny instead of hostname for server part of connection Default: N (Legal values: Y, N) OverloadLimit (Non-negative Integer) Number of unsent bytes that must be in the send buffer before the connection is considered overloaded Default: 0 (Min: 0, Max: 4294967039) ****** TCP ****** HostName1 (String) Name/IP of computer on one side of the connection HostName2 (String) Name/IP of computer on one side of the connection NodeId1 (String) Id of node (ndbd(DB), mysqld(API) or ndb_mgmd(MGM)) on one side of the connection MANDATORY NodeId2 (String) Id of node (ndbd(DB), mysqld(API) or ndb_mgmd(MGM)) on one side of the connection MANDATORY Group (Non-negative Integer) Default: 55 (Min: 0, Max: 200) NodeIdServer (Non-negative Integer) MANDATORY (Min: 1, Max: 63) SendSignalId (Boolean value) Sends id in each signal. Used in trace files. Default: Y (Legal values: Y, N) Checksum (Boolean value) If checksum is enabled, all signals between nodes are checked for errors Default: N (Legal values: Y, N) SendBufferMemory (Non-negative Integer) Bytes of buffer for signals sent from this node Default: 2097152 (Min: 65536, Max: 4294967039) ReceiveBufferMemory (Non-negative Integer) Bytes of buffer for signals received by this node Default: 2097152 (Min: 16384, Max: 4294967039) Proxy (String) TCP_SND_BUF_SIZE (Non-negative Integer) Value used for SO_SNDBUF Default: 0 (Min: 0, Max: 2147483648) TCP_RCV_BUF_SIZE (Non-negative Integer) Value used for SO_RCVBUF Default: 0 (Min: 0, Max: 2147483648) TCP_MAXSEG_SIZE (Non-negative Integer) Value used for TCP_MAXSEG Default: 0 (Min: 0, Max: 2147483648) TcpBind_INADDR_ANY (Boolean value) Bind InAddrAny instead of hostname for server part of connection Default: N (Legal values: Y, N) OverloadLimit (Non-negative Integer) Number of unsent bytes that must be in the send buffer before the connection is considered overloaded Default: 0 (Min: 0, Max: 4294967039) ****** SHM ****** HostName1 (String) Name/IP of computer on one side of the connection HostName2 (String) Name/IP of computer on one side of the connection Signum (Non-negative Integer) Signum to be used for signalling (Min: 0, Max: 4294967039) NodeId1 (String) Id of node (ndbd(DB), mysqld(API) or ndb_mgmd(MGM)) on one side of the connection MANDATORY NodeId2 (String) Id of node (ndbd(DB), mysqld(API) or ndb_mgmd(MGM)) on one side of the connection MANDATORY Group (Non-negative Integer) Default: 35 (Min: 0, Max: 200) NodeIdServer (Non-negative Integer) MANDATORY (Min: 1, Max: 63) SendSignalId (Boolean value) Sends id in each signal. Used in trace files. Default: N (Legal values: Y, N) Checksum (Boolean value) If checksum is enabled, all signals between nodes are checked for errors Default: Y (Legal values: Y, N) ShmKey (Non-negative Integer) A shared memory key (Min: 0, Max: 4294967039) ShmSize (Non-negative Integer) Size of shared memory segment Default: 1048576 (Min: 65536, Max: 4294967039) OverloadLimit (Non-negative Integer) Number of unsent bytes that must be in the send buffer before the connection is considered overloaded Default: 0 (Min: 0, Max: 4294967039) ****** SHM ****** HostName1 (String) Name/IP of computer on one side of the connection HostName2 (String) Name/IP of computer on one side of the connection Signum (Non-negative Integer) Signum to be used for signalling (Min: 0, Max: 4294967039) NodeId1 (String) Id of node (ndbd(DB), mysqld(API) or ndb_mgmd(MGM)) on one side of the connection MANDATORY NodeId2 (String) Id of node (ndbd(DB), mysqld(API) or ndb_mgmd(MGM)) on one side of the connection MANDATORY Group (Non-negative Integer) Default: 35 (Min: 0, Max: 200) NodeIdServer (Non-negative Integer) MANDATORY (Min: 1, Max: 63) SendSignalId (Boolean value) Sends id in each signal. Used in trace files. Default: N (Legal values: Y, N) Checksum (Boolean value) If checksum is enabled, all signals between nodes are checked for errors Default: Y (Legal values: Y, N) ShmKey (Non-negative Integer) A shared memory key (Min: 0, Max: 4294967039) ShmSize (Non-negative Integer) Size of shared memory segment Default: 1048576 (Min: 65536, Max: 4294967039) OverloadLimit (Non-negative Integer) Number of unsent bytes that must be in the send buffer before the connection is considered overloaded Default: 0 (Min: 0, Max: 4294967039) ****** SCI ****** NodeId1 (String) Id of node (ndbd(DB), mysqld(API) or ndb_mgmd(MGM)) on one side of the connection MANDATORY NodeId2 (String) Id of node (ndbd(DB), mysqld(API) or ndb_mgmd(MGM)) on one side of the connection MANDATORY Group (Non-negative Integer) Default: 15 (Min: 0, Max: 200) NodeIdServer (Non-negative Integer) MANDATORY (Min: 1, Max: 63) HostName1 (String) Name/IP of computer on one side of the connection HostName2 (String) Name/IP of computer on one side of the connection Host1SciId0 (Non-negative Integer) SCI-node id for adapter 0 on Host1 (a computer can have two adapters) MANDATORY (Min: 0, Max: 4294967039) Host1SciId1 (Non-negative Integer) SCI-node id for adapter 1 on Host1 (a computer can have two adapters) Default: 0 (Min: 0, Max: 4294967039) Host2SciId0 (Non-negative Integer) SCI-node id for adapter 0 on Host2 (a computer can have two adapters) MANDATORY (Min: 0, Max: 4294967039) Host2SciId1 (Non-negative Integer) SCI-node id for adapter 1 on Host2 (a computer can have two adapters) Default: 0 (Min: 0, Max: 4294967039) SendSignalId (Boolean value) Sends id in each signal. Used in trace files. Default: Y (Legal values: Y, N) Checksum (Boolean value) If checksum is enabled, all signals between nodes are checked for errors Default: N (Legal values: Y, N) SendLimit (Non-negative Integer) Transporter send buffer contents are sent when this no of bytes is buffered Default: 8192 (Min: 128, Max: 32768) SharedBufferSize (Non-negative Integer) Size of shared memory segment Default: 1048576 (Min: 65536, Max: 4294967039) OverloadLimit (Non-negative Integer) Number of unsent bytes that must be in the send buffer before the connection is considered overloaded Default: 0 (Min: 0, Max: 4294967039) ****** SCI ****** NodeId1 (String) Id of node (ndbd(DB), mysqld(API) or ndb_mgmd(MGM)) on one side of the connection MANDATORY NodeId2 (String) Id of node (ndbd(DB), mysqld(API) or ndb_mgmd(MGM)) on one side of the connection MANDATORY Group (Non-negative Integer) Default: 15 (Min: 0, Max: 200) NodeIdServer (Non-negative Integer) MANDATORY (Min: 1, Max: 63) HostName1 (String) Name/IP of computer on one side of the connection HostName2 (String) Name/IP of computer on one side of the connection Host1SciId0 (Non-negative Integer) SCI-node id for adapter 0 on Host1 (a computer can have two adapters) MANDATORY (Min: 0, Max: 4294967039) Host1SciId1 (Non-negative Integer) SCI-node id for adapter 1 on Host1 (a computer can have two adapters) Default: 0 (Min: 0, Max: 4294967039) Host2SciId0 (Non-negative Integer) SCI-node id for adapter 0 on Host2 (a computer can have two adapters) MANDATORY (Min: 0, Max: 4294967039) Host2SciId1 (Non-negative Integer) SCI-node id for adapter 1 on Host2 (a computer can have two adapters) Default: 0 (Min: 0, Max: 4294967039) SendSignalId (Boolean value) Sends id in each signal. Used in trace files. Default: Y (Legal values: Y, N) Checksum (Boolean value) If checksum is enabled, all signals between nodes are checked for errors Default: N (Legal values: Y, N) SendLimit (Non-negative Integer) Transporter send buffer contents are sent when this no of bytes is buffered Default: 8192 (Min: 128, Max: 32768) SharedBufferSize (Non-negative Integer) Size of shared memory segment Default: 1048576 (Min: 65536, Max: 4294967039) OverloadLimit (Non-negative Integer) Number of unsent bytes that must be in the send buffer before the connection is considered overloaded Default: 0 (Min: 0, Max: 4294967039)