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
