List:Cluster« Previous MessageNext Message »
From:Geert Vanderkelen Date:June 24 2011 3:04pm
Subject:Re: MySQL cluster- migrating from WIndows to Linux
View as plain text  
Subodh,

On Jun 24, 2011, at 16:54 , Subodh Nair wrote:
..
> the ndb process goes up very high and the server hangs saying that not
> enough virtual memory available.
> Both my data nodes have 8 GB of RAM and 8 GB of virtual memory allocated.

Not sure what you mean with Virtual Memory, but if it is anything like SWAP on Linux, it's
bad to relay on it for running data nodes.
You need 4608Mb of RAM, or lets say 5Gb for running your data nodes. If both your machines
have 8Gb, it should be fine, unless other application are using 3Gb.

-Geert

> 
> I have a five node setup,
> 
> 1 mgmt node,
> 2 data nodes and 2 SQL nodes.
> 
> I tried the same version of mysql mysql-5.1.56 ndb-7.1.13 on Redhat 5.1 OS.
> Here also I got the same errors.
> 
> The config.ini is this :
> 
> [ndbd default]
> noofreplicas=2
> DataMemory=4096M
> IndexMemory=512M
> #MaxNoOfConcurrentOperations=5M
> #MaxNoOfLocalOperations=9M
> #MaxNoOfAttributes=10000
> #MaxNoOfOrderedIndexes=256
> TotalSendBufferMemory=16M
> #HeartbeatIntervalDbDb=60000
> #HeartbeatIntervalDbApi=60000
> diskless=1
> #NoOfFragmentLogFiles=32
> Stoponerror=False
> TimeBetweenGlobalCheckPoints=3000
> TimeBetweenLocalCheckPoints=5
> #RedoBuffer=64M
> #DiskSyncSize=30M
> 
> [ndb_mgmd]
> hostname=10.90.90.35
> DataDir=/var/lib/mysql-cluster/data_ars
> 
> [ndbd]
> hostname=10.90.90.28
> DataDir=/var/lib/mysql-cluster/data_ars
> MaxNoOfLocalOperations=6M
> 
> [ndbd]
> hostname=10.90.90.29
> DataDir=/var/lib/mysql-cluster/data_ars
> MaxNoOfLocalOperations=6M
> 
> [mysqld]
> hostname=10.90.90.33
> 
> [mysqld]
> hostname=10.90.90.38
> 
> [mysqld]
> hostname=10.90.90.39
> 
> 
> 
> The error log on the data node is attached. Could you please let me know if
> this a bug with this version? I have also tried the previous 2 versions
> mysql-5.1.56 ndb-7.1.8 and mysql-5.1.56 ndb-7.1.9a. I had the same problems
> in both these versions when I installed them in Linux.
> 
> 
> 
> 
> 
> Best Regards,
> 
> Subodh

-- 
Geert Vanderkelen
Oracle, MySQL Principal Support Engineer

ORACLE Deutschland B.V.&  Co. KG
Registered Office: Riesstr. 25, 80992 Muenchen, Germany
Commercial Register: Local Court Of Munich, HRA 95603

General Partner: ORACLE Deutschland Verwaltung B.V.
Hertogswetering 163/167, 3543 AS Utrecht, The Netherlands
Register Of Chamber Of Commerce: Midden-Nederland, No. 30143697
Managing Directors: Juergen Kunz, Marcel van de Molen, Alexander van der Ven

Thread
[Fwd: RE: MySQL cluster- migrating from WIndows to Linux]Matthew Montgomery25 Mar
  • RE: MySQL cluster- migrating from WIndows to LinuxMatthew Montgomery25 Mar
    • RE: MySQL cluster- migrating from WIndows to LinuxSubodh Nair16 Jun
      • Re: MySQL cluster- migrating from WIndows to LinuxGeert Vanderkelen16 Jun
        • RE: MySQL cluster- migrating from WIndows to LinuxSubodh Nair16 Jun
          • Re: MySQL cluster- migrating from WIndows to LinuxGeert Vanderkelen16 Jun
            • RE: MySQL cluster- migrating from WIndows to LinuxSubodh Nair16 Jun
              • Re: MySQL cluster- migrating from WIndows to LinuxGeert Vanderkelen16 Jun
                • RE: MySQL cluster- migrating from WIndows to LinuxSubodh Nair24 Jun
                  • Re: MySQL cluster- migrating from WIndows to LinuxGeert Vanderkelen24 Jun
                    • RE: MySQL cluster- migrating from WIndows to LinuxSubodh Nair25 Jun
  • RE: MySQL cluster- migrating from WIndows to LinuxSubodh Nair29 Mar
    • RE: MySQL cluster- migrating from WIndows to LinuxStewart Smith29 Mar
      • RE: MySQL cluster- migrating from WIndows to LinuxSubodh Nair29 Mar
        • RE: MySQL cluster- migrating from WIndows to LinuxAndrew Morgan29 Mar
          • RE: MySQL cluster- migrating from WIndows to LinuxSubodh Nair31 Mar
            • Re: MySQL cluster- migrating from WIndows to LinuxGeert Vanderkelen31 Mar
              • RE: MySQL cluster- migrating from WIndows to LinuxSubodh Nair31 Mar