Note
For V4.4.0, this parameter is available starting with V4.4.0.
Description
attach_shared_sstable_thread_score specifies the number of threads that can be used by a tenant to execute shared data reference tasks on a compute node in shared storage mode.
Applicability
This parameter is applicable only to shared storage (SS) mode.
Privilege requirements
Query the parameter
The
systenant and all user tenants can use theSHOW PARAMETERSstatement or theGV$OB_PARAMETERSview to query this parameter.Modify the parameter
The
systenant and user tenants can use theALTER SYSTEM SETstatement to modify this parameter.
Attributes
| Attribute | Description |
|---|---|
| Type | Int |
| Default value | 0, which indicates that the default number of threads is 6 |
| Value range | [0, 100] |
| Modifiable | Yes. You can use the ALTER SYSTEM SET statement to modify the parameter. |
| Effective upon OBServer node restart | No. The setting takes effect immediately. |
Considerations
You can also use the inc_sstable_upload_thread_score parameter to specify the number of threads that can be used to execute tasks that reference shared SSTables to local storage.
Examples
Set the number of threads that can be used to execute tasks that reference shared storage incremental data to local storage to 10 in the user tenant.
obclient> ALTER SYSTEM SET attach_shared_sstable_thread_score = 10;
References
For information about how to configure the number of threads that can be used to execute data sharing tasks in shared storage mode, see inc_sstable_upload_thread_score.