MySQL 5.6 한글메뉴얼

18.3.2.1 MySQL Cluster 데이터 노드의 구성 매개 변수

이 섹션의 요약 테이블은 MySQL Cluster 데이터 노드를 구성하기 위해 config.ini 파일의 [ndbd] 또는 [ndbd default] 섹션에서 사용되는 매개 변수에 대해 설명합니다. 이러한 매개 변수에 대한 자세한 설명 및 기타 자세한 내용은 섹션 18.3.2.6 "MySQL Cluster 데이터 노드의 정의" 를 참조하십시오.

이러한 매개 변수는 ndbd의 멀티 스레드 버전 인 ndbmtd에도 적용됩니다. 자세한 내용은 섹션 18.4.3 "ndbmtd - MySQL Cluster 데이터 노드 데몬 (멀티 스레드)" 를 참조하십시오.

다시 시작 유형 MySQL Cluster 구성 매개 변수 변경 클러스터가 다시 시작될 때까지 적용되지 않습니다. 요약 테이블에는 특정 매개 변수 변경에 필요한 다시 시작 유형을 다음과 같이 설명합니다.

N - 노드의 재부팅 :이 매개 변수는 롤링 재시작을 사용하여 업데이트 할 수 있습니다 ( 섹션 18.5.5 "MySQL Cluster의 롤링 다시 부팅 수행" 을 참조하십시오).
S - 시스템 재시작 :이 매개 변수의 변경 사항을 적용하려면 클러스터를 완전히 종료하고 다시 시작해야합니다.
I - 초기 재시작 : --initial 옵션을 사용하여 데이터 노드를 다시 시작해야합니다.

다시 시작 유형 자세한 내용은 섹션 18.3.3 "MySQL Cluster 구성 매개 변수 개요" 를 참조하십시오.

MySQL Cluster NDB 7.3 이상에서는 새로운 데이터 노드 그룹을 실행중인 클러스터에 온라인으로 추가하는 방법이 지원됩니다. 자세한 내용은 섹션 18.5.13 "MySQL Cluster 데이터 노드의 온라인 추가" 를 참조하십시오.

Table 18.1 Data Node Configuration Parameters

Parameter Name	Type or Units	Restart Type	In Version ... (and later)
	Default Value
	Minimum/Maximum or Permitted Values
`Arbitration`	enumeration	N	NDB 7.3.0
	Default
	Default, Disabled, WaitExternal
`ArbitrationTimeout`	milliseconds	N	NDB 7.3.0
	7500
	10 / 4294967039 (0xFFFFFEFF)
`BackupDataBufferSize`	bytes	N	NDB 7.3.0
	16M
	0 / 4294967039 (0xFFFFFEFF)
`BackupDataDir`	path	IN	NDB 7.3.0
	FileSystemPath
	...
`BackupDiskWriteSpeedPct`	percent	N	NDB 7.4.8
	50
	0 / 90
`BackupLogBufferSize`	bytes	N	NDB 7.3.0
	16M
	0 / 4294967039 (0xFFFFFEFF)
`BackupMaxWriteSize`	bytes	N	NDB 7.3.0
	1M
	2K / 4294967039 (0xFFFFFEFF)
`BackupMemory`	bytes	N	NDB 7.3.0
	32M
	0 / 4294967039 (0xFFFFFEFF)
`BackupReportFrequency`	seconds	N	NDB 7.3.0
	0
	0 / 4294967039 (0xFFFFFEFF)
`BackupWriteSize`	bytes	N	NDB 7.3.0
	256K
	2K / 4294967039 (0xFFFFFEFF)
`BatchSizePerLocalScan`	integer	N	NDB 7.3.0
	256
	1 / 992
`BuildIndexThreads`	numeric	S	NDB 7.3.0
	0
	0 / 128
`CompressedBackup`	boolean	N	NDB 7.3.0
	false
	true, false
