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
How can I find out, which tables are affected and how can I fix this?
- alter table ... reorganize partition
- optimize table ...
with the largest tables. But this did not change anything.
Tel. mobil: 015222999584