Overview
Scenarios
Product Architecture
Instance Types
Compatibility Notes
SET PERSIST is used to persistently configure parameters by node type. This command propagates the specified parameter settings to all nodes of the same type, ensuring that configuration changes remain effective after cluster restart.--node-typeSET PERSIST [NODE_TYPE] variable = expr [, variable = expr];--Without specifying the node type, it is converted to SET PERSIST [NODE_TYPE] based on the node type of the node running the command, where NODE_TYPE represents the node type of that node.SET PERSIST variable = expr [, variable = expr];
Parameter | Required | Description |
NODE_TYPE | Optional | Node type for persisting parameters. Optional values: hyper: Peer node.storage: Storage node responsible for data storage and management.engine: Computing engine node.cdc: Data change capture node.columnar: Columnar storage node.log_only: Log node.Parameters will only be synchronized to the corresponding types of nodes. |
variable | Required | Resource parameter name. |
expr | Required | Resource parameter value. |
-- Check current parameter settingstdsql3_sys_local@localhost [(none)]> SHOW VARIABLES LIKE "max_connections";+-----------------+-------+| Variable_name | Value |+-----------------+-------+| max_connections | 15750 |+-----------------+-------+1 row in set (0.02 sec)-- Set the maximum number of connections for Hyper nodestdsql3_sys_local@localhost [(none)]> SET PERSIST HYPER max_connections = 20000;Query OK, 0 rows affected (0.00 sec)-- Verify parameter settingstdsql3_sys_local@localhost [(none)]> SHOW VARIABLES LIKE "max_connections";+-----------------+-------+| Variable_name | Value |+-----------------+-------+| max_connections | 20000 |+-----------------+-------+1 row in set (0.01 sec)
피드백