Re: How to setup correct values for DataMemory and IndexMemory?

[Mikael Ronström]

The configuration of DataMemory and IndexMemory is per node so you want to set
it to
DataMemory 1100 MB
IndexMemory 550 MB
this in total you get 6600 MB and with replication taken into account 3300 MB of
space.

Your current configuration will allocate 6.3 GB per data node and they will start swapping
heavily when you start using them which you have found a couple of cases what that can
cause.

Rgrds Mikael


Anton Aleksandrov wrote:
> Hello.
> That's quite urgent and hopeless issue for us now.
> We have 6 DB nodes each with 2Gb of RAM. In
> cluster's config we have:
>
>
> NoOfReplicas=2
> DataMemory=4000MB
> IndexMemory=2000Mb
> MaxNoOfAttributes=10000
> MaxNoOfOrderedIndexes=10000
> MaxNoOfUniqueHashIndexes=5000
>
> But when client trie to insert a data, especially
> to a table with 5mln records, then it breaks with
> different errors - lock timeout exceeded, can't
> lock file and so on. I suspect something is wrong
> in configuration, probably RAM is full, as ndbd
> takes 97% of ram. Can anyone please advice
> anything on this issue?
> When I run a backup, it says - that backup has
> size like 4.1G.
>
> Thanks..