Note
This parameter was introduced in OceanBase Database V4.3.5.
Description
The recover_table_concurrency parameter specifies the maximum number of tables that can be concurrently restored during the table import phase of cross-tenant table restoration. This parameter applies only to table-level restoration.
Privilege requirements
Query the parameter
Users in the
systenant and all user tenants can execute theSHOW PARAMETERSstatement or query theGV$OB_PARAMETERSview to query the parameter.Modify the parameter
Users in the
systenant and user tenants can modify the parameter.
Attributes
| Attribute | Description |
|---|---|
| Type | Int |
| Default value | 0 |
| Value range | [0, 16] |
| Modifiable | Yes. You can execute the ALTER SYSTEM SET statement to modify the parameter. |
| Effective upon OBServer node restart | No. The parameter takes effect immediately after it is set. |
Considerations
This parameter is used to control the maximum number of tables that can be concurrently restored during the table import phase of cross-tenant table restoration. For more information about the table-level restoration process, see Restore process.
For more information about parallel restoration, see Restore data by table.
Example
Set the maximum number of tables that can be concurrently restored during the table import phase of cross-tenant table restoration in the mysql tenant to 3.
obclient> ALTER SYSTEM SET recover_table_concurrency = 3 TENANT = 'mysql';