Skip to main content
Version: Latest-3.3

SHOW USAGE RESOURCE GROUPS

Description

Shows the usage information of resource groups. This feature is supported from v3.1.4 onwards.

tip

This operation does not require privileges.

Syntax

SHOW USAGE RESOURCE GROUPS

Return

  • Name: The name of the resource group.
  • Id: The ID of the resource group.
  • Backend: The BE's IP or FQDN.
  • BEInUseCpuCores: The number of CPU cores currently in use by this resource group on this BE. This value is an approximate estimate.
  • BEInUseMemBytes: The number of memory bytes currently in use by this resource group on this BE.
  • BERunningQueries: The number of queries from this resource group that are still running on this BE.

Usage notes

  • BEs periodically report this resource usage information to the Leader FE at the interval specified in report_resource_usage_interval_ms, which is by default set to 1 second.
  • The results will only show rows where at least one of BEInUseCpuCores/BEInUseMemBytes/BERunningQueries is a positive number. In other words, the information is displayed only when a resource group is actively using some resources on a BE.

Example

MySQL [(none)]> SHOW USAGE RESOURCE GROUPS;
+------------+----+-----------+-----------------+-----------------+------------------+
| Name | Id | Backend | BEInUseCpuCores | BEInUseMemBytes | BERunningQueries |
+------------+----+-----------+-----------------+-----------------+------------------+
| default_wg | 0 | 127.0.0.1 | 0.100 | 1 | 5 |
+------------+----+-----------+-----------------+-----------------+------------------+
| default_wg | 0 | 127.0.0.2 | 0.200 | 2 | 6 |
+------------+----+-----------+-----------------+-----------------+------------------+
| wg1 | 0 | 127.0.0.1 | 0.300 | 3 | 7 |
+------------+----+-----------+-----------------+-----------------+------------------+
| wg2 | 0 | 127.0.0.1 | 0.400 | 4 | 8 |
+------------+----+-----------+-----------------+-----------------+------------------+