[NDB_MGMD DEFAULT] DataDir=/opt/mysql/cluster [NDB_MGMD] Id=1 HostName=127.0.0.1 LogDestination=FILE:filename=/opt/mysql/cluster/cluster-log ArbitrationRank=1 [NDB_MGMD] Id=9 HostName=127.0.0.1 LogDestination=FILE:filename=/opt/mysql/cluster/cluster-log10 PortNumber=1187 [NDBD DEFAULT] NoOfReplicas=2 DataDir=/opt/mysql/cluster # #ERROR 1297 (HY000): Got temporary error 233 'Out of operation records in transaction coordinator (increase MaxNoOfConcurrentOperations)' from NDBCLUSTER # MaxNoOfConcurrentOperations=40000 #MaxNoOfConcurrentTransactions=500 # # ERROR 1296 (HY000): Got error 625 'Out of memory in Ndb Kernel, hash index part (increase IndexMemory)' from NDB # #IndexMemory=2M # # ERROR 1296 (HY000): Got error 827 'Out of memory in Ndb Kernel, table data (increase DataMemory)' from NDB # DataMemory=100M #Up this when you got a lot of: #ERROR 1297 (HY000): Got temporary error 266 'Time-out in NDB, probably caused by deadlock' from NDB #default: 1200 msecs #TransactionDeadlockDetectionTimeout=1200 # # No of 4 * 16 M = 64M redo files # ERROR 1297 (HY000): Got temporary error 1220 'REDO log files overloaded, consult online manual (decrease TimeBetweenLocalCheckpoints, and|or incre' from NDB # ERROR 1297 (HY000): Got temporary error 410 'REDO log files overloaded, consult online manual (decrease TimeBetweenLocalCheckpoints, and|or incre' from NDB # NoOfFragmentLogFiles=40 #Max amount of bytes before synching data to LCP file. Default: 4194304 = 4M #DiskSyncSize=64M #DiskSyncSize=1M #Bytes per second sent to disk during LCP. Default: 10485760 = 10M DiskCheckpointSpeed=50M #Bytes per second sent to disk during LCP #Default: 10M #DiskCheckpointSpeedInRestart=10M # #ERROR 1297 (HY000): Got temporary error 1221 'REDO buffers overloaded, consult online manual (increase RedoBuffer)' from NDB #Default: 8M # #RedoBuffer=32M #LogLevelCheckpoint=15 #LogLevelConnection=15 #LogLevelError=15 #LogLevelInfo=15 #LogLevelNodeRestart=15 #LogLevelShutdown=15 #LogLevelStartup=15 #LogLevelStatistic=15 [NDBD] Id=2 HostName=127.0.0.1 [NDBD] Id=3 HostName=127.0.0.1 [MYSQLD DEFAULT] ArbitrationRank=2 [MYSQLD] Id=4 HostName=127.0.0.1 [MYSQLD] #Id=5 #HostName=127.0.0.1 [API] #[TCP DEFAULT] #SendBufferMemory=1048576 #ReceiveBufferMemory=1048576 #[TCP] #SendBufferMemory=1048576 #ReceiveBufferMemory=1048576 #NodeId1=2 #HostName1=127.0.0.1 #NodeId2=3 #HostName2=127.0.0.1 #[TCP] #SendBufferMemory=1048576 #ReceiveBufferMemory=1048576 #NodeId1=2 #HostName1=127.0.0.1 #NodeId2=4 #HostName2=127.0.0.1 #[TCP] #SendBufferMemory=1048576 #ReceiveBufferMemory=1048576 #NodeId1=3 #HostName1=127.0.0.1 #NodeId2=4 #HostName2=127.0.0.1