List:Cluster« Previous MessageNext Message »
From:Jason Brooke Date:November 11 2011 1:32pm
Subject:Re: Problem When Set DataMemory in MySQL cluster
View as plain text  
How much memory do your data nodes have?



On 11/11/2011 12:12, Ridd1ck wrote:
> View My 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
>
> --
> View this message in context:
> http://mysql-cluster.1050023.n4.nabble.com/Problem-When-Set-DataMemory-in-MySQL-cluster-tp4020307p4031204.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