Note
This parameter was introduced in OceanBase Database V4.3.1.
Description
spill_compression_codec specifies the algorithm for compressing data for storage during SQL statement execution.
Limitations
Query the parameter
In the
systenant or a user tenant, you can execute theSHOW PARAMETERSstatement to query the parameter or query theGV$OB_PARAMETERSview for the parameter.Modify the parameter
You can use the
ALTER SYSTEM SETstatement to modify the parameter in thesystenant or a user tenant.
Attributes
| Attribute | Description |
|---|---|
| Type | String |
| Default value | NONE, which specifies not to compress data. |
| Value range |
|
| 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 specify different compression algorithms to reduce the amount of temporary data to be stored during operator execution.
Examples
Set the algorithm for compressing data for storage during SQL statement execution to LZ4.
obclient> ALTER SYSTEM SET spill_compression_codec='LZ4';