变更资源配置失败

参考例:
ALTER RESOURCE UNIT 5g8c MEMORY_SIZE =‘5G’, MAX_CPU =8,MAX_IOPS = 10000,MIN_CPU = 8 ,MIN_IOPS = 10000, IOPS_WEIGHT =500,LOG_DISK_SIZE =‘100G’;

obclient [oceanbase]> ALTER RESOURCE UNIT 5g8c MEMORY_SIZE =‘5G’, MAX_CPU =8,MAX_IOPS = 10000,MIN_CPU = 8 ,MIN_IOPS = 10000, IOPS_WEIGHT =500,LOG_DISK_SIZE =‘100G’;
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 ‘‘5G’, MAX_CPU =8,MAX_IOPS = 10000,MIN_CPU = 8 ,MIN_IOPS = 10000, IOPS_WEIGHT’ at line 1


4.3.3是不是对硬件有特殊要求,不是2C8G?
如何查看当前资源配置?
当时创建的资源配置:
CREATE RESOURCE UNIT uc1 MAX_CPU 5, MIN_CPU 4, MEMORY_SIZE ‘36G’, MAX_IOPS 128000, MIN_IOPS 128000, LOG_DISK_SIZE ‘2T’ ;这样配置有什么问题?


这里是中文的单引号么?

1 个赞

是英文的引号

image
我看你引号使用的像中文的单引号,为什么左边的引号会跟第一个数字重叠,你手动修改下试试

1 个赞

感谢老师指导

感谢老师指导!