📣

TiDB Cloud Premium is now in public preview. Unlimited growth, instant elasticity, advanced security for enterprise workloads. Try it out →

Get Started

Guides

Tutorials

Reference

ALTER WORKLOAD GROUP

Update a workload group with specified quota settings.

Syntax

ALTER WORKLOAD GROUP <group_name>
[SET cpu_quota = '<percentage>', query_timeout = '<duration>']

Parameter	Type	Required	Default	Description
`cpu_quota`	string	No	(unlimited)	CPU resource quota as percentage string (e.g. `"20%"`)
`query_timeout`	duration	No	(unlimited)	Query timeout duration (units: `s`/`sec`=seconds, `m`/`min`=minutes, `h`/`hour`=hours, `d`/`day`=days, `ms`=milliseconds, unitless=seconds)
`memory_quota`	string or integer	No	(unlimited)	Maximum memory usage limit for workload group (percentage or absolute value)
`max_concurrency`	integer	No	(unlimited)	Maximum concurrency number for workload group
`query_queued_timeout`	duration	No	(unlimited)	Maximum queuing wait time when workload group exceeds max concurrency (units: `s`/`sec`=seconds, `m`/`min`=minutes, `h`/`hour`=hours, `d`/`day`=days, `ms`=milliseconds, unitless=seconds)

ALTER WORKLOAD GROUP analytics SET cpu_quota = '20%', query_timeout = '10m';