MySQL Forums :: NDB clusters :: NDBCluster memory usuage


Advanced Search

Re: NDBCluster memory usuage
Posted by: Karthick Subramaniam ()
Date: December 13, 2016 09:22AM

THanks for your response. As you said we have many activity tables with fixed lengtg varchar columns along with text. We also have some blob columns as well. For ex:

ID_ Varchar(192;utf8_bin) PRIMARY KEY DISTRIBUTION KEY AT=SHORT_VAR ST=MEMORY
TYPE_ Longvarchar(765;utf8_bin) NOT NULL AT=MEDIUM_VAR ST=MEMORY
PROC_INST_ID_ Varchar(192;utf8_bin) NULL AT=SHORT_VAR ST=MEMORY
EXECUTION_ID_ Varchar(192;utf8_bin) NULL AT=SHORT_VAR ST=MEMORY
TASK_ID_ Varchar(192;utf8_bin) NULL AT=SHORT_VAR ST=MEMORY
ACT_INST_ID_ Varchar(192;utf8_bin) NULL AT=SHORT_VAR ST=MEMORY
NAME_ Longvarchar(765;utf8_bin) NOT NULL AT=MEDIUM_VAR ST=MEMORY
VAR_TYPE_ Longvarchar(765;utf8_bin) NULL AT=MEDIUM_VAR ST=MEMORY
BYTEARRAY_ID_ Varchar(192;utf8_bin) NULL AT=SHORT_VAR ST=MEMORY
TEXT_ Text(256,2000,0;utf8_bin) NULL AT=MEDIUM_VAR ST=MEMORY BV=2 BT=NDB$BLOB_471_13
TEXT2_ Text(256,2000,0;utf8_bin) NULL AT=MEDIUM_VAR ST=MEMORY BV=2 BT=NDB$BLOB_471_14

Is it worth to implement moving the tables to Disk tables to save the memory. Since We have 62% of total memory occupied by cluster now.

Is there any other to reduce the memory like doing optimize tables and partitions.

Options: ReplyQuote


Subject Views Written By Posted
NDBCluster memory usuage 373 Karthick Subramaniam 12/08/2016 11:25AM
Re: NDBCluster memory usuage 171 Stefan Auweiler 12/08/2016 08:02PM
Re: NDBCluster memory usuage 176 Mikael Ronström 12/13/2016 08:00AM
Re: NDBCluster memory usuage 188 Karthick Subramaniam 12/13/2016 09:22AM
Re: NDBCluster memory usuage 162 Mikael Ronström 12/15/2016 09:04AM
Re: NDBCluster memory usuage 167 Karthick Subramaniam 12/16/2016 10:27AM
Re: NDBCluster memory usuage 149 Mikael Ronström 12/23/2016 05:00AM
Re: NDBCluster memory usuage 146 Karthick Subramaniam 12/23/2016 09:39AM


Sorry, only registered users may post in this forum.

Content reproduced on this site is the property of the respective copyright holders. It is not reviewed in advance by Oracle and does not necessarily represent the opinion of Oracle or any other party.