Bug #53939 ndbinfo.memoryusage: doc does not reflect new format
Submitted: 24 May 2010 10:16 Modified: 27 May 2010 13:28
Reporter: Andrew Morgan Email Updates:
Status: Closed Impact on me:
None 
Category:MySQL Server: Documentation Severity:S3 (Non-critical)
Version:mysql-5.1-telco-7.1 OS:Any
Assigned to: Jon Stephens CPU Architecture:Any
Tags: MySQL Cluster 7.1.3

[24 May 2010 10:16] Andrew Morgan
Description:
The format of ndbinfo.memoryusage changed shortly before GA. The documentation at http://dev.mysql.com/doc/mysql-cluster-excerpt/5.1/en/mysql-cluster-ndbinfo-memoryusage.ht... still describes the original format. The real view now looks like:

mysql> select * from memoryusage;
+---------+--------------+--------+------------+-----------+-------------+
| node_id | memory_type  | used   | used_pages | total     | total_pages |
+---------+--------------+--------+------------+-----------+-------------+
|       3 | Data memory  | 917504 |         28 | 104857600 |        3200 |
|       3 | Index memory | 221184 |         27 |  11010048 |        1344 |
|       4 | Data memory  | 917504 |         28 | 104857600 |        3200 |
|       4 | Index memory | 221184 |         27 |  11010048 |        1344 |
+---------+--------------+--------+------------+-----------+-------------+

How to repeat:
mysql> select * from ndbinfo.memoryusage;

Suggested fix:
Make documentation reflect the new implementation.
[26 May 2010 11:21] Jon Stephens
Was this an intentional change? If not, it's a Server bug and needs to be fixed.
[26 May 2010 12:59] Andrew Morgan
I believe that the implementation change was intentional. It was expected that the units would be changed to bytes, I hadn't realised that it would also have new columns for the information as pages but I think that it's useful (partly because the smaller numbers are easier to compare).
[26 May 2010 14:42] Jon Stephens
Corrected category/lead.
[27 May 2010 13:28] Jon Stephens
Thank you for your bug report. This issue has been addressed in the documentation. The updated documentation will appear on our website shortly, and will be included in the next release of the relevant products.