Overview
sync_io_thread_count specifies the number of threads for synchronous I/O requests. Typically, the default adaptive configuration can fully utilize the bandwidth of synchronous I/O devices. If the latency of synchronous I/O requests becomes excessive, you can increase the number of threads for synchronous I/O.
Privilege requirements
Query parameters
Both the
systenant and all user tenants can query this parameter using theSHOW PARAMETERSstatement or theGV$OB_PARAMETERSview.Modify parameters
Only the
systenant can modify this parameter. User tenants cannot modify it.
Attributes
Attribute |
Description |
|---|---|
| Parameter type | Int |
| Default Value | 0 |
| Value range | [0,1024] |
| 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
When the value of this parameter is 0, it means the following:
When the number of CPU cores is less than or equal to 16,
Number of threads = Number of CPU cores × 6When the number of CPU cores is greater than 16,
Number of threads = 16 * 6 + (Number of CPU cores - 16) * 2
Configuration example
Set the number of threads for synchronous I/O requests to 200.
obclient> ALTER SYSTEM SET sync_io_thread_count = 200;