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
553
December 08, 2016 11:25AM
276
December 08, 2016 08:02PM
281
December 13, 2016 08:00AM
Re: NDBCluster memory usuage
300
December 13, 2016 09:22AM
261
December 15, 2016 09:04AM
258
December 16, 2016 10:27AM
241
December 23, 2016 05:00AM
243
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.