Sample Header Ad - 728x90

Excessive RAM consumption in MySQL Cluster

1 vote
1 answer
749 views
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> 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> 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?
Asked by Jonathan Diaz (11 rep)
Nov 17, 2017, 12:50 AM
Last activity: Mar 22, 2025, 03:05 PM