I was referring to the virtual memory I had allocated when I installed this
version(mysql-5.1.56 ndb-7.1.13) of mysql cluster in a Windows 2003 64 bit
server. When I installed it in the Redhat 5.1 64 bit server also I had
allocated 8 GB as the swap space. In both cases, (windows and Linux), both
the data nodes was installed with 8 GB RAM.
Actually when I install the old version of mysql cluster that is running on
my production server for 2 years now, mysql cluster ver7.0.6, there is no
problem at all and everything runs fine. The size of the ndb process also
stays within the data memory allocated in the config.ini file as shown below
But when I install the new versions, I get this excessive usage of RAM and
it does not limit to what is configured in the config.ini file in the mgmt
Is there any difference in the way the data memory and Index memory has to
be defined in config.ini file for the newer versions?
From: Geert Vanderkelen [mailto:geert.vanderkelen@stripped]
Sent: Friday, June 24, 2011 8:35 PM
To: Subodh Nair
Subject: Re: MySQL cluster- migrating from WIndows to Linux
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
> 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
> Here also I got the same errors.
> The config.ini is this :
> [ndbd default]
> The error log on the data node is attached. Could you please let me know
> 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
> in both these versions when I installed them in Linux.
> Best Regards,
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