`CompressedLCP`	boolean	N	NDB 7.3.0
	false
	true, false
`ConnectCheckIntervalDelay`	milliseconds	N	NDB 7.3.0
	0
	0 / 4294967039 (0xFFFFFEFF)
`CrashOnCorruptedTuple`	boolean	S	NDB 7.3.0
	true
	true, false
`DataDir`	path	IN	NDB 7.3.0
	.
	...
`DataMemory`	bytes	N	NDB 7.3.0
	80M
	1M / 1024G
`DefaultHashMapSize`	LDM threads	N	NDB 7.3.0
	3840
	0 / 3840
`DictTrace`	bytes	N	NDB 7.3.0
	undefined
	0 / 100
`DiskCheckpointSpeed`	bytes	N	NDB 7.3.0
	10M
	1M / 4294967039 (0xFFFFFEFF)
`DiskCheckpointSpeedInRestart`	bytes	N	NDB 7.3.0
	100M
	1M / 4294967039 (0xFFFFFEFF)
`DiskIOThreadPool`	threads	N	NDB 7.3.0
	2
	0 / 4294967039 (0xFFFFFEFF)
`Diskless`	true\|false (1\|0)	IS	NDB 7.3.0
	false
	true, false
`DiskPageBufferEntries`	32K pages	N	NDB 7.4.3
	10
	1 / 1000
`DiskPageBufferMemory`	bytes	N	NDB 7.3.0
	64M
	4M / 1T
`DiskSyncSize`	bytes	N	NDB 7.3.0
	4M
	32K / 4294967039 (0xFFFFFEFF)
`ExecuteOnComputer`	name	S	NDB 7.3.0
	[none]
	...
`ExtraSendBufferMemory`	bytes	N	NDB 7.3.0
	0
	0 / 32G
`FileSystemPath`	path	IN	NDB 7.3.0
	DataDir
	...
`FileSystemPathDataFiles`	filename	IN	NDB 7.3.0
	[see text]
	...
`FileSystemPathDD`	filename	IN	NDB 7.3.0
	FileSystemPath
	...
`FileSystemPathUndoFiles`	filename	IN	NDB 7.3.0
	[see text]
	...
`FragmentLogFileSize`	bytes	IN	NDB 7.3.0
	16M
	4M / 1G
`HeartbeatIntervalDbApi`	milliseconds	N	NDB 7.3.0
	1500
	100 / 4294967039 (0xFFFFFEFF)
`HeartbeatIntervalDbDb`	milliseconds	N	NDB 7.3.0
	5000
	10 / 4294967039 (0xFFFFFEFF)
`HeartbeatOrder`	numeric	S	NDB 7.3.0
	0
	0 / 65535
`HostName`	name or IP address	N	NDB 7.3.0
	localhost
	...
`Id`	unsigned	IS	NDB 7.3.0
	[none]
	1 / 48
`IndexMemory`	bytes	N	NDB 7.3.0
	18M
	1M / 1T
`IndexStatAutoCreate`	boolean	S	NDB 7.3.0
	false
	false, true
`IndexStatAutoUpdate`	boolean	S	NDB 7.3.0
	false
	false, true
`IndexStatSaveScale`	percentage	IN	NDB 7.3.0
	100
	0 / 4294967039 (0xFFFFFEFF)
`IndexStatSaveSize`	bytes	IN	NDB 7.3.0
	32768
	0 / 4294967039 (0xFFFFFEFF)
`IndexStatTriggerPct`	percentage	IN	NDB 7.3.0
	100
	0 / 4294967039 (0xFFFFFEFF)
`IndexStatTriggerScale`	percentage	IN	NDB 7.3.0
	100
	0 / 4294967039 (0xFFFFFEFF)
`IndexStatUpdateDelay`	seconds	IN	NDB 7.3.0
	60
	0 / 4294967039 (0xFFFFFEFF)
`InitFragmentLogFiles`	[see values]	IN	NDB 7.3.0
	SPARSE
	SPARSE, FULL
