Bug #80447 Documentation description of ndbinfo.resources table is incomplete

Submitted: 19 Feb 2016 16:26 Modified: 9 Mar 2016 8:18
Reporter: Matthew Montgomery Email Updates:
Status: Closed Impact on me:
None 
Category:MySQL Cluster: Documentation Severity:S3 (Non-critical)
Version: OS:Any
Assigned to: Jon Stephens CPU Architecture:Any

[19 Feb 2016 16:26] Matthew Montgomery
Description:
https://dev.mysql.com/doc/refman/5.6/en/mysql-cluster-ndbinfo-resources.html

 The resource_name can be one of RESERVED, DISK_OPERATIONS, DISK_RECORDS, DATA_MEMORY, JOBBUFFER, FILE_BUFFERS, or TRANSPORTER_BUFFERS. 

It does not mention DISK_PAGE_BUFFER, QUERY_MEMORY or SCHEMA_TRANS_MEMORY

How to repeat:
[memontgo@memontgo-pc dbspj]$ mysql ndbinfo;
Reading table information for completion of table and column names
You can turn off this feature to get a quicker startup with -A

Welcome to the MySQL monitor.  Commands end with ; or \g.
Your MySQL connection id is 6
Server version: 5.6.25-ndb-7.4.7-log Source distribution

Copyright (c) 2000, 2013, Oracle and/or its affiliates. All rights reserved.

Oracle is a registered trademark of Oracle Corporation and/or its
affiliates. Other names may be trademarks of their respective
owners.

Type 'help;' or '\h' for help. Type '\c' to clear the current input statement.

mysql> select * from resources; 
+---------+---------------------+----------+------+-------+
| node_id | resource_name       | reserved | used | max   |
+---------+---------------------+----------+------+-------+
|       1 | RESERVED            |     5122 | 4638 | 13591 |
|       1 | DISK_OPERATIONS     |        0 |  258 |     0 |
|       1 | DISK_RECORDS        |        0 |    6 |     0 |
|       1 | DATA_MEMORY         |     3144 |  721 |  3144 |
|       1 | JOBBUFFER           |      724 |  130 |   724 |
|       1 | FILE_BUFFERS        |     1152 | 1120 |  1152 |
|       1 | TRANSPORTER_BUFFERS |     2172 |  162 |  2715 |
|       1 | DISK_PAGE_BUFFER    |     2240 | 2240 |  2240 |
|       1 | QUERY_MEMORY        |        0 |    0 |     0 |
|       1 | SCHEMA_TRANS_MEMORY |       64 |    1 |     0 |
|       2 | RESERVED            |     5146 | 4614 | 13591 |
|       2 | DISK_OPERATIONS     |        0 |  258 |     0 |
|       2 | DISK_RECORDS        |        0 |    6 |     0 |
|       2 | DATA_MEMORY         |     3144 |  721 |  3144 |
|       2 | JOBBUFFER           |      724 |  130 |   724 |
|       2 | FILE_BUFFERS        |     1152 | 1120 |  1152 |
|       2 | TRANSPORTER_BUFFERS |     2172 |  138 |  2715 |
|       2 | DISK_PAGE_BUFFER    |     2240 | 2240 |  2240 |
|       2 | QUERY_MEMORY        |        0 |    0 |     0 |
|       2 | SCHEMA_TRANS_MEMORY |       64 |    1 |     0 |
+---------+---------------------+----------+------+-------+
20 rows in set (0.01 sec)

Suggested fix:
Include references to the other pools that were omitted.

Also having a description of what each of these "super pools" is responsible for would be nice.
[9 Mar 2016 8:18] 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.

Portions of this website are copyright © 2001, 2002 The PHP Group

Page generated in 0.049 sec. using MySQL 8.4.7-u6-cloud

Timestamp references displayed by the system are UTC.
Content reproduced on this site is the property of the respective copyright holders.
It is not reviewed in advance by Oracle and does not necessarily represent the opinion of Oracle or any other party.