Hi.
Please answer the questions below. It's realy important for me.
1. Here
http://www.mysql.com/products/database/cluster/faq.html mentioned that recommended volume of the RAM is 16Gb
and recommended processor is Intel Xeon Processors. Xeon is 32 bit architecture processor and it can
address just 4Gb for single process. In this case the NDB node can store less than 4Gb of data. Isn't it?
My question: I don't understand why do I need 16Gb RAM?
2. In my cluster I have 2 NDB nodes. ndb default section is:
NoOfReplicas=2
DataMemory=960M
IndexMemory=240M
the guaranted free memory is 1400Mb.
The single record takes 603 bytes and its indexes take 140 bytes.
Thus, the cluster can contain about 1 600 000 records (1006632960 / 603 = 1669374). But realy I can upload less than
700 000 records!!! And I don't understand why!
My question: What can cause it? What should I pay attention to?
Thnx!
--Evgeny Sosnin