[NDB_MGMD DEFAULT] PortNumber=1186 Datadir=/var/lib/mysql-cluster ArbitrationRank=1 [NDB_MGMD] Id=1 Hostname=192.168.1.1 [NDB_MGMD] Id=2 Hostname=192.168.1.2 [NDBD DEFAULT] NoOfReplicas=2 Datadir=/usr/local/mysql/data FileSystemPathDD=/usr/local/mysql/data FileSystemPathUndoFiles=/usr/local/mysql/data0 FileSystemPathDataFiles=/usr/local/mysql/data1 DataMemory=1048M IndexMemory=256M MaxNoOfConcurrentOperations=300000 #String Memory is for size of table name/ and .frm files. Stores in % till 100 after 100 it is stored in bytes. StringMemory=25 MaxNoOfTables=4096 #MaxNoOfOrderedIndexes sets the total number of hash indexes that can be in use in the system at any one time (includes Primary as well as unique indexes) #MaxNoOfOrderedIndexes=128 #For unique index #MaxNoOfUniqueHashIndexes=512 MaxNoOfAttributes=24576 #This is the default size . The amount of data,in bytes per second, that is sent to disk during a local checkpoint as part of a restart operation. DiskCheckpointSpeedInRestart=100M #specify size of individual file size of fragment files. FragmentLogFileSize=256M #Force all bytes of the fragment log file to be written to disk. InitFragmentLogFiles=FULL #sets the number of REDO log files for the node NoOfFragmentLogFiles=6 #increased default size RedoBuffer=128M #Default value TimeBetweenLocalCheckpoints=20 #default value has been reduced by 1000 milliseconds. default values = 2000 millisenconds TimeBetweenGlobalCheckpoints=2000 #Default value TimeBetweenEpochs=100 #MemReportFrequency=30 BackupReportFrequency=10 #Params for setting logging LogLevelStartup=15 LogLevelShutdown=15 LogLevelCheckpoint=8 LogLevelNodeRestart=15 #Watchdog #Default value TimeBetweenWatchdogCheckInitial=60000 TotalSendBufferMemory=4M SendBufferMemory=2M #DISK DATA #Change this from default 20M to a larger value when using Disk Data Tables SharedGlobalMemory = 384M #Amount of memory used for caching pages on disk, default 64M #Set this as high as possible when using lots of disk data tables DiskPageBufferMemory = 1024M #0.8 x (total memory – (OS memory + [buffer memory + DataMemory + IndexMemory]) #Multithreading MaxNoOfExecutionThreads=2 [NDBD] Id=3 Hostname=192.168.1.3 [NDBD] Id=4 Hostname=192.168.1.4 [MYSQLD DEFAULT] BatchSize=512 [MYSQLD] Id=7 Hostname=192.168.1.3 [MYSQLD] Id=8 Hostname=192.168.1.4 [MYSQLD] Id=9 Hostname= [MYSQLD] Id=10 Hostname=