how to calculate the size of the database with the ndb_size.pl script

[ankush grover]

Hey,

I am using Mysql 4.1 for clustering on Fedora Core 3.I ran the script ndb_size.pl and it output of the script for one of the table is below.

Column Type Size Key 4.1 NDB Size 5.0 NDB Size 5.1 NDB Size
bill_outstanding float(10,2) 4 4 4
bill_date_time date 3 3 3
bill_amount float(10,2) 4 4 4
bill_encounter_nr int 10 MUL 4 4 4
bill_bill_no bigint 20 PRI 8 8 8


Index Type Columns 4.1 IdxMem 5.0 IdxMem 5.1 IdxMem 4.1 DatMem 5.0 DatMem 5.1 DatMem
PRIMARY BTREE bill_bill_no 33 25 25 10 10 10
index_bill_patnum BTREE bill_encounter_nr 29 25 25 10 10 10
DataMemory Usage
4.1 5.0 5.1
Row Overhead 16 16 16
Column DataMemory/Row 23 23 23
Index DataMemory/Row 20 20 20
Total DataMemory/Row 59 59 59
Rows per 32kb page 553 553 553
Current number of rows 3 3 3
Total DataMemory (kb) 32 32 32
IndexMemory Usage
4.1 5.0 5.1
IndexMemory/Row 62 50 50
Rows per 8kb page 132 163 163
Current number of rows 3 3 3
Total IndexMemory (kb) 8 8 8

There are about 160 tables in the database.

How do I calculate how much DataMemory & Index memory should be set for the database ?

Moreover how do I calculate the size of the database with the output like above generated by the script is for each table rather than for the whole database ?

My aim is for these things a) Calculating the size of the database b) How much RAM is needed for storage nodes
and c) How many records can be entered in the database before more RAM is needed that is how many millions of entries are possible with the initial RAM(for ex 10GB).

Please guide me.


Thanks & Regards

Ankush Grover