【 使用环境 】生产环境 or 测试环境
【 OB or 其他组件 】
【 使用版本 】社区版 OCP 4.0.3 ob_ce_4.1.0_bp1
【问题现象及影响】
新建租户-OceanBase 数据库 -OceanBase文档中心-分布式数据库使用文档
文档中提到:
在分配资源池时,普通租户的内存的最小规格由隐藏配置项
__min_full_resource_pool_memory控制,默认值为 5G,取值范围为 [1073741824,+∞)。如果您希望创建一个租户进行非常简单的功能测试,可以修改参数
alter system __min_full_resource_pool_memory 的值为 1073741824 来允许以最小 1 GB 内存的规格创建租户。
目前已经设置__min_full_resource_pool_memory 的值为 1073741824 ,但建租户时还是提示最小内存要5G
obclient [oceanbase]> SELECT * FROM oceanbase.__all_virtual_sys_parameter_stat WHERE name='__min_full_resource_pool_memory';
+-------+----------+----------------+----------+---------------------------------+-----------+------------+--------------+-------------------------------------------------------------------+-------------+--------------+---------------+---------+---------+-------------------+
| zone | svr_type | svr_ip | svr_port | name | data_type | value | value_strict | info | need_reboot | section | visible_level | scope | source | edit_level |
+-------+----------+----------------+----------+---------------------------------+-----------+------------+--------------+-------------------------------------------------------------------+-------------+--------------+---------------+---------+---------+-------------------+
| zone3 | observer | 192.168.51.235 | 2882 | __min_full_resource_pool_memory | NULL | 1073741824 | NULL | the min memory value which is specified for a full resource pool. | NULL | LOAD_BALANCE | NULL | CLUSTER | DEFAULT | DYNAMIC_EFFECTIVE |
| zone1 | observer | 192.168.51.233 | 2882 | __min_full_resource_pool_memory | NULL | 1073741824 | NULL | the min memory value which is specified for a full resource pool. | NULL | LOAD_BALANCE | NULL | CLUSTER | DEFAULT | DYNAMIC_EFFECTIVE |
| zone2 | observer | 192.168.51.234 | 2882 | __min_full_resource_pool_memory | NULL | 1073741824 | NULL | the min memory value which is specified for a full resource pool. | NULL | LOAD_BALANCE | NULL | CLUSTER | DEFAULT | DYNAMIC_EFFECTIVE |
+-------+----------+----------------+----------+---------------------------------+-----------+------------+--------------+-------------------------------------------------------------------+-------------+--------------+---------------+---------+---------+-------------------+
3 rows in set (0.018 sec)