[NDBD DEFAULT] NoOfReplicas=2 DataMemory=36G IndexMemory=4G MaxNoOfExecutionThreads=12 NoOfFragmentLogParts=8 LockPagesInMainMemory=1 NoOfFragmentLogFiles=30 FragmentLogFileSize=256M InitFragmentLogFiles=SPARSE RedoBuffer=64M UndoDataBuffer=128M UndoIndexBuffer=64M StringMemory=25 TransactionBufferMemory=8M SharedGlobalMemory=384M DiskPageBufferMemory=512M BatchSizePerLocalScan=512 ODirect=true MaxNoOfConcurrentTransactions=16384 MaxNoOfConcurrentOperations=300000 MaxNoOfTables=500 MaxNoOfAttributes=24576 MaxNoOfOrderedIndexes=1000 MaxNoOfUniqueHashIndexes=500 MaxNoOfTriggers=4000 ### Params for LCP MinDiskWriteSpeed=10M MaxDiskWriteSpeed=20M MaxDiskWriteSpeedOtherNodeRestart=50M MaxDiskWriteSpeedOwnRestart=200M TimeBetweenLocalCheckpoints=20 TimeBetweenGlobalCheckpoints=1000 TimeBetweenEpochs=100 TimeBetweenEpochsTimeout=32000 LcpScanProgressTimeout=1800 MemReportFrequency=60 BackupReportFrequency=10 LogLevelStartup=15 LogLevelShutdown=15 LogLevelCheckpoint=8 LogLevelNodeRestart=15 ### Heartbeating HeartbeatIntervalDbDb=15000 HeartbeatIntervalDbApi=15000 ### Params for BACKUP BackupMaxWriteSize=1M BackupDataBufferSize=24M BackupLogBufferSize=16M ### Watchdog TimeBetweenWatchdogCheckInitial=60000 TransactionInactiveTimeout=30000 TransactionDeadlockDetectionTimeout=15000 MaxBufferedEpochs=100000 ### New 7.1.10 redo logging parameters RedoOverCommitCounter=3 RedoOverCommitLimit=20 ### Increasing the LongMessageBuffer b/c of a bug (20090903) LongMessageBuffer=16M TotalSendBufferMemory=256M # Plattenplatzsparen HW 20141212 CompressedLCP=1 [MYSQLD DEFAULT] DefaultOperationRedoProblemAction=QUEUE BatchSize=512 TotalSendBufferMemory=32M [NDB_MGMD DEFAULT] [TCP DEFAULT] #SendBufferMemory=8M #ReceiveBufferMemory=8M [NDB_MGMD] HostName=10.40.55.146 datadir=/db-data/mysqlcluster LogDestination=FILE:filename=ndb_1_cluster.log,maxsize=33554432,maxfiles=10 NodeId=1 ArbitrationRank=1 [NDB_MGMD] HostName=10.40.55.147 datadir=/db-data/mysqlcluster LogDestination=FILE:filename=ndb_2_cluster.log,maxsize=33554432,maxfiles=10 NodeId=2 ArbitrationRank=1 [NDBD] HostName=10.40.55.148 DataDir=/db-data/mysqlcluster FileSystemPathDD=/db-data/mysqldisktablespace NodeId=10 [NDBD] HostName=10.40.55.149 DataDir=/db-data/mysqlcluster FileSystemPathDD=/db-data/mysqldisktablespace NodeId=11 [MYSQLD] Hostname=10.40.55.146 NodeId=20 [MYSQLD] HostName=10.40.55.147 NodeId=21 [MYSQLD] NodeId=22 #Zusatz-Slots fuer die SQL-Nodes [MYSQLD] Hostname=10.40.55.146 NodeId=23 [MYSQLD] HostName=10.40.55.147 NodeId=24 [MYSQLD] Hostname=10.40.55.146 NodeId=25 [MYSQLD] HostName=10.40.55.147 NodeId=26 [MYSQLD] Hostname=10.40.55.146 NodeId=27 [MYSQLD] HostName=10.40.55.147 NodeId=28 [MYSQLD] Hostname=10.40.55.146 NodeId=29 [MYSQLD] HostName=10.40.55.147 NodeId=30 [MYSQLD] Hostname=10.40.55.146 NodeId=31 [MYSQLD] HostName=10.40.55.147 NodeId=32 [MYSQLD] Hostname=10.40.55.146 NodeId=33 [MYSQLD] HostName=10.40.55.147 NodeId=34 [MYSQLD] Hostname=10.40.55.146 NodeId=35 [MYSQLD] HostName=10.40.55.147 NodeId=36 [MYSQLD] Hostname=10.40.55.146 NodeId=37 [MYSQLD] HostName=10.40.55.147 NodeId=38 [MYSQLD] Hostname=10.40.55.146 NodeId=39 [MYSQLD] HostName=10.40.55.147 NodeId=40 # extra slots [MYSQLD] NodeId=41 [MYSQLD] NodeId=42 [MYSQLD] NodeId=43 [MYSQLD] NodeId=44 ## 3. SQL-Knoten [MYSQLD] HostName=10.40.55.150 NodeId=45 [MYSQLD] HostName=10.40.55.150 NodeId=46 [MYSQLD] HostName=10.40.55.150 NodeId=47 [MYSQLD] HostName=10.40.55.150 NodeId=48 [MYSQLD] HostName=10.40.55.150 NodeId=49 [MYSQLD] HostName=10.40.55.150 NodeId=50 [MYSQLD] HostName=10.40.55.150 NodeId=51 [MYSQLD] HostName=10.40.55.150 NodeId=52 [MYSQLD] HostName=10.40.55.150 NodeId=53 [MYSQLD] HostName=10.40.55.150 NodeId=54