ob_max_read_stale_time specifies the maximum latency threshold in μs for weak-consistency read queries. The weak-consistency read latency threshold is controlled at the session level. For weak-consistency read requests of the current session, the data read must be within the specified latency threshold. You can set different latency thresholds for different sessions.
Note
- This variable is introduced since OceanBase Database V4.1.0 and is supported only in MySQL mode.
- Since OceanBase Database V4.1.0 BP2, the default value is changed from 5000000 to -1 (indicating ineffective), and the value range is changed from [0, 9223372036854775807] μs to [-1, 9223372036854775807] μs.
| Attribute | Description |
|---|---|
| Type | int |
| Default value | -1
Note-1 indicates ineffective. |
| Value range | [-1, 9223372036854775807] μs |
| Applicable scope |
|
| Involved in serialization? | Yes |