`InitialLogFileGroup`	string	S	NDB 7.3.0
	[see text]
	...
`InitialNoOfOpenFiles`	files	N	NDB 7.3.0
	27
	20 / 4294967039 (0xFFFFFEFF)
`InitialTablespace`	string	S	NDB 7.3.0
	[see text]
	...
`LateAlloc`	numeric	N	NDB 7.3.0
	1
	0 / 1
`LcpScanProgressTimeout`	second	N	NDB 7.3.3
	60
	0 / 4294967039 (0xFFFFFEFF)
`LockExecuteThreadToCPU`	CPU ID	N	NDB 7.3.0
	64K
	0 / 64K
`LockMaintThreadsToCPU`	CPU ID	N	NDB 7.3.0
	[none]
	0 / 64K
`LockPagesInMainMemory`	numeric	N	NDB 7.3.0
	0
	0 / 2
`LogLevelCheckpoint`	log level	N	NDB 7.3.0
	0
	0 / 15
`LogLevelCongestion`	levelr	N	NDB 7.3.0
	0
	0 / 15
`LogLevelConnection`	integer	N	NDB 7.3.0
	0
	0 / 15
`LogLevelError`	integer	N	NDB 7.3.0
	0
	0 / 15
`LogLevelInfo`	integer	N	NDB 7.3.0
	0
	0 / 15
`LogLevelNodeRestart`	integer	N	NDB 7.3.0
	0
	0 / 15
`LogLevelShutdown`	integer	N	NDB 7.3.0
	0
	0 / 15
`LogLevelStartup`	integer	N	NDB 7.3.0
	1
	0 / 15
`LogLevelStatistic`	integer	N	NDB 7.3.0
	0
	0 / 15
`LongMessageBuffer`	bytes	N	NDB 7.3.5
	64M
	512K / 4294967039 (0xFFFFFEFF)
`MaxAllocate`	unsigned	N	NDB 7.3.0
	32M
	1M / 1G
`MaxBufferedEpochs`	epochs	N	NDB 7.3.0
	100
	0 / 100000
`MaxBufferedEpochBytes`	bytes	N	NDB 7.3.0
	26214400
	26214400 (0x01900000) / 4294967039 (0xFFFFFEFF)
`MaxDiskWriteSpeed`	numeric	S	NDB 7.4.1
	20M
	1M / 1024G
`MaxDiskWriteSpeedOtherNodeRestart`	numeric	S	NDB 7.4.1
	50M
	1M / 1024G
`MaxDiskWriteSpeedOwnRestart`	numeric	S	NDB 7.4.1
	200M
	1M / 1024G
`MaxDMLOperationsPerTransaction`	operations (DML)	N	NDB 7.3.0
	4294967295
	32 / 4294967295
`MaxLCPStartDelay`	seconds	N	NDB 7.3.0
	0
	0 / 600
`MaxNoOfAttributes`	integer	N	NDB 7.3.0
	1000
	32 / 4294967039 (0xFFFFFEFF)
`MaxNoOfConcurrentIndexOperations`	integer	N	NDB 7.3.0
	8K
	0 / 4294967039 (0xFFFFFEFF)
`MaxNoOfConcurrentOperations`	integer	N	NDB 7.3.0
	32K
	32 / 4294967039 (0xFFFFFEFF)
`MaxNoOfConcurrentScans`	integer	N	NDB 7.3.0
	256
	2 / 500
`MaxNoOfConcurrentSubOperations`	unsigned	N	NDB 7.3.0
	256
	0 / 4294967039 (0xFFFFFEFF)
`MaxNoOfConcurrentTransactions`	integer	N	NDB 7.3.0
	4096
	32 / 4294967039 (0xFFFFFEFF)
`MaxNoOfFiredTriggers`	integer	N	NDB 7.3.0
	4000
	0 / 4294967039 (0xFFFFFEFF)
