Re: NDBCluster memory usuage

[Karthick Subramaniam]

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.