ob_max_read_stale_time specifies the maximum latency allowed in weak-consistency reads. The default value is -1, which indicates that this feature is disabled.
You can specify different latency thresholds for different sessions. OceanBase Database detects the data latency based on the weak-consistency read version. Therefore, the value of this parameter cannot be smaller than the weak-consistency read version of OceanBase Database, which is specified by weak_read_version_refresh_interval. For more information about the weak_read_version_refresh_interval parameter, see weak_read_version_refresh_interval.
Note
The default value is changed from 0 to -1 since ODP Community Edition V4.2.0 and ODP Enterprise Edition V4.2.1.
| Attribute | Description |
|---|---|
| Parameter type | Integer |
| Default value | -1 |
| Value range | [-1, +∞) |
| Effective only after ODP restart | No |