ndb_size.pl - automagically working out DataMemory and IndexMemory requirements

[Stewart Smith]

(This is a copy&paste of my message to the cluster mailing list. See there for the actual files).

This is an early version of ndb_size.pl, a script that's being developed to automatically calculate the storage requirements for different versions of MySQL Cluster.

This version does have some bugs, so don't expect it to be perfect.

Bugs:
- doesn't deal with alignment
- enum/set is 0 byte storage! Woah - efficient!
- some float stores come out weird (when there's a comma e.g. float(4,1)')
- no disk data values
- computes the storage requirements of views (and probably MERGE)
- ignores character sets.

So it's more of a guide than anything else.

You will need:
- perl
- the DBD::mysql module
- the HTML::Template module

Use:
$ perl ndb_size.pl dbname host port user password

Please test and report back your success/failure.

Comments and suggestions are welcome.

I've included example output: ndb_size.html.gz (gzipped html).

Stewart Smith, Software Engineer - MySQL Cluster
MySQL AB, www.mysql.com

Jumpstart your cluster:
http://www.mysql.com/consulting/packaged/cluster.html