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.
Note
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.
Getting ready
This recipe demonstrates how to estimate, from a table scheme or an existing ...
Get High Availability MySQL Cookbook now with the O’Reilly learning platform.
O’Reilly members experience books, live events, courses curated by job role, and more from O’Reilly and nearly 200 top publishers.
