Bug #53446 ndb$info.config_params is missing entry for 132
Submitted: 5 May 2010 18:07 Modified: 5 May 2010 18:43
Reporter: Matthew Montgomery Email Updates:
Status: Not a Bug Impact on me:
None 
Category:MySQL Cluster: Cluster (NDB) storage engine Severity:S3 (Non-critical)
Version:5.1.44-ndb-7.1.3-cluster-gpl OS:Any
Assigned to: Jonas Oreland CPU Architecture:Any

[5 May 2010 18:07] Matthew Montgomery
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.
[5 May 2010 18:17] MySQL Verification Team
or, if ParallelBackups is "not implemented" how does it contribute to the Table pool?

    CFG_DB_PARALLEL_BACKUPS,
    "ParallelBackups",
    DB_TOKEN,
    "Maximum number of parallel backups",
    ConfigInfo::CI_NOTIMPLEMENTED,