MySQL Forums
Forum List  »  NDB clusters

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
577
December 08, 2016 11:25AM
292
December 08, 2016 08:02PM
297
December 13, 2016 08:00AM
Re: NDBCluster memory usuage
315
December 13, 2016 09:22AM
274
December 15, 2016 09:04AM
278
December 16, 2016 10:27AM
254
December 23, 2016 05:00AM
256
December 23, 2016 09:39AM


Sorry, you can't reply to this topic. It has been closed.

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.