Bug #21204 ndb_size.pl doesn't take extended BLOB/TEXT size into account
Submitted: 21 Jul 2006 7:56 Modified: 8 Jun 2007 21:58
Reporter: Hartmut Holzgraefe Email Updates:
Status: Closed Impact on me:
Category:MySQL Cluster: Cluster (NDB) storage engine Severity:S3 (Non-critical)
Version:* OS:Any (*)
Assigned to: Stewart Smith CPU Architecture:Any
Tags: cluster memory monitoring

[21 Jul 2006 7:56] Hartmut Holzgraefe
TEXT/BLOB field sizes are not really taken into account, only a fixed ammount of 256 Bytes per field is added to the results.

This makes the script results more or less meaningless as soon as tables with BLOB or TEXT fields are involved.

How to repeat:
Check the ndb_size.pl source, search for "blob", see the calculation:

The current size calculation for TEXT and BLOB fields looks like this:

 @realsize=(256, 256, 1);

which obviously can't be true.

Suggested fix:
Take the extend sizes for the blob helper tables into account in the calculation.
[26 Jul 2006 1:45] Bugs System
A patch for this bug has been committed. After review, it may
be pushed to the relevant source trees for release in the next
version. You can access the patch from:

[19 Sep 2006 8:11] Stewart Smith
pushed to 4.1-ndb

merge jam preventing further pushes. will merge without problems though.
[1 Nov 2006 14:26] Jonas Oreland
pushed into 4.1.22
[28 Dec 2006 13:11] Jon Stephens
Documented fix for 4.1 in 4.1.22 changelog. Need 3-part version numbers for 5.0 and 5.1 trees.
[7 Jun 2007 7:24] Stewart Smith
5.0.24 and 5.1.12 i think.
[8 Jun 2007 21:58] Jon Stephens
Thank you for your bug report. This issue has already been fixed in the latest released version of that product, which you can download at


Documented in 5.0.24 and 5.1.12 changelogs.