List:Cluster« Previous MessageNext Message »
From:Ridd1ck Date:November 14 2011 1:03pm
Subject:Re: Problem When Set DataMemory in MySQL cluster
View as plain text  
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.
Thread
Problem When Set DataMemory in MySQL clusterRidd1ck9 Nov
  • Re: Problem When Set DataMemory in MySQL clusterWagner Bianchi9 Nov
    • Re: Problem When Set DataMemory in MySQL clusterRidd1ck9 Nov
      • Re: Problem When Set DataMemory in MySQL clusterRidd1ck10 Nov
        • Re: Problem When Set DataMemory in MySQL clusterRidd1ck11 Nov
          • Re: Problem When Set DataMemory in MySQL clusterWagner Bianchi11 Nov
            • Re: Problem When Set DataMemory in MySQL clusterRidd1ck11 Nov
              • Re: Problem When Set DataMemory in MySQL clusterJason Brooke11 Nov
                • Re: Problem When Set DataMemory in MySQL clusterRidd1ck11 Nov
                  • Re: Problem When Set DataMemory in MySQL clusterJason Brooke11 Nov
                    • Re: Problem When Set DataMemory in MySQL clusterRidd1ck11 Nov
                      • Re: Problem When Set DataMemory in MySQL clusterJason Brooke11 Nov
                        • Re: Problem When Set DataMemory in MySQL clusterRidd1ck11 Nov
                          • Re: Problem When Set DataMemory in MySQL clusterRidd1ck14 Nov
                            • Re: Problem When Set DataMemory in MySQL clusterJohan Andersson14 Nov
                              • Re: Problem When Set DataMemory in MySQL clusterRidd1ck14 Nov
                                • Re: Problem When Set DataMemory in MySQL clusterumapathi b14 Nov
                                  • Re: Problem When Set DataMemory in MySQL clusterRidd1ck14 Nov
                                    • Re: Problem When Set DataMemory in MySQL clusterRidd1ck14 Nov
                                      • Re: Problem When Set DataMemory in MySQL clusterRidd1ck14 Nov
                                        • Re: Problem When Set DataMemory in MySQL clusterJohan Andersson14 Nov