Note
For V4.4.2, this parameter is available starting from V4.4.2 BP2.
Overview
mv_refresh_concurrency specifies the maximum number of materialized view refresh tasks that can run concurrently within a tenant.
Privilege requirements
Query parameters \
Both the
systenant and all user tenants can query this parameter using theSHOW PARAMETERSstatement or theGV$OB_PARAMETERSview.Modify parameters.
Both the
systenant and user tenants can modify this parameter.
Attributes
Attribute |
Description |
|---|---|
| Parameter type | INT |
| Default Value | 10 |
| Value range | [1, +∞) |
| Modifiable | Yes, you can use the following methods:ALTER SYSTEM SETStatement modification. |
| Effective Mode | Dynamic. |
Usage instructions
Adjust this value based on the actual system load. For TP-intensive scenarios, it is recommended to lower this value, while for AP-heavy scenarios, it can be appropriately increased.
Configuration example
The maximum number of concurrent refresh tasks has been adjusted to 5.
obclient> ALTER SYSTEM SET mv_refresh_concurrency = 5;