Session variable management

This topic provides instructions on how to view and modify session variables.

Background information

A connection between an application and a database is referred to as a session. In the SQL Console, you can query detailed information about all sessions connected to the current database on the session variable page. The SQL Console provides a visual interface on the session variable page, allowing users to easily and intuitively query the session variables supported by the current database.

This topic uses the database oceanbase as an example to demonstrate how to query and modify the session variable interactive_timeout.

Prerequisites

You need to have the database account and password for the current tenant to log in to the SQL Console.

Procedure

1. Log in to the SQL Console and click > Set Session Variables in the SQL window.

   

2. On the Session Variable page, you can query all session information supported by the current database oceanbase. Search for the session variable interactive_timeout in the search box.

   

3. As shown above, click to modify the value of interactive_timeout.

   

   Notice

   • Setting ob_trx_idle_timeout too large may cause the session to occupy memory that cannot be released in time. Proceed with caution when setting it.
   • In manual transaction commit mode, ob_trx_idle_timeout must be set greater than or equal to the SQL query timeout set. Otherwise, if the execution interval between two SQL statements in a transaction exceeds the ob_trx_idle_timeout setting, the connection will terminate.

More information

• Access SQL Console

• SQL editing and execution

• PL compilation

• Result set editing

• Execution analysis

• Functional keys in SQL Console