net_read_timeout

Description

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

Privilege requirements

• Query variables

  • Global level

    sys tenant and all user tenants can query the value of global variables by executing the SHOW VARIABLES statement or by querying the SYS.TENANT_VIRTUAL_GLOBAL_VARIABLE view (Oracle mode) or the information_schema.GLOBAL_VARIABLES view (MySQL mode).

  • Session level

    SHOW VARIABLES or by querying the SYS.TENANT_VIRTUAL_SESSION_VARIABLE (Oracle mode) or information_schema.SESSION_VARIABLES (MySQL mode) views. Session system variables are accessible in the sys tenant and all user tenants.

• Modify variables

  • Global level

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

    • The user of the MySQL user tenant must have the SUPER or ALTER SYSTEM privilege to modify the value of global system variables.

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

  • Session level

    You can modify the session system variables of the sys tenant or user tenants.

Attributes

Guidelines

When the server reads data from a client, net_read_timeout specifies the value of timeout for how long to wait until interrupting the server operation.

Examples

SET GLOBAL read_rnd_buffer_size = 30;

• Session level

  obclient> SET net_read_timeout =30;
  

• Global level

  obclient> SET GLOBAL net_read_timeout =30;