session_track_schema

Overview

session_track_schema specifies whether to include schema change information in the returned OK packet.

Privilege requirements

• Query variables

  • Global level

    Both 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

    Both 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

Configure the returned OK packet not to contain schema change information.

• Session effective

  obclient> SET session_track_schema = 0;
  

• Effective globally

  obclient> SET GLOBAL sql_mode = 0;