View tenant system variables

System variables in OceanBase Database can be configured to meet business requirements. This topic describes how to view the system variables of a tenant.

View tenant system variables using the SHOW statement

1. Log in to a user tenant of the cluster using the root user.

   For example, for the mq_t1 tenant:

   obclient -h172.30.xx.xx -P2883 -uroot@mq_t1#cluster -p**** -A
   

2. Execute the SHOW statement to query the system variables:

   SHOW [SESSION | GLOBAL] VARIABLES [LIKE 'pattern' | WHERE expr]
   

   where

   • SESSION | GLOBAL: SESSION indicates session-level system variables and GLOBAL indicates global-level system variables. If not specified, session-level system variables will be displayed by default.
   • pattern: indicates the variable keyword.

   Here is an example:

   • Query the session variables for ob_query_timeout:

     obclient [oceanbase]> SHOW VARIABLES LIKE 'ob_query_timeout';
     +------------------+-------------+
     | Variable_name    | Value       |
     +------------------+-------------+
     | ob_query_timeout | 10000000    |
     +------------------+-------------+
     1 row in set
     
     # or
     
     obclient [oceanbase]> SHOW SESSION VARIABLES LIKE 'ob_query_timeout';
     +------------------+-------------+
     | Variable_name    | Value       |
     +------------------+-------------+
     | ob_query_timeout | 10000000    |
     +------------------+-------------+
     1 row in set
     

   • Query the global variables for ob_query_timeout:

     obclient [oceanbase]> SHOW GLOBAL VARIABLES WHERE variable_name LIKE 'ob_query_timeout';
     +------------------+-------------+
     | Variable_name    | Value       |
     +------------------+-------------+
     | ob_query_timeout | 10000000    |
     +------------------+-------------+
     1 row in set
     

Query tenant system variables using views

References

For more information about system variables, see the following topics:

• Overview
• Modify system variables of a tenant