欢迎您访问程序员文章站本站旨在为大家提供分享程序员计算机编程知识!
您现在的位置是: 首页  >  数据库

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

程序员文章站 2022-05-06 14:31:55
...
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
相关标签: 配置文件