MySQL Cluster online management node configuration file-data node 96 GB memory [ndbd default] NoOfReplicas: 2 # DataDir:/data/mysql/log # FileSystemPath: /add/path/here # Data Memory, Index Memory, and String Memory # DataMemory: 61440 MIndexMemory: 10240 MStringMemory: 50 # Transaction Parameters # MaxNoOfConcurrentTransactions: 204800 rows: 300000 MaxNoOfLocalOperations: 20000 # Transaction Temporary Storage # MaxNoOfConcurrentIndexOperations: 65536 Bytes: 4000 TransactionBufferMemory: 10 M # Scans and buffering # MaxNoOfConcurrentScans: 300 MaxNoOfLocalScans: 32 BatchSizePerLocalScan: 64 LongMessageBuffer: 20 M # Logging and Checkpointing # NoOfFragmentLogFiles: 300 FragmentLogFileSize: 64 MMaxNoOfOpenFiles: 40 InitialNoOfOpenFiles: 27 Objects: 25 # Metadata Objects # Objects: 20000 MaxNoOfTables: 2048 Objects: 8000 Objects: 8000 Objects: 7000 # Boolean Parameters # LockPagesInMainMemory: 0 StopOnError: 1 Diskless: 0 ODirect: 0 # Controlling Timeouts, Intervals, and Disk Paging # Duration: 6000 Duration: 6000 StartPartialTimeout: 30000 StartPartitionedTimeout: 60000 StartFailureTimeout: 1000000 HeartbeatIntervalDbDb: 2000 HeartbeatIntervalDbApi: 3000 Bytes: 20 Bytes: 2000 TransactionInactiveTimeout: 0 bytes: 1200 DiskSyncSize: 8 MDiskCheckpointSpeed: 20 Bytes: 200 MArbitrationTimeout: 10 # Buffering and Logging # UndoIndexBuffer: 64 Protocol: 32 MRedoBuffer: 32 MLogLevelStartup: 15 LogLevelShutdown: 3 LogLevelStatistic: 0 LogLevelCheckpoint: 0 Protocol: 0 LogLevelConnection: 0 LogLevelError: 15 Protocol: 0 LogLevelInfo: 3 MemReportFrequency: 0 # Backup Parameters # BackupDataBufferSize: 200 MBackupLogBufferSize: 56 MBackupMemory: 256 MBackupWriteSize: 10 minutes: 80 M [mgm default] PortNumber: 1186 DataDir: /data/mysql/var/lib/mysql-cluster [tcp default] SendBufferMemory: 128 M