Variables #
| Syntax | Description | Type |
|---|---|---|
| SHOW DIST VARIABLES | Query all properties for proxy | RQL |
| SHOW DIST VARIABLE WHERE name = variable_name | Query specified property for proxy | RQL |
| SET DIST VARIABLE variable_name = xx | Config property | RAL |
1. Query All Properties For Proxy #
SHOW DIST VARIABLES
Parameter Explanation
None
Example
SHOW DIST VARIABLES
2. Query Specified Property For Proxy #
SHOW DIST VARIABLE WHERE name = variable_name
Example
SHOW DIST VARIABLE WHERE name = sql_show;
3. Config Property #
SET DIST VARIABLE variable_name = xx
Example
SET DIST VARIABLE sql_show = true
Special variable configuration list
| Example | Description |
|---|---|
| SHOW DIST VARIABLE WHERE name = transaction_type | Query transaction type |
| SET DIST VARIABLE transaction_type = XA | Modify the transaction type of the current connection, support LOCAL, XA, BASE |
| SHOW DIST VARIABLE WHERE name = agent_plugins_enabled | Query the enabling status of the agent plugin |
| SET DIST VARIABLE agent_plugins_enabled = true | Config the enabling status of the agent plugin, the value is boolean |
| SHOW DIST VARIABLE WHERE name = cached_connections | Query the number of connections currently cached |
| SHOW DIST VARIABLE WHERE name = general_query_log | Query the enabling status of full logs |
| SET DIST VARIABLE general_query_log = true | Config the enabling status of full logs |
| SHOW DIST VARIABLE WHERE name = slow_query_log | Query the enabling status of slow logs |
| SET DIST VARIABLE slow_query_log = true | Config the enabling status of full logs |
| SHOW DIST VARIABLE WHERE name = long_query_time | Query slow query threshold |
| SET DIST VARIABLE long_query_time = 5000 | Config slow query threshold, in millisecond |