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.
