In the PolarDB-X 1.0 console, you can view instance and database parameters and modify parameter values as needed.
Note
- If your instance is read-only, you can set only Database parameters, and cannot set Instance parameters.
- Some parameters are only supported for instances of specific versions. For more information, see Parameter description.
Parameter description
Level | Parameter | Description | Supported version |
---|---|---|---|
Instance | SLOW_SQL_TIME | The threshold for slow SQL queries. SQL queries that exceed this threshold are recorded in slow logical SQL logs. | 5.3.4-15378085 or later. |
LOGIC_IDLE_TIMEOUT | The timeout period for an idle connection between the client and the PolarDB-X 1.0 instance. Unit: milliseconds. | 5.3.4-15378085 or later. | |
MAX_ALLOWED_PACKET | The maximum size of a packet between the client and the PolarDB-X 1.0 instance. Unit: bytes. | 5.3.4-15378085 or later. | |
Database | MAX_POOL_SIZE | The maximum number of connections between a PolarDB-X 1.0 database and a single ApsaraDB for RDS database shard. | All versions. |
MIN_POOL_SIZE | The minimum number of connections between a PolarDB-X 1.0 database and a single ApsaraDB for RDS database shard. | All versions. | |
IDLE_TIMEOUT | The timeout period for an idle connection between a PolarDB-X 1.0 database and an ApsaraDB for RDS database shard. | All versions. | |
SOCKET_TIMEOUT | The timeout period for an SQL query sent from PolarDB-X 1.0 database to an ApsaraDB for RDS database. | All versions. | |
FORBID_EXECUTE_DML_ALL | Specifies whether to prohibit full table deletion and update. | All versions. | |
TEMP_TABLE_MAX_ROWS | The size of an intermediate temporary table used during distributed queries in PolarDB-X 1.0. | 5.3.4-15378085 or later. | |
MERGE_UNION_SIZE | The maximum number of table shards that can be combined by executing the UNION statement when you query multiple table shards in a database. | 5.3.4-15378085 or later. | |
PURE_ASYNC_DDL_MODE | Specifies whether to enable the pure asynchronous-mode when the asynchronous data
definition language (DDL) engine is enabled.
|
5.3.4-15378085 or later. | |
ENABLE_RANDOM_PHY_TABLE_NAME | Specifies whether a random name is used for a physical table. | 5.4.4 or later. |