MySQL Forums
Forum List  »  NDB clusters

Re: Not RAM but hard drive...
Posted by: Jonathan Stephens
Date: March 20, 2005 06:29PM

> How do I know how much RAM I really need? Can I go by the file
> sizes of the data and index files, or does the data need way more
> (or less) space in memory compared to the files?

You can get an estimate of the memory required by using the formula

(SizeofDatabase * NumberOfReplicas * 1.1 ) / NumberOfStorageNodes

For SizeOfDatabase you should be able to use the sum of the sizes of all data and index files on disk.

If you have many VARCHAR fields, then you will likely need a bit more memory than that, because this column type is actually treated as fixed-width by the NDB Cluster engine.

Jon Stephens
MySQL Documentation Team @ Oracle

MySQL Dev Zone
MySQL Server Documentation
Oracle

Options: ReplyQuote


Subject
Views
Written By
Posted
3301
February 19, 2005 06:02AM
2194
February 23, 2005 03:41AM
2060
March 13, 2005 09:58AM
2295
March 18, 2005 12:10PM
Re: Not RAM but hard drive...
2455
March 20, 2005 06:29PM
2505
March 23, 2005 11:02AM
2248
March 23, 2005 12:06PM
2025
March 24, 2005 06:46PM


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.