Overview of NDB Cluster Configuration Parameters, Options, and Variables • HeartbeatOrder : Sets order in which data nodes check each others’ heartbeats for determining whether given node is still active and connected to cluster. Must be zero for all data nodes or distinct nonzero values for all data nodes; see documentation for further guidance. • HostName : Host name or IP address for this data node. • IndexMemory : Number of bytes on each data node allocated for storing indexes; subject to available system RAM and size of DataMemory. • IndexStatAutoCreate : Enable/disable automatic statistics collection when indexes are created. • IndexStatAutoUpdate : Monitor indexes for changes and trigger automatic statistics updates. • IndexStatSaveScale : Scaling factor used in determining size of stored index statistics. • IndexStatSaveSize : Maximum size in bytes for saved statistics per index. • IndexStatTriggerPct : Threshold percent change in DML operations for index statistics updates. Value is scaled down by IndexStatTriggerScale. • IndexStatTriggerScale : Scale down IndexStatTriggerPct by this amount, multiplied by base 2 logarithm of index size, for large index. Set to 0 to disable scaling. • IndexStatUpdateDelay : Minimum delay between automatic index statistics updates for given index. 0 means no delay. • InitFragmentLogFiles : Initialize fragment logfiles (sparse/full). • InitialLogFileGroup : Describes log file group that is created during initial start. See documentation for format. • InitialNoOfOpenFiles : Initial number of files open per data node. (One thread is created per file). • InitialTablespace : Describes tablespace that is created during initial start. See documentation for format. • InsertRecoveryWork : Percentage of RecoveryWork used for inserted rows; has no effect unless partial local checkpoints are in use. • LateAlloc : Allocate memory after connection to management server has been established. • LcpScanProgressTimeout : Maximum time that local checkpoint fragment scan can be stalled before node is shut down to ensure systemwide LCP progress. Use 0 to disable. • LockExecuteThreadToCPU : Comma-delimited list of CPU IDs. • LockMaintThreadsToCPU : CPU ID indicating which CPU runs maintenance threads. • LockPagesInMainMemory : 0=disable locking, 1=lock after memory allocation, 2=lock before memory allocation. • LogLevelCheckpoint : Log level of local and global checkpoint information printed to stdout. • LogLevelCongestion : Level of congestion information printed to stdout. • LogLevelConnection : Level of node connect/disconnect information printed to stdout. • LogLevelError : Transporter, heartbeat errors printed to stdout. • LogLevelInfo : Heartbeat and log information printed to stdout. 4034