Sfrgttk

Father gets chickenpox, but doesn't infect his two children. How is this possible?

Are there any rules or guidelines about the order of saving throws?

How to use the viewer node?

Does a star need to be inside a galaxy?

Why does finding small effects in large studies indicate publication bias?

How bad is a Computer Science course that doesn't teach Design Patterns?

Headless horseman claims new head

Which was the first story to feature helmets which reads your mind to control a machine?

Is there a technology capable of disabling the whole of Earth's satellitle network?

Would life expectancy increase if we replaced healthy organs with artificial ones?

Why did Tywin never remarry?

A dragon's soul trapped in a ring of mind shielding wants a new body; what magic could enable her to do so?

Apparently I’m calling random numbers but nothing in call log?

Was Opportunity's last message to Earth "My battery is low and it's getting dark"?

Why Third 'Reich'? Why is 'reich' not translated when 'third' is? What is the English synonym of reich?

Is candidate anonymity at all practical?

Is it appropriate to give a culturally-traditional gift to a female coworker?

Can you make a Spell Glyph of a spell that has the potential to target more than one creature?

Discouraging missile alpha strikes

How to draw these kind of adjacent ovals with arrows in latex?

How can a kingdom keep the secret of a missing monarchy from the public?

Is a particular string regular (e.g is '010') regular?

Found a major flaw in paper from home university – to which I would like to return

How can I ensure that advanced technology remains in the hands of the superhero community?

mysql cluster with innodb utilizing high memory

Why is loading data into MySQL cluster taking so long?MySQL Cluster: Problem Connecting the SQL nodeSetting up MySQL Cluster on Two SystemsLoad balancing MySQL ndbclusterProblem with MySQL Cluster in practiceMysql Server Crashing RegularlyMySQL cluster error: “Got error 4009 'Cluster Failure' from NDB. Could not acquire global schema lock”MySQL InnoDB Configuration with 60Gb of MemoryMySQL Cluster 7.3 - NDB engine - Could not connect to storage engineunable to communicate sql node with management-server

0

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.

[mysqld]



ndbcluster

ndb-connectstring=192.168.0.105,192.168.0.109   # IP address of Management

ndb-cluster-connection-pool=2



[mysql_cluster]



ndb-connectstring=192.168.0.105,192.168.0.109   # IP address of Management Node



[mysqld]



ndbcluster

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

default_storage_engine=ndbcluster     # Define default Storage Engine used by MySQL



[mysql_cluster]



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

 #[mysqld_safe]

 #log-error=/var/log/mysqld.log

 #pid-file=/var/run/mysqld/mysqld.pid



 #log_bin=/var/log/mysql/mysql-bin.log

 #binlog_do_db=radius



 #port = 8881

 #innodb_force_recovery=6

 #innodb_purge_threads=0

mysql innodb linux mysql-cluster ndbcluster

share|improve this question

edited Nov 17 '16 at 2:04

Rick James

42.9k22258

asked Nov 16 '16 at 17:06

Sagar ShindeSagar Shinde

1

bumped to the homepage by Community♦ 2 hours ago

This question has answers that may be good or bad; the system has marked it active so that they can be reviewed.

add a comment | 

0

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.

[mysqld]



ndbcluster

ndb-connectstring=192.168.0.105,192.168.0.109   # IP address of Management

ndb-cluster-connection-pool=2



[mysql_cluster]



ndb-connectstring=192.168.0.105,192.168.0.109   # IP address of Management Node



[mysqld]



ndbcluster

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

default_storage_engine=ndbcluster     # Define default Storage Engine used by MySQL



[mysql_cluster]



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

 #[mysqld_safe]

 #log-error=/var/log/mysqld.log

 #pid-file=/var/run/mysqld/mysqld.pid



 #log_bin=/var/log/mysql/mysql-bin.log

 #binlog_do_db=radius



 #port = 8881

 #innodb_force_recovery=6

 #innodb_purge_threads=0

mysql innodb linux mysql-cluster ndbcluster

share|improve this question

edited Nov 17 '16 at 2:04

Rick James

42.9k22258

asked Nov 16 '16 at 17:06

Sagar ShindeSagar Shinde

1

bumped to the homepage by Community♦ 2 hours ago

This question has answers that may be good or bad; the system has marked it active so that they can be reviewed.

add a comment | 

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.

[mysqld]



ndbcluster

ndb-connectstring=192.168.0.105,192.168.0.109   # IP address of Management

ndb-cluster-connection-pool=2



[mysql_cluster]



ndb-connectstring=192.168.0.105,192.168.0.109   # IP address of Management Node



[mysqld]



ndbcluster

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

default_storage_engine=ndbcluster     # Define default Storage Engine used by MySQL



[mysql_cluster]



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

 #[mysqld_safe]

 #log-error=/var/log/mysqld.log

 #pid-file=/var/run/mysqld/mysqld.pid



 #log_bin=/var/log/mysql/mysql-bin.log

 #binlog_do_db=radius



 #port = 8881

 #innodb_force_recovery=6

 #innodb_purge_threads=0

mysql innodb linux mysql-cluster ndbcluster

share|improve this question

edited Nov 17 '16 at 2:04

Rick James

42.9k22258

asked Nov 16 '16 at 17:06

Sagar ShindeSagar Shinde

1

[mysqld]



ndbcluster

ndb-connectstring=192.168.0.105,192.168.0.109   # IP address of Management

ndb-cluster-connection-pool=2



[mysql_cluster]



