Overview
Records information for all session variables (including hidden variables starting with "_").
Columns
Field |
Type |
Nullable |
Description |
|---|---|---|---|
| VARIABLE_NAME | varchar(128) | NO | Session Variable Name |
| VARIABLE_VALUE | varchar(1024) | YES | Session Variable Value |
Sample query
Check the value of the session variable ob_trx_timeout.
obclient [oceanbase]> SELECT * FROM information_schema.SESSION_VARIABLES WHERE VARIABLE_NAME='ob_trx_timeout ';
The query result is as follows:
+----------------+----------------+
| VARIABLE_NAME | VARIABLE_VALUE |
+----------------+----------------+
| ob_trx_timeout | 86400000000 |
+----------------+----------------+
1 row in set