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)
Was this page helpful?
You can also Contact sales or Submit a Ticket for help.
Help us improve! Rate your documentation experience in 5 mins.
Feedback