ndb-connectstring=192.168.0.105,192.168.0.109   # IP address of Management Node



[mysqld]



ndbcluster

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

default_storage_engine=ndbcluster     # Define default Storage Engine used by MySQL



[mysql_cluster]



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

 #[mysqld_safe]

 #log-error=/var/log/mysqld.log

 #pid-file=/var/run/mysqld/mysqld.pid



 #log_bin=/var/log/mysql/mysql-bin.log

 #binlog_do_db=radius



 #port = 8881

 #innodb_force_recovery=6

 #innodb_purge_threads=0

share|improve this question

edited Nov 17 '16 at 2:04

Rick James

42.9k22258

asked Nov 16 '16 at 17:06

Sagar ShindeSagar Shinde

1

share|improve this question

edited Nov 17 '16 at 2:04

Rick James

42.9k22258

asked Nov 16 '16 at 17:06

Sagar ShindeSagar Shinde

1

edited Nov 17 '16 at 2:04

Rick James

42.9k22258

edited Nov 17 '16 at 2:04

Rick James

42.9k22258

asked Nov 16 '16 at 17:06

Sagar ShindeSagar Shinde

1

asked Nov 16 '16 at 17:06

Sagar ShindeSagar Shinde

1

1 Answer
1

active

oldest

votes

0

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.

share|improve this answer

answered Nov 17 '16 at 2:10

Rick JamesRick James

42.9k22258

• 
  
  
  

  
  

  
  
  
  
  
  

  
  
  innodb_buffer_pool_size=134217728 and I have 8 gb of ram. Today RAM usage increased to 80%
  
  – Sagar Shinde
  Nov 17 '16 at 5:22
  
  
  

  
  
  
  


• 
  
  
  

  
  

  
  
  
  
  
  

  
  
  After restarting the sever it is working normal now.
  
  – Sagar Shinde
  Nov 18 '16 at 6:51
  

  
  
  
  

add a comment | 

Your Answer

StackExchange.ready(function() {
var channelOptions = {
tags: "".split(" "),
id: "182"
};
initTagRenderer("".split(" "), "".split(" "), channelOptions);

StackExchange.using("externalEditor", function() {
// Have to fire editor after snippets, if snippets enabled
if (StackExchange.settings.snippets.snippetsEnabled) {
StackExchange.using("snippets", function() {
createEditor();
});
}
else {
createEditor();
}
});

function createEditor() {
StackExchange.prepareEditor({
heartbeatType: 'answer',
autoActivateHeartbeat: false,
convertImagesToLinks: false,
noModals: true,
showLowRepImageUploadWarning: true,
reputationToPostImages: null,
bindNavPrevention: true,
postfix: "",
imageUploader: {
brandingHtml: "Powered by u003ca class="icon-imgur-white" href="https://imgur.com/"u003eu003c/au003e",
contentPolicyHtml: "User contributions licensed under u003ca href="https://creativecommons.org/licenses/by-sa/3.0/"u003ecc by-sa 3.0 with attribution requiredu003c/au003e u003ca href="https://stackoverflow.com/legal/content-policy"u003e(content policy)u003c/au003e",
allowUrls: true
},
onDemand: true,
discardSelector: ".discard-answer"
,immediatelyShowMarkdownHelp:true
});


}
});

draft saved

draft discarded

Sign up or log in

StackExchange.ready(function () {
StackExchange.helpers.onClickDraftSave('#login-link');
});

Sign up using Google

Sign up using Facebook

Sign up using Email and Password

Post as a guest

Name

Email

Required, but never shown

StackExchange.ready(
function () {
StackExchange.openid.initPostLogin('.new-post-login', 'https%3a%2f%2fdba.stackexchange.com%2fquestions%2f155485%2fmysql-cluster-with-innodb-utilizing-high-memory%23new-answer', 'question_page');
}
);

Post as a guest

Name

Email

Required, but never shown

0

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.

share|improve this answer

answered Nov 17 '16 at 2:10

Rick JamesRick James

42.9k22258

• 
  
  
  

  
  

  
  
  
  
  
  

  
  
  innodb_buffer_pool_size=134217728 and I have 8 gb of ram. Today RAM usage increased to 80%
  
  – Sagar Shinde
  Nov 17 '16 at 5:22
  
  
  

  
  
  
  


• 
  
  
  

  
  

  
  
  
  
  
  

  
  
  After restarting the sever it is working normal now.
  
  – Sagar Shinde
  Nov 18 '16 at 6:51
  

  
  
  
  

add a comment | 

0

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.

share|improve this answer

answered Nov 17 '16 at 2:10

Rick JamesRick James

42.9k22258

• 
  
  
  

  
  

  
  
  
  
  
  

  
  
  innodb_buffer_pool_size=134217728 and I have 8 gb of ram. Today RAM usage increased to 80%
  
  – Sagar Shinde
  Nov 17 '16 at 5:22
  
  
  

  
  
  
  


• 
  
  
  

  
  

  
  
  
  
  
  

  
  
  After restarting the sever it is working normal now.
  
  – Sagar Shinde
  Nov 18 '16 at 6:51
  

  
  
  
  

add a comment | 

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.

share|improve this answer

answered Nov 17 '16 at 2:10

Rick JamesRick James

42.9k22258

share|improve this answer

answered Nov 17 '16 at 2:10

Rick JamesRick James

42.9k22258

answered Nov 17 '16 at 2:10

Rick JamesRick James

42.9k22258

answered Nov 17 '16 at 2:10

Rick JamesRick James

42.9k22258