net_read_timeout

Description

net_read_timeout specifies the number of seconds to wait for additional data on the connection before interrupting the read operation.

Privilege requirements

• Query variables

  • Global level

    sys tenants and all user tenants can execute the SHOW VARIABLES statement or query the SYS.TENANT_VIRTUAL_GLOBAL_VARIABLE view (Oracle-compatible mode) or the information_schema.GLOBAL_VARIABLES view (MySQL-compatible mode) to view the values of global system variables.

  • Session level

    sys tenants and all user tenants can execute the SHOW VARIABLES statement or query the SYS.TENANT_VIRTUAL_SESSION_VARIABLE view (Oracle-compatible mode) or the information_schema.SESSION_VARIABLES view (MySQL-compatible mode) to view the values of session system variables.

• Modify variables

  • Global level

    • sys tenants 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.

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

  • Session level

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

Attributes

Usage

When the server reads data from the client, net_read_timeout specifies the timeout value for interrupting the read operation.

Examples

Set the number of seconds to wait for additional data on the connection before interrupting the read operation to 30.

• Session level

  obclient> SET net_read_timeout =30;
  

• Global level

  obclient> SET GLOBAL net_read_timeout =30;