Excessive RAM consumption in MySQL Cluster at this moment I have configured a cluster that has 5 nodes:

2 data nodes
2 SQL nodes
1 node manager

My file.config.ini is the following:

[ndbd default]

NoOfReplicas = 2 # Number of replicas
DataMemory = 256M IndexMemory = 100M
ServerPort = 2202.
MaxNoOfConcurrentTransactions = 429496
MaxNoOfConcurrentOperations = 472496
MaxNoOfLocalOperations = 519745

[ndb_mgmd]

NodeId = 1
HostName = 192.168.10.145 # Hostname or IP address of MGM node
DataDir = / var / lib / mysql-cluster # Directory for MGM node log files

[ndbd]


HostName = 192.168.10.181 # Hostname or IP address
NodeId = 2 # Node ID for this data node
DataDir = / mnt / dataPartition / mysql / data # Directory for this data node's data files

[ndbd]

HostName = 192.168.10.183 # Hostname or IP address
NodeId = 3 # Node ID for this data node
DataDir = / mnt / dataPartition / mysql / data # Directory for this data node's data files

[mysqld]

HostName = 192.168.10.140 # Hostname or IP address
                                # (additional mysqld connections can be
                                # specified for this node for various
                                # purposes such as running ndb_restore)

[mysqld]

HostName = 192.168.10.184 # Hostname or IP address
                                # (additional mysqld connections can be
                                # specified for this node for various
                                # purposes such as running ndb_restore)

[mysqld]


IN THE NDB_MGM REPORT, IT SAYS THE FOLLOWING:

ndb_mgm&gt; 2 REPORT MEMORYUSAGE
Node 2: Data usage is 18% (1476 32K pages of total 8192)
Node 2: Index usage is 11% (1461 8K pages of total 12832)
ndb_mgm&gt; 3 REPORT MEMORYUSAGE
Node 3: Data usage is 18% (1480 32K pages of total 8192)
Node 3: Index usage is 11% (1462 8K pages of total 12832)


Each data node has 2gb of ram, it is assumed that with this configuration should not consume more than 500 mb of ram the ndbd process, but I am consuming 1.89 gb of ram per node, I am using disk storage for the fields that they are not indexed

What is wrong or what is wrong?
The 429496 transaction records consume around 400 MBytes
(around 900 bytes per record).

The operation records consume also around 400 MBytes,
around 300 bytes in transaction coordinator and
500 bytes in ldm thread.

In addition it uses memory for a lot of other buffers such
as REDO buffers, SEND buffers, job buffers. These normally
consume a few hundred MBytes.

In addition you can decrease memory usage by setting
BatchSizePerLocalScan to a smaller value (e.g. 16).
This should save a few hundred MBytes of memory space.