Overview
attach_shared_sstable_thread_score specifies the number of threads a tenant can use to compute shared data references on nodes.
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 use theALTER SYSTEM SETstatement to modify this parameter.
Attributes
Attribute |
Description |
|---|---|
| Parameter type | Int |
| Default Value | 0 indicates the default number of threads is 6. |
| Value range | [0, 100] |
| Modifiable | Yes, you can use the following methods:ALTER SYSTEM SETStatement modification. |
| Whether to restart the OBServer node for the change to take effect | No, the setting takes effect immediately. |
Usage instructions
The inc_sstable_upload_thread_score parameter can also be used to specify the number of threads that concurrently perform tasks of uploading shared SSTables to local storage.
Configuration example
In the user tenant, set the number of threads for processing incremental data references from shared storage to local tasks to 10.
obclient> ALTER SYSTEM SET attach_shared_sstable_thread_score = 10;
References
To configure the number of threads for processing data sharing tasks, see inc_sstable_upload_thread_score.