MySQL Cluster线上管理节点配置文件-数据节点96G内存_MySQL

bitsCN.com

MySQL Cluster线上管理节点配置文件-数据节点96G内存

 

[NDBD DEFAULT]

NoOfReplicas: 2   #

DataDir: /data/mysql/log

#FileSystemPath: /add/path/here

 

 

# Data Memory, Index Memory, and String Memory #

DataMemory: 61440M

IndexMemory: 10240M

StringMemory: 50

 

 

# Transaction Parameters #

MaxNoOfConcurrentTransactions: 204800

MaxNoOfConcurrentOperations: 300000

MaxNoOfLocalOperations: 20000

 

 

# Transaction Temporary Storage #

MaxNoOfConcurrentIndexOperations: 65536

MaxNoOfFiredTriggers: 4000

TransactionBufferMemory: 10M

 

 

# Scans and buffering #

MaxNoOfConcurrentScans: 300

MaxNoOfLocalScans: 32

BatchSizePerLocalScan: 64

LongMessageBuffer: 20M

 

 

# Logging and Checkpointing #

NoOfFragmentLogFiles: 300

FragmentLogFileSize: 64M

MaxNoOfOpenFiles: 40

InitialNoOfOpenFiles: 27

MaxNoOfSavedMessages: 25

 

 

# Metadata Objects #

MaxNoOfAttributes: 20000

MaxNoOfTables: 2048

MaxNoOfOrderedIndexes: 8000

MaxNoOfUniqueHashIndexes: 8000

MaxNoOfTriggers: 7000

 

 

# Boolean Parameters #

LockPagesInMainMemory: 0

StopOnError: 1

Diskless: 0

ODirect: 0

 

 

# Controlling Timeouts, Intervals, and Disk Paging #

TimeBetweenWatchDogCheck: 6000

TimeBetweenWatchDogCheckInitial: 6000

StartPartialTimeout: 30000

StartPartitionedTimeout: 60000

StartFailureTimeout: 1000000

HeartbeatIntervalDbDb: 2000

HeartbeatIntervalDbApi: 3000

TimeBetweenLocalCheckpoints: 20

TimeBetweenGlobalCheckpoints: 2000

TransactionInactiveTimeout: 0

TransactionDeadlockDetectionTimeout: 1200

DiskSyncSize: 8M

DiskCheckpointSpeed: 20M

DiskCheckpointSpeedInRestart: 200M

ArbitrationTimeout: 10

 

 

# Buffering and Logging #

UndoIndexBuffer: 64M

UndoDataBuffer: 32M

RedoBuffer: 32M

LogLevelStartup: 15

LogLevelShutdown: 3

LogLevelStatistic: 0

LogLevelCheckpoint: 0

LogLevelNodeRestart: 0

LogLevelConnection: 0

LogLevelError: 15

LogLevelCongestion: 0

LogLevelInfo: 3

MemReportFrequency: 0

 

 

# Backup Parameters #

BackupDataBufferSize: 200M

BackupLogBufferSize: 56M

BackupMemory: 256M

BackupWriteSize: 10M

BackupMaxWriteSize: 80M

 

 

[MGM DEFAULT]

PortNumber: 1186

DataDir:/data/mysql/var/lib/mysql-cluster

 

 

[TCP DEFAULT]

SendBufferMemory: 128M

bitsCN.com