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 was introduced in OceanBase Database V4.1.0 and is supported only in MySQL mode.
- Since OceanBase Database V4.1.0 BP2, the default value has been changed from
5000000to-1(indicating ineffective), and the value range has been changed from [0, 9223372036854775807] to [-1, 9223372036854775807], in microseconds.
| Attribute | Description |
|---|---|
| Type | Integer |
| Default value | -1
NoteThe value |
| Value range | [-1, 9223372036854775807] |
| Effective scope |
|
| Involved in serialization | Yes |