当前集群限制 Unit 规格内存不小于 5GiB,可通过连接集群调整 _min_full_resource_pool_memory(单位:byte)修改最小值限制

obclient(root@sys)[oceanbase]> SELECT * FROM oceanbase.GV$OB_PARAMETERS WHERE name='__min_full_resource_pool_memory';

+----------------+----------+-------+---------+-----------+---------------------------------+-----------+------------+-------------------------------------------------------------------+--------------+-------------------+---------------+-----------+

| SVR_IP         | SVR_PORT | ZONE  | SCOPE   | TENANT_ID | NAME                            | DATA_TYPE | VALUE      | INFO                                                              | SECTION      | EDIT_LEVEL        | DEFAULT_VALUE | ISDEFAULT |

+----------------+----------+-------+---------+-----------+---------------------------------+-----------+------------+-------------------------------------------------------------------+--------------+-------------------+---------------+-----------+

| 192.168.61.112 |     2882 | zone2 | CLUSTER |      NULL | __min_full_resource_pool_memory | NULL      | 5368709120 | the min memory value which is specified for a full resource pool. | LOAD_BALANCE | DYNAMIC_EFFECTIVE | 5368709120    | YES       |

| 192.168.61.113 |     2882 | zone3 | CLUSTER |      NULL | __min_full_resource_pool_memory | NULL      | 5368709120 | the min memory value which is specified for a full resource pool. | LOAD_BALANCE | DYNAMIC_EFFECTIVE | 5368709120    | YES       |

| 192.168.61.111 |     2882 | zone1 | CLUSTER |      NULL | __min_full_resource_pool_memory | NULL      | 5368709120 | the min memory value which is specified for a full resource pool. | LOAD_BALANCE | DYNAMIC_EFFECTIVE | 5368709120    | YES       |

+----------------+----------+-------+---------+-----------+---------------------------------+-----------+------------+-------------------------------------------------------------------+--------------+-------------------+---------------+-----------+

3 rows in set (0.038 sec)




obclient(root@sys)[oceanbase]> ALTER SYSTEM SET __min_full_resource_pool_memory = 1073741824;

Query OK, 0 rows affected (0.028 sec)




obclient(root@sys)[oceanbase]>













mysql -h192.168.61.111 -P2883 -uroot@a5_fund#obcluster -p

 

上一篇 Oracle 19c RAC 部署与运维完全手册
下一篇 AnyBackup - TDSQL恢复失败,提示信息:"错误信息:[[41007]recover: can't pick available image. storage:S3,parse json error when getAvailableImageByS3]"
易读格

易读格管理员

这个人很懒,什么都没有留下。

本月创作热力图

目录
最新评论
暂无评论