session_track_state_change

Overview

session_track_state_change specifies whether to include information about session state changes in the returned OK packet.

Privilege requirements

• Query variables

  • Global level

    The sys tenant and all user tenants can use the SHOW VARIABLES statement or the information_schema.GLOBAL_VARIABLES view (in MySQL-compatible mode) to view the values of global system variables.

  • Session level

    The sys tenant and all user tenants can use the SHOW VARIABLES statement or the information_schema.SESSION_VARIABLES view (in MySQL-compatible mode) to view the values of session system variables.

• Modify variables

  • Set the variable at the global level

    • The sys tenant can directly modify the values of global system variables.

    • MySQL user tenants must have the SUPER or ALTER SYSTEM privilege to modify the values of global system variables.

  • Set the variable at the session level

    The sys tenant and all user tenants can directly modify the values of session system variables for their own tenants.

Attributes

Configuration example

Set the returned OK packet to include information about session status changes.

• Set the variable at the session level

  obclient> SET session_track_state_change = 1;
  

• Effective globally

  obclient> SET GLOBAL session_track_state_change = 1;