SHOW WORKLOAD GROUPS
Description
This statement is used to display the resource groups for which the current user has usage_priv privileges.
Syntax
SHOW WORKLOAD GROUPS [LIKE "<pattern>"];
Usage Notes
This statement only does a simple display of workload groups, for a more complex display refer to tvf workload_groups().
Examples
-
Show all workload groups:
mysql> show workload groups \G; *************************** 1. row *************************** Id: 1754728930516 Name: normal min_cpu_percent: 20% max_cpu_percent: 30% min_memory_percent: 0% max_memory_percent: 50% max_concurrency: 1 max_queue_size: 1 queue_timeout: 0 scan_thread_num: 16 max_remote_scan_thread_num: -1 min_remote_scan_thread_num: -1 memory_low_watermark: 75% memory_high_watermark: 85% compute_group: default read_bytes_per_second: -1 remote_read_bytes_per_second: -1 slot_memory_policy: none running_query_num: 0 waiting_query_num: 0 *************************** 2. row *************************** Id: 1754740507946 Name: test_group2 min_cpu_percent: 10% max_cpu_percent: 30% min_memory_percent: 0% max_memory_percent: 3% max_concurrency: 2147483647 max_queue_size: 0 queue_timeout: 0 scan_thread_num: -1 max_remote_scan_thread_num: -1 min_remote_scan_thread_num: -1 memory_low_watermark: 75% memory_high_watermark: 85% compute_group: default read_bytes_per_second: -1 remote_read_bytes_per_second: -1 slot_memory_policy: none running_query_num: 0 waiting_query_num: 0 ```
-
Show workload groups using pattern
mysql> show workload groups like "normal%" \G; *************************** 1. row *************************** Id: 1754728930516 Name: normal min_cpu_percent: 20% max_cpu_percent: 30% min_memory_percent: 0% max_memory_percent: 50% max_concurrency: 1 max_queue_size: 1 queue_timeout: 0 scan_thread_num: 16 max_remote_scan_thread_num: -1 min_remote_scan_thread_num: -1 memory_low_watermark: 75% memory_high_watermark: 85% compute_group: default read_bytes_per_second: -1 remote_read_bytes_per_second: -1 slot_memory_policy: none running_query_num: 0 waiting_query_num: 0 ```
