Overview
Scenarios
Product Architecture
Instance Types
Compatibility Notes
Usage specification recommendations
INFORMATION_SCHEMA.PERSIST is used to display variables persisted to the MC.Field Name | Type | Description |
VARIABLE_NAME | varchar(64) | Indicates the variable name. |
VARIABLE_VALUE | varchar(1024) | Indicates the variable value. |
SELECT or SHOW.tdsql>SELECT * FROM INFORMATION_SCHEMA.PERSIST;+-------------------------+----------------+| VARIABLE_NAME | VARIABLE_VALUE |+-------------------------+----------------+| tdstore_deadlock_detect | ON || tdsql_lock_wait_timeout | 50 |+-------------------------+----------------+2 rows in set (0.01 sec)tdsql>SHOW PERSIST VARIABLES;+-------------------------+-------+| Variable_name | Value |+-------------------------+-------+| tdstore_deadlock_detect | ON || tdsql_lock_wait_timeout | 50 |+-------------------------+-------+2 rows in set (0.00 sec)
피드백