MySQL Forums
Forum List  »  NDB clusters

Re: Data Node Won't Start: Internal program error (failed ndbrequire)
Posted by: Mauritz Sundell
Date: November 16, 2020 12:16PM

If a table have shrunken much in size, its memory usage may still be higher than actual data.

Row data are stored on pages, when rows are deleted it may leave pages partly filled.

The whole page is counted into the memory usage even if partly filled.

The empty unused space in pages will be reused when new rows are inserted.

To verify that both nodes have the same data one can check the row count for each table on each node:

mysql> select fq_name,node_id,SUM(fixed_elem_count) row_count from ndbinfo.memory_per_fragment group by fq_name,node_id;

If there are no writes to the table the row count on both nodes should match.

If there are writes ongoing the numbers can fluctuate depending on the load.

For more information about ndbinfo tables:

Options: ReplyQuote

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.