MySQL Forums
Forum List  »  NDB clusters

DataMemory uses 2x table size
Posted by: d g
Date: May 25, 2016 08:59AM

Hi guys,

i just setup a mysql-cluster with 2 datanodes. Im useing tablespace to reduce memory consumtion. I noticed that still the doubleof the size of my table allocated in memory. Im restoring a dump which creates the table as follows:

create table test "some data" TABLESPACE ts_tablespace STORAGE DISK ENGINE=ndbcluster;

my table size is the following:
+----------------+------------+-----------------+
| Table Name | Rows Count | Table Size (MB) |
+----------------+------------+-----------------+
| test | 614360 | 93.22 |
+----------------+------------+-----------------+

memory consumption of all nodes:
Connected to Management Server at: localhost:1186
Node 3: Data usage is 1%(6560 32K pages of total 384000)
Node 3: Index usage is 0%(1156 8K pages of total 131136)
Node 4: Data usage is 1%(6504 32K pages of total 384000)
Node 4: Index usage is 0%(1156 8K pages of total 131136)



its the only table on the cluster an the memory consumption of datamemory is around 200MB. How can i reduce this datamemory consumption ?

Regards
Denny

Options: ReplyQuote


Subject
Views
Written By
Posted
DataMemory uses 2x table size
1500
d g
May 25, 2016 08:59AM
547
d g
May 26, 2016 02:47AM


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.