Description:
While trying to locate all parameters contributing to Table pools. I found that one of the variables is not documented
./include/mgmapi/mgmapi_config_parameters.h:#define CFG_DB_PARALLEL_BACKUPS 132
How to repeat:
mysql> set global ndbinfo_show_hidden=1;
Query OK, 0 rows affected (0.00 sec)
mysql> select node_id, pool_name, used, total, high, config_param1, config_param2, config_param3, config_param4 from ndb$pools where pool_name='Table';
+---------+-----------+------+-------+------+---------------+---------------+---------------+---------------+
| node_id | pool_name | used | total | high | config_param1 | config_param2 | config_param3 | config_param4 |
+---------+-----------+------+-------+------+---------------+---------------+---------------+---------------+
| 2 | Table | 0 | 323 | 323 | 132 | 102 | 149 | 150 |
| 2 | Table | 3 | 130 | 3 | 102 | 0 | 0 | 0 |
| 3 | Table | 0 | 323 | 323 | 132 | 102 | 149 | 150 |
| 3 | Table | 3 | 130 | 3 | 102 | 0 | 0 | 0 |
+---------+-----------+------+-------+------+---------------+---------------+---------------+---------------+
4 rows in set (0.26 sec)
mysql> select node_id,
-> pool_name,
-> used,
-> total, high,
-> c1.param_name,
-> c2.param_name,
-> c3.param_name,
-> c4.param_name
-> from ndb$pools LEFT join config_params c1 on (config_param1=c1.param_number)
-> LEFT join config_params c2 on (config_param2=c2.param_number)
-> LEFT join config_params c3 on (config_param3=c3.param_number)
-> LEFT join config_params c4 on (config_param4=c4.param_number)
-> where pool_name='Table';
+---------+-----------+------+-------+------+---------------+---------------+-----------------------+--------------------------+
| node_id | pool_name | used | total | high | param_name | param_name | param_name | param_name |
+---------+-----------+------+-------+------+---------------+---------------+-----------------------+--------------------------+
| 2 | Table | 0 | 323 | 323 | NULL | MaxNoOfTables | MaxNoOfOrderedIndexes | MaxNoOfUniqueHashIndexes |
| 2 | Table | 3 | 130 | 3 | MaxNoOfTables | NULL | NULL | NULL |
| 3 | Table | 0 | 323 | 323 | NULL | MaxNoOfTables | MaxNoOfOrderedIndexes | MaxNoOfUniqueHashIndexes |
| 3 | Table | 3 | 130 | 3 | MaxNoOfTables | NULL | NULL | NULL |
+---------+-----------+------+-------+------+---------------+---------------+-----------------------+--------------------------+
4 rows in set (0.26 sec)
mysql> select * from config_params where param_number = 132 ;
Empty set (0.00 sec)
Suggested fix:
ParallelBackups should be added to the config_params table and documentation.
mysql> insert into ndbinfo.config_params values (132, 'ParallelBackups');
Also having multiple pools named "Table" is confusing. These must be different in some respect and should be named accordingly.