Note
This view is available starting with V1.4.
Purpose
This view records global server status variables of OceanBase Database, including the current number of active connections and the database uptime.
Columns
| Column | Type | Nullable | Description |
|---|---|---|---|
| VARIABLE_NAME | varchar(128) | NO | The name of the global status variable. |
| VARIABLE_VALUE | varchar(1024) | YES | The value of the global status variable. |
Sample query
Query the global server status variables and their corresponding values in OceanBase Database.
obclient [oceanbase]> SELECT * FROM information_schema.GLOBAL_STATUS;
The query result is as follows:
+-------------------+----------------+
| VARIABLE_NAME | VARIABLE_VALUE |
+-------------------+----------------+
| Threads_connected | 1 |
| Uptime | 254110 |
+-------------------+----------------+
2 rows in set