MySQL Forums
Forum List  »  NDB clusters

Re: How to setup correct values for DataMemory and IndexMemory?
Posted by: Mikael Ronström
Date: June 29, 2005 02:31PM

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

Options: ReplyQuote


Subject
Views
Written By
Posted
Re: How to setup correct values for DataMemory and IndexMemory?
1931
June 29, 2005 02:31PM


Sorry, you can't reply to this topic. It has been closed.

Content reproduced on this site is the property of the respective copyright holders. It is not reviewed in advance by Oracle and does not necessarily represent the opinion of Oracle or any other party.