config.ini
[NDBD DEFAULT]
NoOfReplicas=2
DataMemory=1900M
IndexMemory=512M
LockPagesInMainMemory=1
MaxNoOfConcurrentOperations=100000
MaxNoOfConcurrentTransactions=16384
StringMemory=25
MaxNoOfTables=20320
MaxNoOfOrderedIndexes=10160
MaxNoOfUniqueHashIndexes=2540
MaxNoOfAttributes=121920
MaxNoOfTriggers=71120
FragmentLogFileSize=256M
InitFragmentLogFiles=SPARSE
NoOfFragmentLogFiles=300
RedoBuffer=64M
TimeBetweenLocalCheckpoints=6
[MYSQLD DEFAULT]
[NDB_MGMD DEFAULT]
[TCP DEFAULT]
# Section for the cluster management node
[NDB_MGMD]
# IP address of the management node (this system)
HostName=192.168.1.1
# Section for the storage nodes
[NDBD]
# IP address of the first storage node
HostName=192.168.1.10
DataDir=/var/lib/mysql-cluster
[NDBD]
# IP address of the second storage node
HostName=192.168.1.20
DataDir=/var/lib/mysql-cluster
# one [MYSQLD] per storage node
[MYSQLD]
HostName=192.168.1.10
[MYSQLD]
HostName=192.168.1.20
i'm running as root and the limitations are the default also free-m command
output is:
free -m:
total used free shared buffers cached
Mem: 24160 2378 21781 0 197 1542
-/+ buffers/cache: 638 23521
Swap: 8190 0 8190
--
View this message in context:
http://mysql-cluster.1050023.n4.nabble.com/Problem-When-Set-DataMemory-in-MySQL-cluster-tp4020307p4039383.html
Sent from the MySQL - Cluster mailing list archive at Nabble.com.
