List:Cluster« Previous MessageNext Message »
From:Hendrik Woltersdorf Date:January 30 2013 10:29am
Subject:uneven data distribution, how to fix this?
View as plain text  
Hi,

in a test system we have a very uneven data distribution:

ndb_mgm> all report memory;
Node 10: Data usage is 55%(66989 32K pages of total 120000)
Node 10: Index usage is 10%(6657 8K pages of total 64032)
Node 11: Data usage is 14%(17221 32K pages of total 120000)
Node 11: Index usage is 10%(6654 8K pages of total 64032)

This started when one datanode was offline for a week due to failing 
hardware.

How can I find out, which tables are affected and how can I fix this?

I tried:
- alter table ... reorganize partition
- optimize table ...
with the largest tables. But this did not change anything.

-- 
regards

Hendrik Woltersdorf
XCOM AG
Tel.: 0375/27008-580
Tel. mobil: 015222999584
Email:Hendrik.Woltersdorf@stripped

Thread
uneven data distribution, how to fix this?Hendrik Woltersdorf30 Jan
Re: uneven data distribution, how to fix this?Hendrik Woltersdorf30 Jan