Bug #80447 Documentation description of ndbinfo.resources table is incomplete
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.
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.