MySQL Forums
Forum List  »  NDB clusters

Advanced Search
New Topic

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

Navigate: Previous Message• Next Message
Options: Reply• Quote


Subject
Views
Written By
Posted
How to setup correct values for DataMemory and IndexMemory?
2752
Anton Aleksandrov
June 29, 2005 10:55AM
Re: How to setup correct values for DataMemory and IndexMemory?
1933
Mikael Ronström
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.