MySQL Bugs: #21204: ndb_size.pl doesn't take extended BLOB/TEXT size into account

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:	None
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

Description:
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.

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:

  http://lists.mysql.com/commits/9568

pushed to 4.1-ndb

merge jam preventing further pushes. will merge without problems though.

pushed into 4.1.22

Documented fix for 4.1 in 4.1.22 changelog. Need 3-part version numbers for 5.0 and 5.1 trees.

5.0.24 and 5.1.12 i think.

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

  http://www.mysql.com/downloads/

Documented in 5.0.24 and 5.1.12 changelogs.