ob_max_read_stale_time

Description

ob_max_read_stale_time specifies the maximum delay threshold (in microseconds) for weak-consistency reads.

Privilege requirements

• Query variables

  • Global level

    The sys tenant and all user tenants can execute the SHOW VARIABLES statement or query the information_schema.GLOBAL_VARIABLES view (MySQL-compatible mode) to view the value of a global system variable.

  • Session level

    The sys tenant and all user tenants can execute the SHOW VARIABLES statement or query the information_schema.SESSION_VARIABLES view (MySQL-compatible mode) to view the value of a session system variable.

• Modify variables

  • Global level

    • The sys tenant can directly modify the value of a global system variable.

    • A MySQL user tenant can modify the value of a global system variable only if it has the SUPER or ALTER SYSTEM privilege.

  • Session level

    The sys tenant and all user tenants can directly modify the value of a session system variable.

Attributes

Usage notes

The session-level setting specifies the maximum delay threshold for weak-consistency reads. Data read by weak-consistency read requests in the current session must be within the specified delay threshold. Different sessions can have different delay thresholds.

Examples

Set the maximum delay threshold for weak-consistency reads to 5000000 us.

• Session level

  obclient> SET ob_max_read_stale_time =5000000;
  

• Global level

  obclient> SET GLOBAL ob_max_read_stale_time =5000000;