开启数据文件的动态扩容

OceanBase 技术问题
#1

【 使用环境 】生产环境 or 测试环境
【 OB or 其他组件 】
【 使用版本 】
【问题描述】开启数据文件的动态扩容，及服务器资源查看

1 个赞
#3

开启数据文件的动态扩容：

查看磁盘空间大小：

lsblk

查看 OBServer 当前的磁盘分配情况：

SELECT SVR_IP, CONCAT(ROUND((DATA_DISK_CAPACITY)/1024/1024/1024,1),’ GB’) AS

DATA_DISK_CAPACITY, CONCAT(ROUND((DATA_DISK_ALLOCATED)/1024/1024/1024,1),’ GB’) AS

DATA_DISK_ALLOCATED, CONCAT(ROUND((DATA_DISK_IN_USE)/1024/1024/1024,1),’ GB’) AS

DATA_DISK_IN_USE FROM GV$OB_SERVERS;

1、 将 datafile_maxsize 设置为一个比 DATA_DISK_ALLOCATED 大的值（小于磁盘/data/1 的大小），同时设置 datafile_next 为 datafile_maxsize 的 20%。

ALTER SYSTEM SET datafile_maxsize=‘50G’;

ALTER SYSTEM SET datafile_next=‘10G’;

2、 查看修改后的 OBServer 磁盘空间上限：

SELECT SVR_IP, CONCAT(ROUND((DATA_DISK_CAPACITY)/1024/1024/1024,1),’ GB’) AS

DATA_DISK_CAPACITY, CONCAT(ROUND((DATA_DISK_ALLOCATED)/1024/1024/1024,1),’ GB’) AS

DATA_DISK_ALLOCATED, CONCAT(ROUND((DATA_DISK_IN_USE)/1024/1024/1024,1),’ GB’) AS

DATA_DISK_IN_USE FROM GV$OB_SERVERS;

查询资源现状

1、查询资源配置

select * from DBA_OB_UNIT_CONFIGS;

2、使用系统视图 GV$OB_SERVERS，查看 observer 可供分配的 CPU、内余额是多少。

SELECT SVR_IP, CPU_CAPACITY_MAX, CPU_ASSIGNED_MAX,

CPU_CAPACITY_MAX-CPU_ASSIGNED_MAX AS CPU_UNASSIGNED_MAX,

CPU_CAPACITY, CPU_ASSIGNED,

CPU_CAPACITY-CPU_ASSIGNED AS CPU_UNASSIGNED

FROM GV$OB_SERVERS ORDER BY SVR_IP;

SELECT SVR_IP,

CONCAT(ROUND(MEMORY_LIMIT/1024/1024/1024,1),‘GB’) AS MEM_LIMIT,

CONCAT(ROUND(MEM_CAPACITY/1024/1024/1024,1),‘GB’) AS MEM_CAPACITY,

CONCAT(ROUND(MEM_ASSIGNED/1024/1024/1024,1),‘GB’) AS MEM_ASSIGNED,

CONCAT(ROUND((MEM_CAPACITY-MEM_ASSIGNED)/1024/1024/1024,1),‘GB’) AS MEM_UNASSIGNED

FROM GV$OB_SERVERS ORDER BY SVR_IP;

3、查看集群内各个 observer 上租户的资源分配情况。
SELECT T1.SVR_IP, T3.TENANT_NAME, T1.MIN_CPU, T1.MAX_CPU,
CONCAT(ROUND(T1. MEMORY_SIZE/1024/1024/1024,1),‘GB’) AS MEMORY_SIZE
FROM DBA_OB_UNITS T1, DBA_OB_RESOURCE_POOLS T2, DBA_OB_TENANTS T3
WHERE T1.RESOURCE_POOL_ID = T2.RESOURCE_POOL_ID
AND T2.TENANT_ID = T3.TENANT_ID
ORDER BY SVR_IP,TENANT_NAME;

1 个赞
#4

详细