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
>
>
