Manage global variables

Background information

Global variables are parameters with a global scope that manage database variables and control the global behavior of the database.

On the Global Variables page in OceanBase Developer Center (ODC), you can query and modify all database variables for the current data source.

Query global variables

This example shows how to query database variables for the mysql420 data source in the SQL developer window.

1. In the SQL developer window, click Operations Management > Global Variables.

2. Select the mysql420 data source and click Confirm.

3. On the Global Variables page, view all database variables for the mysql420 data source.

Edit a global variable

This example shows how to change the value of the connect_timeout database variable for the mysql420 data source in the SQL developer window.

Item	Example value
Data source	mysql420
Database variable	connect_timeout

1. In the search box, search for the connect_timeout database variable.

2. In the session attribute list, click the connect_timeout variable name, click the edit button, and then change the value to 20.

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

4. In the session attribute list, view the updated value of the connect_timeout variable.

References

• Session management

• Recycle bin management