I have implemented MySQL cluster with two data, sql and management node respectively. On one of the sql node I have ndb as well innodb engine for the huge tables which I can not able to convert into ndb-cluster engine. But after few days the sql node with innodb engine started eating large amount of physical memory it is increasing rapidly. Show processlist is not showing any running processes. I am clueless now where is MySQL consuming this RAM. I am worried if my server goes out of memory. One week ago I have uploaded 30GB of data but right now it is not used by any of the application. I have observed increase In ram usage goes 20% to 75% within a week after that data upload.


ndb-connectstring=,   # IP address of Management


ndb-connectstring=,   # IP address of Management Node


ndb-connectstring=,       # IP address for server management node
default_storage_engine=ndbcluster     # Define default Storage Engine used by MySQL


ndb-connectstring=,       # IP address for server management node


 #port = 8881

The main memory usage in an SQL node is for InnoDB's buffer pool. What is the value of innodb_buffer_pool_size? (Use SHOW VARIABLES LIKE 'innodb_buffer_pool_size';) How much RAM do you have? Normally, it should be set to about 70% of RAM. The memory usage will grow until it hits the setting. After that it will fluctuate slightly as other allocations come and go.

  • innodb_buffer_pool_size=134217728 and I have 8 gb of ram. Today RAM usage increased to 80% Nov 17 '16 at 5:22
  • After restarting the sever it is working normal now. Nov 18 '16 at 6:51

Your Answer

By clicking “Post Your Answer”, you agree to our terms of service, privacy policy and cookie policy

Not the answer you're looking for? Browse other questions tagged or ask your own question.