ApsaraDB for OceanBase (Deprecated):Global variable management

Background information

A global variable is a database variable for global management and control of a database.

On the Global Variables page of ODC, you can query and modify all database variables for the current data source.

Query global variables

Assume that you want to query database variables of the data sourcemysql420in the SQL development window.

1. In the left-side navigation pane, choose O&M Management > Global Variables.

   

2. Select the data sourcemysql420and click OK.

   

3. On the Global Variables page, you can query all database variables of the data sourcemysql420.

   

Edit global variables

Assume that you want to modify the value of the database variableconnect_timeout for the data sourcemysql420in the SQL development window.

1. Search for the connect_timeout database in the search field.

   

2. In the Session Attributes list, click the variable name connect_timeout and then click the Edit button to change the value to20.

   

3. In the SQL Confirmation dialog box, modify and confirm the SQL statement and click Execute.

   

4. In the Session Attributes list, you can view the new value of the connect_timeout variable.

References

• Session management

• Recycle bin management