`MaxNoOfLocalOperations`	integer	N	NDB 7.3.0
	UNDEFINED
	32 / 4294967039 (0xFFFFFEFF)
`MaxNoOfLocalScans`	integer	N	NDB 7.3.0
	[see text]
	32 / 4294967039 (0xFFFFFEFF)
`MaxNoOfOpenFiles`	unsigned	N	NDB 7.3.0
	0
	20 / 4294967039 (0xFFFFFEFF)
`MaxNoOfOrderedIndexes`	integer	N	NDB 7.3.0
	128
	0 / 4294967039 (0xFFFFFEFF)
`MaxNoOfSavedMessages`	integer	N	NDB 7.3.0
	25
	0 / 4294967039 (0xFFFFFEFF)
`MaxNoOfSubscribers`	unsigned	N	NDB 7.3.0
	0
	0 / 4294967039 (0xFFFFFEFF)
`MaxNoOfSubscriptions`	unsigned	N	NDB 7.3.0
	0
	0 / 4294967039 (0xFFFFFEFF)
`MaxNoOfTables`	integer	N	NDB 7.3.0
	128
	8 / 20320
`MaxNoOfTriggers`	integer	N	NDB 7.3.0
	768
	0 / 4294967039 (0xFFFFFEFF)
`MaxNoOfUniqueHashIndexes`	integer	N	NDB 7.3.0
	64
	0 / 4294967039 (0xFFFFFEFF)
`MaxParallelCopyInstances`	integer	S	NDB 7.4.3
	0
	0 / 64
`MaxParallelScansPerFragment`	bytes	N	NDB 7.3.0
	256
	1 / 4294967039 (0xFFFFFEFF)
`MaxStartFailRetries`	unsigned	N	NDB 7.3.0
	3
	0 / 4294967039 (0xFFFFFEFF)
`MemReportFrequency`	unsigned	N	NDB 7.3.0
	0
	0 / 4294967039 (0xFFFFFEFF)
`MinDiskWriteSpeed`	numeric	S	NDB 7.4.1
	10M
	1M / 1024G
`MinFreePct`	unsigned	N	NDB 7.3.0
	5
	0 / 100
`NodeGroup`		IS	NDB 7.3.0
	[none]
	0 / 65536
`NodeId`	unsigned	IS	NDB 7.3.0
	[none]
	1 / 48
`NoOfFragmentLogFiles`	integer	IN	NDB 7.3.0
	16
	3 / 4294967039 (0xFFFFFEFF)
`NoOfReplicas`	integer	IS	NDB 7.3.0
	2
	1 / 4
`Numa`	boolean	N	NDB 7.3.0
	1
	...
`ODirect`	boolean	N	NDB 7.3.0
	false
	true, false
`RealtimeScheduler`	boolean	N	NDB 7.3.0
	false
	true, false
`RedoBuffer`	bytes	N	NDB 7.3.0
	32M
	1M / 4294967039 (0xFFFFFEFF)
`RedoOverCommitCounter`	numeric	N	NDB 7.3.0
	3
	0 / 4294967039 (0xFFFFFEFF)
`RedoOverCommitLimit`	seconds	N	NDB 7.3.0
	20
	0 / 4294967039 (0xFFFFFEFF)
`ReservedSendBufferMemory`	bytes	N	NDB 7.3.0
	256K
	0 / 4294967039 (0xFFFFFEFF)
`RestartOnErrorInsert`	error code	N	NDB 7.3.0
	2
	0 / 4
`SchedulerExecutionTimer`	µsec	N	NDB 7.3.0
	50
	0 / 11000
`SchedulerSpinTimer`	µsec	N	NDB 7.3.0
	0
	0 / 500
`ServerPort`	unsigned	S	NDB 7.3.0
	[none]
	1 / 64K
`SharedGlobalMemory`	bytes	N	NDB 7.3.0
	128M
	0 / 64T
