The SET_CONSUMER_GROUP_MAPPING procedure adds, deletes, or modifies entries that map sessions to resource groups based on session login and runtime attributes.
Applicability
This topic applies only to OceanBase Database Enterprise Edition. OceanBase Database Community Edition provides only MySQL-compatible mode.
Syntax
DBMS_RESOURCE_MANAGER.SET_CONSUMER_GROUP_MAPPING(
attribute IN VARCHAR2,
value IN VARCHAR2,
consumer_group IN VARCHAR2 DEFAULT NULL);
Parameters
| Parameter | Description |
|---|---|
| attribute | The attribute to add or modify. In the current version, only the USER (the username of the database), COLUMN, and FUNCTION attributes are supported. OceanBase Database performs various background tasks such as major compactions, backups, and data completion. These tasks are not user-specific and may consume CPU and I/O resources of other users and tasks. Therefore, you can specify FUNCTION mappings for different background tasks. The resources of background tasks can be limited to their corresponding resource groups. |
| value | The value of the attribute to match. This can be an absolute mapping or a regular expression. |
| consumer_group | The name of the consumer group to map to. If this parameter is NULL, the mapping will be deleted. |
Considerations
If no mapping exists for the specified attribute and value, a mapping to the specified consumer group will be created. If a mapping already exists for the specified attribute and value, the consumer group of the mapping will be updated to the specified consumer group. If the consumer_group parameter is NULL, any mapping for the specified attribute and value will be deleted.
The following table lists the predefined FUNCTION resource group mapping rules in OceanBase Database. You can use the DBMS_RESOURCE_MANAGER.SET_CONSUMER_GROUP_MAPPING procedure to modify or delete these mapping rules.
| Attribute | Value | Description |
|---|---|---|
| FUNCTION | COMPACTION_HIGH | Corresponds to MINI_MERGE and DDL KV merge tasks. |
| FUNCTION | COMPACTION_MID | Corresponds to MINOR_MERGE tasks. |
| FUNCTION | COMPACTION_LOW | Corresponds to MAJOR_MERGE tasks. |
| FUNCTION | HA_HIGH | Corresponds to replication, rebuild, and restore tasks. |
| FUNCTION | HA_MID | Corresponds to migration tasks. |
| FUNCTION | HA_LOW | Corresponds to backup and cleanup tasks. |
| FUNCTION | DDL | Corresponds to unique index verification and column deletion with data filling. |
| FUNCTION | DDL_HIGH | Corresponds to DDL MemTable dump operations. |
| FUNCTION | CLOG_HIGH | Corresponds to clog log commit tasks. |
| FUNCTION | OPT_STATS | Corresponds to statistics collection tasks. |
| FUNCTION | MVIEW | Corresponds to incremental refresh of materialized views and MLOG purge tasks. |
Examples
obclient> CALL DBMS_RESOURCE_MANAGER.SET_CONSUMER_GROUP_MAPPING(
attribute => 'COLUMN' ,
value => 't2.c3 = 3 for user1',
consumer_group => 'group1');
Query OK, 0 rows affected