修改unit 语句错误

OceanBase 技术问题
#1

输入的语句：ALTER RESOURCE UNIT test_unit MAX_CPU 3, MAX_MEMORY ‘2G’, MAX_IOPS 128,max_disk_size ‘2G’, MAX_SESSION_NUM 64, MIN_CPU=3, MIN_MEMORY=‘2G’, MIN_IOPS=13;
提示如下错误:
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 ‘MAX_MEMORY ‘2G’, MAX_IOPS 128,max_disk_size ‘2G’, MAX_SESSION_NUM 64, MIN_CPU=3,’ at line 1
[172.17.0.4:2882] [2025-01-09 02:40:43.211061] [YB42AC110004-00062B2DC8243FDD-0-0]

#3

新版本是MEMORY_SIZE，max那个好像是v3的语法

1 个赞
#4

4X 设置内存只有一个参数了MEMORY_SIZE 没有 MAX_MEMORY 和MIN_MEMORY 了

1 个赞
#5

你好，有介绍4x 语法差异资料么

#6

所有的命令官网都有，搜索的命令的时候看下数据库的版本，没有语法差异的资料

#7

你用哪个版本就看对应版本的文档 :grinning: