ob_max_read_stale_time specifies the maximum latency threshold in microseconds 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 the 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] to [-1, 9223372036854775807] in microseconds.
| Attribute | Description |
|---|---|
| Type | INT |
| Default value | -1
NoteThe value -1 indicates ineffective. |
| Value range | [-1, 9223372036854775807] |
| Applicable scope |
|
| Involved in serialization | Yes |