GBase8a 资源管理使用情况系统表查询

1. 资源管理信息查询

查询Consumer group定义

SELECT * FROM gbase.consumer_group;

查询consumer group与user关联定义

SELECT * FROM gbase.consumer_group_user;

查询resource pool定义

SELECT * FROM gbase.resource_pool;

查询resource plan定义

SELECT * FROM gbase.resource_plan;

查询resource directive定义

SELECT * FROM gbase.resource_plan_directive;

查询记录集群层资源池 event 信息

SELECT * FROM gbase.resource_pool_events;

2.运行期信息查询 查询active plan 设置

SELECT * FROM gbase.resource_config;

查看动态资源池中任务

SELECT * FROM information_schema.processlist WHERE resource_pool_name =’pool_name’ AND vc=’vc_name’;

查看Resource Pool的资源使用情况 语法

SHOW RESOURCE POOL USAGE ON {coordinators | nodes} WHERE resource_pool_name = 'pool_name' AND vc_name=’xxxx’;

3. 统计信息查询 查看动态资源池任务运行的资源使用历史信息

SHOW RESOURCE POOL STATUS ON {coordinators | nodes} WHERE resource_pool_name = 'pool_name' AND vc_name=’xxxx’;

查看动态资源池资源管控事件

SHOW RESOURCE POOL EVENTS WHERE resource_pool_name = 'pool_name' AND vc_name=’xxxx’;