如何修改某个租户的memstore_limit_percentage值呢？

[bull020]

如何修改某个租户的memstore_limit_percentage值呢？

[独善其身]

@bull020

如何修改某个租户的memstore_limit_percentage值

从配置文件和命令行都可以进行修改啊

[bull020]

      name: memstore_limit_percentage
 data_type: NULL
     value: 60
      info: used in calculating the value of MEMSTORE_LIMIT parameter: memstore_limit_percentage = memstore_limit / memory_size,memory_size, where MEMORY_SIZE is determined when the tenant is created. Range: (0, 100)
   section: TENANT
     scope: CLUSTER
    source: DEFAULT
edit_level: DYNAMIC_EFFECTIVE
3 rows in set (0.01 sec)

mysql> alter system set memstore_limit_percentage=60 tenant='mysql';
ERROR 5099 (42000): System config unknown
mysql> 
mysql> show tenant;
+---------------------+
| Current_tenant_name |
+---------------------+
| sys                 |
+---------------------+
1 row in set (0.00 sec)

mysql> 

[淇铭]

@论坛小助手

[论坛小助手]

要修改某个租户的 memstore_limit_percentage 值，您需要首先确保当前会话连接到了正确的租户。如果连接到了 sys 租户，则无法直接修改其他租户的参数。您可以使用 ALTER TENANT 语句来修改租户的 memstore_limit_percentage 参数。以下是具体步骤：

1. 切换到目标租户，使用如下命令：

ALTER SESSION SET ob_tracer_tenant='your_tenant_name';

2. 修改租户的 memstore_limit_percentage 参数：

ALTER TENANT your_tenant_name SET memstore_limit_percentage = 60;

注意：如果您的版本支持租户级隐藏配置项 _memstore_limit_percentage，也可以使用该配置项来修改租户的 memstore_limit_percentage 值。

更多信息请查看:

1. memstore_limit_percentage
2. 在您开始前
3. freeze_trigger_percentage

[bull020]

mysql> show tenant;
+---------------------+
| Current_tenant_name |
+---------------------+
| sys                 |
+---------------------+
1 row in set (0.00 sec)

mysql> select version();
+------------------------------+
| version()                    |
+------------------------------+
| 5.7.25-OceanBase_CE-v4.2.1.8 |
+------------------------------+
1 row in set (0.01 sec)

mysql> ALTER SESSION SET ob_tracer_tenant='mysql';
ERROR 1064 (42000): You have an error in your SQL syntax; check the manual that corresponds to your OceanBase version for the right syntax to use near 'SESSION SET ob_tracer_tenant='mysql'' at line 1
mysql>  alter tenant mysql set memstore_limit_percentage=60 ;
ERROR 1064 (42000): You have an error in your SQL syntax; check the manual that corresponds to your OceanBase version for the right syntax to use near 'memstore_limit_percentage=60' at line 1
mysql> 
mysql> 

mysql> alter system set memstore_limit_percentage=60 ;
Query OK, 0 rows affected (0.02 sec)

这样修改可以成功，但是是修改了所有的租户的

[淇铭]