SET DIST VARIABLE
Description
The SET DIST VARIABLE
syntax is used to set system variables.
Syntax
Grammar Railroad diagram
SetDistVariable ::=
'SET' 'DIST' 'VARIABLE' (proxyPropertyName '=' proxyPropertyValue | 'transaction_type' '=' transactionType | 'agent_plugins_enable' '=' agentPluginsEnable)
proxyPropertyName ::=
identifier
proxyPropertyValue ::=
literal
transactionType ::=
string
agentPluginsEnable ::=
boolean
Supplement
proxy_property_name
is one of properties configuration ofPROXY
, name is split by underscoretransaction_type
is use to set transaction types for current connection, supportsLOCAL
,XA
,BASE
agent_plugins_enable
is use to set theagent
plugins enable status, the default value isFALSE
system_log_level
is the system log level, only affects the log printing ofPROXY
, the default value isINFO
Example
- Set property configuration of
Proxy
SET DIST VARIABLE sql_show = true;
- Set transaction type for current connection
SET DIST VARIABLE transaction_type = “XA”;
- Set
agent
plugin enable status
SET DIST VARIABLE agent_plugins_enabled = TRUE;
Reserved word
SET
, DIST
, VARIABLE
Related links
当前内容版权归 ShardingSphere 或其关联方所有,如需对内容或内容相关联开源项目进行关注与资助,请访问 ShardingSphere .