Note
This variable was introduced in OceanBase Database V4.2.0 BP2.
Description
ob_default_lob_inrow_threshold specifies the default INROW storage threshold for LOB fields in a table.
Applicability
This variable is applicable to only OceanBase Database Community Edition and is not supported in OceanBase Database Enterprise Edition.
Attributes
| Attribute | Description |
|---|---|
| Type | Integer |
| Default value | 4K. The unit is byte. |
| Value range | [0, 0.75M]. The value 0 indicates that INROW storage is disabled. |
| Effective scope |
|
| Modifiable | Yes. You can use the SET statement to modify the variable. |
Considerations
- If you do not specify
LOB_INROW_THRESHOLDwhen you create a table, the value of this variable is written to the schema of the table. - The modification of this variable does not affect the INROW threshold of existing tables, but affects new tables for which
LOB_INROW_THRESHOLDis not specified.
Examples
In the following example, LOB_INROW_THRESHOLD is not specified:
Set
ob_default_lob_inrow_thresholdto 40,960 bytes.Set the variable at the session level
obclient> SET ob_default_lob_inrow_threshold = 40960;Set the variable at the global level
obclient> SET GLOBAL ob_default_lob_inrow_threshold = 40960;
Create a table named
twithout specifyingLOB_INROW_THRESHOLD.obclient> CREATE TABLE t(pk int, data text);The value of
ob_default_lob_inrow_thresholdis used as the threshold. That is, the INROW threshold of thettable is 40,960 bytes.