MySQL Forums
Forum List  »  NDB clusters

How to setup correct values for DataMemory and IndexMemory?
Posted by: Anton Aleksandrov
Date: June 29, 2005 10:55AM

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:

[NDBD DEFAULT]
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
How to setup correct values for DataMemory and IndexMemory?
2663
June 29, 2005 10:55AM


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.