`StartFailRetryDelay`	unsigned	N	NDB 7.3.0
	0
	0 / 4294967039 (0xFFFFFEFF)
`StartFailureTimeout`	milliseconds	N	NDB 7.3.0
	0
	0 / 4294967039 (0xFFFFFEFF)
`StartNoNodeGroupTimeout`	milliseconds	N	NDB 7.3.0
	15000
	0 / 4294967039 (0xFFFFFEFF)
`StartPartialTimeout`	milliseconds	N	NDB 7.3.0
	30000
	0 / 4294967039 (0xFFFFFEFF)
`StartPartitionedTimeout`	milliseconds	N	NDB 7.3.0
	60000
	0 / 4294967039 (0xFFFFFEFF)
`StartupStatusReportFrequency`	seconds	N	NDB 7.3.0
	0
	0 / 4294967039 (0xFFFFFEFF)
`StopOnError`	boolean	N	NDB 7.3.0
	1
	0, 1
`StringMemory`	% or bytes	S	NDB 7.3.0
	25
	0 / 4294967039 (0xFFFFFEFF)
`TcpBind_INADDR_ANY`	boolean	N	NDB 7.3.0
	false
	true, false
`TimeBetweenEpochs`	milliseconds	N	NDB 7.3.0
	100
	0 / 32000
`TimeBetweenEpochsTimeout`	milliseconds	N	NDB 7.3.0
	0
	0 / 256000
`TimeBetweenGlobalCheckpoints`	milliseconds	N	NDB 7.3.0
	2000
	20 / 32000
`TimeBetweenGlobalCheckpointsTimeout`	milliseconds	N	NDB 7.3.9
	120000
	10 / 4294967039 (0xFFFFFEFF)
`TimeBetweenInactiveTransactionAbortCheck`	milliseconds	N	NDB 7.3.0
	1000
	1000 / 4294967039 (0xFFFFFEFF)
`TimeBetweenLocalCheckpoints`	number of 4-byte words, as a base-2 logarithm	N	NDB 7.3.0
	20
	0 / 31
`TimeBetweenWatchDogCheck`	milliseconds	N	NDB 7.3.0
	6000
	70 / 4294967039 (0xFFFFFEFF)
`TimeBetweenWatchDogCheckInitial`	milliseconds	N	NDB 7.3.0
	6000
	70 / 4294967039 (0xFFFFFEFF)
`TotalSendBufferMemory`	bytes	N	NDB 7.3.0
	0
	256K / 4294967039 (0xFFFFFEFF)
`TransactionBufferMemory`	bytes	N	NDB 7.3.0
	1M
	1K / 4294967039 (0xFFFFFEFF)
`TransactionDeadlockDetectionTimeout`	milliseconds	N	NDB 7.3.0
	1200
	50 / 4294967039 (0xFFFFFEFF)
`TransactionInactiveTimeout`	milliseconds	N	NDB 7.3.0
	[see text]
	0 / 4294967039 (0xFFFFFEFF)
`TwoPassInitialNodeRestartCopy`	boolean	N	NDB 7.3.0
	false
	true, false
`UndoDataBuffer`	unsigned	N	NDB 7.3.0
	16M
	1M / 4294967039 (0xFFFFFEFF)
`UndoIndexBuffer`	unsigned	N	NDB 7.3.0
	2M
	1M / 4294967039 (0xFFFFFEFF)

Table 18.2 Multi-Threaded Data Node Configuration Parameters

Parameter Name	Type or Units	Restart Type	In Version ... (and later)
	Default Value
	Minimum/Maximum or Permitted Values
`MaxNoOfExecutionThreads`	integer	IS	NDB 7.3.3
	2
	2 / 72
`NoOfFragmentLogParts`	numeric	IN	NDB 7.3.3
	4
	4, 8, 12, 16, 24, 32
`ThreadConfig`	string	IS	NDB 7.3.0
	''
	...