Kinetica provides a SQL interface for managing resource groups, which can be used to limit memory and thread usage, and execution priority for a user or group of users.
The ability to manage resource groups is available through SQL, using the following commands:
See Security for details on assigning resource groups to users and roles.
CREATE RESOURCE GROUP
Resource groups require only a name to be created, all limits are optional. Resource group names are case-sensitive and must contain only letters, digits, and underscores, and cannot begin with a digit. A resource group must also not be named the same as an existing resource group, including the default resource groups: kinetica_system_resource_group & kinetica_default_resource_group.
For example, to create a simple unlimited resource group with default settings:
To create a memory_over_execution resource group, with high tier capacity limits, but low execution options:
To create a execution_over_memory resource group, with lower tier capacity limits, but higher execution options, as compared to the memory_over_execution group:
ALTER RESOURCE GROUP
Any of the following facets of a resource group can be altered, either individually or as a group:
- Tier limits
- Execution options
For example, to alter an existing memory_and_execution resource group, moving it to the highest ranking, while assigning new limits for the RAM tier and max_cpu_concurrency & max_scheduling_priority options, but leaving other existing settings untouched:
DROP RESOURCE GROUP
An existing user-defined resource group can be removed from the system, which will also dissociate the group from any users or roles to which it was assigned.
For example, to remove the unlimited resource group:
SHOW RESOURCE GROUP
The configuration of any resource group can be shown, in tabular form. The configuration for all resource groups in the system can also be shown with a single command.
For example, to show the configuration of the memory_and_execution resource group:
To show the configuration of all resource groups: