ob_default_lob_inrow_threshold

最終更新:2026-09-03 07:23:57

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.

This variable is applicable to only OceanBase Database Community Edition and is not supported in OceanBase Database Enterprise Edition.

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	Global Session
Modifiable	Yes. You can use the `SET` statement to modify the variable.

If you do not specify LOB_INROW_THRESHOLD when 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_THRESHOLD is not specified.

In the following example, LOB_INROW_THRESHOLD is not specified:

Set ob_default_lob_inrow_threshold to 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 t without specifying LOB_INROW_THRESHOLD.
```
obclient> CREATE TABLE t(pk int, data text);
```
The value of ob_default_lob_inrow_threshold is used as the threshold. That is, the INROW threshold of the t table is 40,960 bytes.

次のトピック