Skip to main content

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                |
+------------+----+-----------+-----------------+-----------------+------------------+