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
Subject
Views
Written By
Posted
DataMemory uses 2x table size
1626
May 25, 2016 08:59AM
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.