Need help calculating the individual NDB table index/data memory size.
I have been looking online for a solid method for determining the individual table sizes in an NDB and I have not found a way to get this data for each table in the NDB. I will list the methods I have already used to gather the data and what was determined to be the reason the method was not valid.
The first was to obtain the Avg_row_length using the SHOW TABLE STATUS <table_name> and use that value to multiply by the Rows to get a value in bytes. The problem with this calculation is that it does not provide the index memory nor the data memory that is utilized in the NDB for this table. This data was captured by using the following query that is being ran on the NDB SQL API node.