List:Cluster« Previous MessageNext Message »
From:umapathi b Date:November 14 2011 1:07pm
Subject:Re: Problem When Set DataMemory in MySQL cluster
View as plain text  
I think you have given very less DataMemory and IndexMemory even though
you are having 20 Gigs of memory.

Try to keep those parameters ..as per your data requirements ..
Make sure the addition of these Datamemory and Indexmemory doesn't cross
the memory available / the importing data size of your db.
and start the cluster with --initial mode and see ..

- Umapathi.

On Mon, Nov 14, 2011 at 6:33 PM, Ridd1ck <Ridd1ck.ste@stripped> wrote:

> 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.
>
> --
> MySQL Cluster Mailing List
> For list archives: http://lists.mysql.com/cluster
> To unsubscribe:
> http://lists.mysql.com/cluster?unsub=1
>
>

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