Calculating DataMemory and IndexMemory
Before a migration to a MySQL Cluster, it is likely that you will want to be sure that the resources available are sufficient to handle the proposed cluster. Generally, MySQL Clusters are more memory intensive than anything else, and this recipe explains how you can estimate your memory usage in advance.
The script that is used in this recipe,
ndb_size.pl, is provided by MySQL Cluster in a cluster binary. In the See also section, an alternative and more accurate tool is mentioned.
ndb_size.pl is excellent for estimates, but it is worth remembering that it is only an estimate based on, sometimes inaccurate, assumptions.
This recipe demonstrates how to estimate, from a table scheme or an existing ...